Looker
by Google
Looker's System Activity model logs who ran which query, how long it took and which dashboards and Looks people open, while the API can also run saved queries and return their results. Copying both into the Lake helps BI owners prune unused content and lets governed LookML numbers be compared with figures from other tools.
- Category
- Cloud & Data Platforms
- Type
- BI & reporting
- Interface
- REST API
- Built with
- Connect Any API
- Credentials
- OAuth 2.0, API key
- Docs
- Looker API docs
02Data
What you can sync.
- Query results
- Looks
- Dashboards
- Users
- System activity
Put Looker query results next to revenue and usage, so every cost has an owner and a reason.
Need more? Name any other Looker data the API returns, and the AI adds it to the connector.
03Credentials
Credentials you will need.
- OAuth 2.0 (client ID, client secret, refresh token)
- An API key
Looker uses OAuth 2.0 (client ID, client secret, refresh token) or an API key. You add the credentials once, when the AI asks for them, and it tells you where to create them in Google if you need help.
04Questions
Questions you can answer.
Once Looker data is in your Lake, ask an AI Mind in plain words or build the answer in DataPrism BI.
- Which dashboards have had no views in 90 days, and who owns them?
- Which explores produce the slowest queries, and which users run them most?
- How many active Looker users does each department have this quarter?
- Do revenue figures returned by our main Looker query match the numbers finance reports?
05How it works
How it works in DataMind.
-
Pick Looker.
Open Lake, pick Looker in the source picker and name the connection. Connect Any API opens with a ready prompt that points the AI at the Looker API docs.
-
Answer a few questions.
The AI reads the Looker documentation, then asks which credentials you will use, which data to sync (for example query results and looks), whether you want a one-time load or a recurring sync, and which accounts or filters apply.
-
Your data lands in Lake.
It builds the connector, tests it and shows you sample rows. Then Looker data loads into your Lake on your schedule, ready for the Warehouse, DataPrism BI and AI Minds.
06Pairs
Works well with Looker.
Sources teams join with Looker in the Warehouse, each one connected the same way.
