Using Looker’s SQL Generator
With Looker, you use LookML to model your database both in a structured and reusable way, and in a way that go...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
Managing Schedules and Alerts in Looker
Mike DeAngelo, Developer Relations Engineer Looker’s “Scheduled Plan” facility can be used to automatically ru...
How do I troubleshoot 401 errors on Looker API calls? (Troubleshooting API authentication)
Review: API AuthenticationWhy do 401 errors happen?1. You did not hit the login endpoint or go through the API...
Can I download a dashboard as a CSV or PDF via the API?
Knowledge DropLast tested: Sep 27, 2019 For PDF: Yes. Use create_render_task() to schedule a job to render a d...
How can I create a new project via the API?
Knowledge DropLast tested: Mar 8, 2018 Use the create_project call on the projects endpoint. https://docs.look...
What is a cURL API call, and what does it look like?
Knowledge DropLast tested: Nov 4, 2020 cURL is a command-line utility available on most Unix/Linux based opera...
Is it possible to connect to the API without an SSL connection?
Knowledge DropLast tested: Oct 16, 2020 Nope - connecting to the API requires an https connection with a valid...
How do I get a list of recently viewed dashboards by a user through the Looker API?
1 ) Hit login_user to login as the user (https://docs.looker.com/reference/api-and-integration/api-reference/v...
Can you add, edit, or update table calculations in Looks via the API?
Yes, you can update the query object associated with a Look. There's a property called dynamic_fields which yo...
What does the graph_derived_tables_for_model endpoint do?
You can use the graph_derived_tables_for_model endpoint (documentation) to get a dependency graph of all the P...
Is there any size or character limit on the JSON body for api calls?
Knowledge DropLast tested: Oct 1, 2019 Not that we are aware of.The input boxes on the API Docs might have a l...
Can I switch branches via the API?
Knowledge DropLast tested: May 29, 2018 Yes, the all_git_branches, git_branch, create_git_branch, update_git_b...
Can you bust the cache instance-wide via the API ?
Knowledge DropLast tested: Oct 7, 2019Nope, but you can bust the cache per-model using Datagroups. This post t...
What is the parent_id for my folder?
Knowledge DropLast tested: Mar 22, 2020 Use Case:We want to find metadata about our content so we hit the all_...
Can I create API credentials for an embed user via the API? If not, can I sudo as a user via the API?
Knowledge DropLast tested: Sep 1, 2020 It is not possible to create API credentials for an embed user, so you ...
Can one user have multiple concurrent sessions / tokens in the API in use at once?
Knowledge DropLast tested: Oct 7, 2019Yes. Multiple access tokens can be active concurrently for the same Look...
Schedule to 2 SFTP Servers Via the API
Knowledge DropLast tested: Jan 20, 2020 You can send a single schedule to 2 SFTP servers using the API! In ord...
How does query killing work via the API?
Knowledge DropLast tested: Oct 7, 2019 Here are some facts about queries are killed via the API:Only admin API...
The "How To" on initializing the SDK with different profiles in your ini file
Knowledge DropLast tested: May 13, 2020 For those that don't know, the ini file contains information like clie...
Expand Tables in PDF - API
Knowledge DropLast tested: Jul 20, 2020 We have the pdf_paper_size option for the render_task() endpoint, so w...
How to Move a Look to a New Looker Instance
Knowledge DropLast tested: Jun 25, 2020 You can find the Python script in this repository.The Easy WayUse Look...
API Error (nodename nor servname provided, or not known')
Knowledge DropLast tested: Jan 10, 2019 When you have an issue with API authentication and received the follow...
How do I get a list of dashboards that a user has access to via the API?
Knowledge DropLast tested: Dec 28, 2017 First, you will want to pull down the content_metadata_id and id field...
Automatic Looker API Auth Token Renewal in Postman
Knowledge DropLast tested: 8/26/2022Note: This content is also available on Github. Are you lazy like me and w...
Can you use the search_dashboards() API endpoint to get information about LookML dashboards?
Knowledge DropLast tested: Mar 9, 2020No. The search_dashboards() endpoint doesn't return LookML dashboards at...
Why are my API-accessed JSON objects returning numbers instead of strings?
Knowledge DropLast tested: Oct 7, 2019There was a legacy feature that allowed JSON numbers to return as string...
Steps for Creating a New User (email creds, role, group) via Python SDK
Knowledge DropLast tested: Nov 8, 2020 There are a few steps to creating a new user with the api/sdk. We have ...
Can you edit a look's visualization settings using the API?
Knowledge DropLast tested: Jun 12, 2018 Yep, you can configure a visualization of a query using the query.vis_...
Group API - User Attribute Group Value
Knowledge DropLast tested: Oct 24, 2019 We can use this endpoint to set or update an individual user attribute...
In the `update_datagroup` api call, will: {“stale_before”: now()} bust the cache?
Knowledge DropLast tested: Oct 1, 2019 Yes, this will blow the cache for that datagroup regardless of the trig...
-
sam8Staff
-
Dr__StrangeloveStaff
-
corgi-lookerStaff
-
chrissieaStaff
-
LookerExpertsStaff
-
veronica_philliStaff
-
Erin_DocsStaff
-
Emma_DocsStaff
-
kendocsStaff
