Looker
Bring your business data together in Looker, and act on it in the apps your team already uses.
13 ways to read, 2 ways to write, each write switched on by you.
Quality checks
Built and tested with example responses.
- Ready to connect: doneEvery listed action is built in.
- Built and tested with example responses: doneEach action is built from the provider’s published API and tested against example responses, errors, rate limits and paging.
Connected, approved, proven.
The things teams do most with Looker, an example flow with a person in the loop, and what Nexra keeps as proof.
Top actions
- Save a query
queries.createApproval by rule - Send a schedule now
scheduled_plan_runs.sendApproval by rule - Run a saved Look
look_results.listRead
Example flow
- Looker · Run a saved Look
look_results.listDone - Looker · Save a query
queries.createMaker-checker - Nexra · Record the decision and result in the evidence chainProven
Example workflow. Routine runs go through on their own. Only a change your rules flag, such as one over a limit you set, waits for the right person, who sees the exact change and the rule before it reaches Looker.
What gets logged
- Whether it ran on its own or who approved it, and under which rule
- A fingerprint of the exact request sent to Looker
- Looker's reply: what it created or changed
- One entry in the evidence chain, linked to the one before
Try this in the sandbox
Run the whole flow with test data in your sandbox, then connect your own account when you are ready to go live.
For developers
Technical detail
Looker: find and run saved Looks, dashboards and queries, run Explore queries without SQL, list models, folders and schedules, save queries and send a schedule now.
Google Cloud API docs- Source actions
- 13
- Destination actions
- 2
- Data types
- 11
What you can map
Reads are always available. Writes are off until you switch them on for a connection, and governed writes follow your policies.
current user1
- Check the connected Looker userSource
Reads the Looker user whose API key the connection uses.
dashboards2
- Get a dashboard and its tilesSource
Reads one dashboard with its tiles and the Look or query behind each tile.
- Find dashboardsSource
Lists dashboards, optionally by title or folder.
explores1
- Get an Explore's fieldsSource
Lists the dimensions and measures you can pick in an Explore.
folders1
- Find foldersSource
Lists folders, optionally by name or parent folder.
look results1
- Run a saved LookSource
Runs a saved Look and returns its rows (capped).
lookml models1
- List models and ExploresSource
Lists the LookML models you can query and the Explores in each.
looks2
- Get a saved LookSource
Reads one Look: its title, folder, owner and the query behind it.
- Find saved LooksSource
Lists saved Looks (reports), optionally by title or folder, newest change first.
queries1
- Save a queryDestinationNot retried automaticallyApproval before production
Saves an Explore query (fields, filters, sorting) so it can be run again by its ID or opened in Looker. No SQL is written.
query results2
- Run a saved querySource
Runs a saved Looker query by its ID (for example a dashboard tile's) and returns its rows.
- Run a query on an ExploreSource
Picks fields, filters and sorting from an Explore and returns the rows, without saving anything. No SQL is written.
scheduled plan runs1
- Send a schedule nowDestinationNot retried automaticallyApproval before production
Delivers an existing schedule once, right now, to the recipients already saved on it. The schedule itself is not changed.
scheduled plans2
- Check a schedule's last runSource
Reads one schedule, including when it last ran and the status of that run.
- List schedulesSource
Lists scheduled deliveries of Looks and dashboards with when each last ran and its status.
Access and limits
- Authentication
- Looker API key (client ID and client secret)
- Plans and access
- Any Looker (original) instance or Looker (Google Cloud core) instance with API access. Looker (Google Cloud core) editions include different monthly API call allowances. The API key acts as the Looker user it belongs to: it sees only the content, models and schedules that user can. Looker (Google Cloud core) needs an admin to enable API keys for the user first.
- Test environment
- Looker has no separate sandbox. Create a dedicated API user with a restricted role (for example Viewer on a test folder) on your instance, or use a development/staging instance if you have one.
- Rate limits
- Looker returns 429 when calls come too fast and limits each user to 15 running queries at a time (queued queries wait up to 10 minutes). Sending schedules is rate-limited separately. Looker (Google Cloud core) editions also cap monthly API calls. Nexra backs off and honours Retry-After.
- Pagination
- Search reads (Looks, dashboards, folders, models) use limit and offset. Query and Look runs return one capped page of rows.
- Provider events
- Looker can deliver a schedule or alert to a webhook address you configure in Looker; there is no change-event webhook for content. Flows run on demand, on a schedule, or when a scheduled check finds new or changed records.
Before you build a flow
- Runs return at most 5000 rows; Nexra never asks Looker for unlimited results.
- Only Explore queries built from model, Explore, fields, filters and sorts are offered. SQL Runner and custom SQL fields are not offered.
- Looker's search reads have no 'changed since' filter, so there is no incremental read; use the Looks list sorted by most recently changed, or deliver a Looker schedule to a webhook.
- Only Looker addresses on the standard HTTPS port (443) under looker.com or looker.app are accepted. Instances that still use port 19999 must set an API Host URL on port 443 (Admin → Platform → API); custom domains and customer-hosted Looker are not supported.
- Send a schedule now delivers to the schedule's saved recipients only; it is approval-gated like other message sends and never repeated automatically.
- Intentionally excluded: SQL Runner, deleting or editing Looks, dashboards, folders and schedules, creating schedules or alerts, user, role, group and permission management, LookML projects and Git, connections and other admin settings.
Developer reference
- Create the Google Cloud credentials described above with the narrowest permissions your flows need.
- In Nexra, open Connect, then Connections, then New connection, choose Looker, enter its settings and credentials, and tick only the write actions you need. Connection guide
- Test the connection, then use its actions as flow sources and destinations. Flow guide
Machine-readable detail: GET /api/public/connect/connectors/looker and the Connections API.