Looker

Events

• New Connection

  Fires when a new connection is created in Looker

• New Look

  Fires when a new look is created in Looker

• Updated Look

  Fires when a look is updated in Looker

Actions

• Create Connection

  Creates a connection in Looker.

  Input Fields

  • Connection Name (text): Name of the connection. Also used as the unique identifier

  • Host (text): Host name/address of server

  • Port (text): Port number on server

  • Username (text): Username for server authentication

  • Password (text): Password for server authentication

  • Certificate(text): Base64 encoded Certificate body for server authentication (when appropriate for dialect). You can use the ‘Base64 encode’ String function.

  • Database (text): Database name

  • Database Timezone (text): Time zone of database

  • Query Timezone (text): Timezone to use in queries

  • Schema (text): Scheme name

  • Max Connections (number): Maximum number of concurrent connection to use

  • SSL? (boolean): Use SSL/TLS when connecting to server,

  • Verify SSL? (boolean): Verify the SSL

  • Tmp DB Name (text): Name of temporary database (if used)

  • JDBC Additional Params (text): Additional params to add to JDBC connection string

  • Pool Timeout(number): Pool Timeout

  • Dialect Name (text):  SQL Dialect name

  • User DB Credentials? (boolean): Are User db credentials enabled.

  • PDT Cron (text):Pacific Daylight TimeCron?

  • Dialect Connection Tests (list of text): Grouping of names of the tests that can be run on a connection using this dialect

  Output Fields

  • Connection
    • Name (text): The name of the connection; also the identifier.

• Create Dashboard

  Creates a dashboard in Looker.

  Input Fields

  • Dashboard Info

    • Title (text): Dashboard title
    • Description (text): Description of the dashboard
    • Hidden? (boolean): If the dashboard is hidden
    • Refresh interval (text): How often the dashboard refreshes. The refresh rate can be any number (without decimals) of seconds, minutes, hours or days.
    • Load Configuration (text): configuration that governs how the dashboard loading will happen.
    • Space ID (text): ID of the space used. required. Found in the URL of the space. (e.g. with URL https://yourcompany.looker.com/spaces/20 , the Space ID would be 20.)
    • Background Color (text): To change the background of the dashboard. The color value can take a hex string like #2ca6cd or a CSS named color string like mediumblue.
    • Show Title? (boolean): To display the title.
    • Title Color (text): To change the color of the title. Can be in hex or a CSS named color string.
    • Show Filters Bar? (boolean): To display the filters bar.
    • Tile Background Color (text): Colors can be in hex or a CSS named color string.
    • Tile Text Color (text): Colors can be in hex or a CSS named color string.
    • Text Tile Text Color (text): Colors can be in hex or a CSS named color string.

  • Dashboard Elements More help with examples here

    • Look ID (text): The ID of the Look
    • Type (text): Type of Element (text, tables, single_value, looker_single_record, looker_column, looker_area, looker-pie, looker_bar, looker_scatter, looker_donut_mulitples, looker_geo_coordinates, looker_geo_choropleth).
    • Listen (text): Dashboards can have filters that allow users to change the data behind dashboard elements. In order for a filter to impact an element, the element must be setup to “listen” for that filter.
    • Refresh Interval (text): The refresh interval for the element.
    • Note Text (text): Text for a note.
    • Note Display (text): Determines where a note is displayed on an element. above places the note at the top of an element, below places it at the bottom of an element, and hover requires the user to hover their mouse over the element in order to see the note.
    • Note State (text): Collapsed or expanded.
    • Title Text (text): Text tile title text.
    • Subtitle Text (text): Subtitle tile title text.
    • Body Text (text): Text tile body text.
    • Look Title (text): look

  • more help for queries 

    • Query ID (number): Query ID
    • User ID (number): User ID
    • Description (text): Description
    • Last Updater ID (number): The ID of the user who last updated the Look.
    • Query Model (text): model
    • Query View (text): view
    • Query Fields (list of text): fields
    • Query Pivots (list of text): pivots
    • Query Fill Fields (list of text): fill fields
    • Query Filters (object): filters.
    • Query Filter Expression (text): Filter expression
    • Query Sorts (list of strings): sorts
    • Query Limit (text): limit
    • Query Column Limits (text): column limit
    • Query Total? (boolean): total
    • Query Row Total (text): raw total
    • Query Runtime (number): runtime
    • Vis Config (object): Visualization Configuration
    • Filter Config (object): Filter Configuration
    • Visible UI Sections (text): Visible UI sections
    • Query Dynamic Fields (list of text): dynamic fields
    • Client ID (text): client id
    • Query Timezone _(text):  _Query timezone

  • Dashboard Layouts

    • Type (text): type
    • Active? (boolean): if it is active
    • Column Width (number): Column width
    • Width (number): width of the dashboard
    • Dashboard Element ID (number): ID of dashboard element added.
    • Row (number): Row
    • Column (number): Column
    • Height (number): Height

  • Dashboard Filters

    • Name (text): Name of filter
    • Title (text): Name of title
    • Type (text): Type of filter; date, number, string, or field.
    • Default Value (text): default value of the filter.
    • Model (text): Model of the filter (required if type=field).
    • Explore (text): Explore of filter; if type = field
    • Dimension (text): Dimension of the filter; if type= field.
    • Listens To Filters (list of text): An array of listeners for faceted filters.

  Output Fields

  • Dashboard
    • Dashboard ID (text): The ID for the new dashboard.

• Create Look

  Creates a Look in Looker.

  Input Fields

  • Look Info
    • Title (text): The title of the look.
    • Query ID (number): Query ID.
    • Description(text): Description of the look.
    • User ID(number): The ID of the user associated with the look.
    • Space ID(text): The ID of the space associated with the look. Found in the URL when you choose to ‘view space’ (e.g. https://mycompany.looker.com/spaces/**20**)
    • Last Updated ID(number): The ID of the user who last updated the look.
    • Model(text): The model.   (ie “employees”).
    • View(text): The view  (ie “employees”).
    • Fields(list of text): A list of fields within the look (i.e. “employees.hire_month”).
    • Sorts(list of text): A list of sorts (i.e. “employees.hire_month desc”).
    • Limit(number): The limit for the look (i.e. “500”).
    • Column Limit(number): The column limit.
    • Total? (T/F): True or False.
    • Client ID(text): The ID of the client
    • Query Timezone(text): The query timezone (i.e “America/Los_Angeles”).

  Output Field

  • Look
    • Look ID(number): The ID of the look created.

• Delete Connection

  Deletes a connection in Looker.

  Input Field

  • Connection Name (text): The name of the connection, which also serves as the identifier.

  Output Fields

  • There are no output fields for this card.

• Delete Dashboard

  Deletes a dashboard in Looker.

  Input Field

  • Dashboard ID (number): The identifier for the dashboard. Can be found under the settings of the dashboard, or in the URL, as the short number at the end.

  Output Fields

  • There are no output fields for this card.

• Delete Look

  Deletes a look in Looker.

  Input Field

  • Look ID (number): The identifier for the look.

  Output Fields

  • There are no output fields for this card.

• Read Connection Details

  Get details of a specified connection

• Read Content Metadata

  Get details of a specified connection

• Read Dashboard

  Get information on a Looker Dashboard

• Read Look

  Get information on a Look

• Run Look

  Run a Look

• Test Connection

  Run tests on a connection

• Update Connection

  Update an existing connection

• Update Content Metadata

  Move a piece of content

• Update Dashboard

  Update a Looker Dashboard

• Update Look

  Update a Look