Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started153 News & announcements128 Who's hiring443 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1890 SQL327
Exploring & curating dataExplores579 Dashboards & looks1624
Application developmentEmbedding Looker / Powered by Looker162 Open source projects56 Looker API388
AdministrationUser access & management77 General Looker administration464
Data science & analyticsGot a question?87 Share your best practices16
The Kitchen TableTechnical Tips & Tricks1741 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥4
コミュニティフォーラム (Japanese)ニュースと告知51 ヘルプとサポート14 コラム69

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2111 Topics

Recently active

Most replies Most views Newest first

Department of Customer LoveModerator

published in Technical Tips & Tricks

Will selecting "Update" on my License Key affect active LookML code changes or kick off PDTs?Knowledge Drop

Last tested: Jun 23, 2017 No. Selecting "Update" on the License Key admin setting will only ping the license server. It should not impact any ongoing code changes and it should not kick off any PDTs.The "Update" setting is used in the event that a user's license feature is already enabled but the end user cannot see that license feature on their instance. After clicking "Update" you will see the following message: "License verified and updated successfully." This content is subject to limited support.

320

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can we define a view: parameter within a Model file? An explore: within a View file?Knowledge Drop

Last tested: Jun 28, 2021 This is technically possible, but we recommend against it, mainly for readability and organizational purposes. There are very few instances where it would be recommended/preferable to do this.You can technically define any object you want inside any file. The LookML parser starts at a model file, and then prepends the model file with any files in include: statements, making one "giant file". So, in this way, it doesn't really matter which file view or explore objects are defined in.For best practices, it is much cleaner to keep all explores inside model files, to keep view objects inside view files, and to only define one view per view file. You may encounter atypical types of modeling either in discourse examples, like this one, where we give an example like this:connection: "bigquery_publicdata_standard_sql" explore: persons {join: persons_cities_lived {....join: persons_phone_number {.....}} view: persons {} view: persons_cities_lived {....} view: persons_p

230

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Error: Not authorized to run scheduled planKnowledge Drop

Last tested: May 25, 2020 This error may come up in existing schedules that "worked" fine due to scheduling permissions changing from instance wide to model specific in 6.24.The biggest post 6.24 change is that yeah, for system_activity the schedule owner has to be an admin because schedule content is on the model level and system activity cannot be added on a model set level. This content is subject to limited support.

840

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

For scheduled PDFs, why do some PDFs timeout < 30 mins but others can successfully run after 60+ mins?Knowledge Drop

Last tested: Jul 26, 2017 You can see this behaviour because the render timeout (in most cases) will only run after the underlying query runs and completes.For example:Underlying query runs and completes in 20mins After 20 minutes, the PDF Renderer has 30 minutes to successfully complete. In Total, when viewing Plans in Admin, the PDF schedule can say successfully run in ~ 45 mins, where total time is [Query time] + [Render time]So, the entire schedule can compete or fail and the overall time can be >30 mins.And, then in unique scenarios:If dashboard has a default filter Underlying query does not run PDF render starts running In total, when viewing Plans in Admin, the total time is based on Render time onlySo the entire schedule can complete or fail, but the overall time will be < 30 mins. This content is subject to limited support.

500

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can I see user event activity in system activity? For example, seeing which users committed code?Knowledge Drop

Last tested: May 13, 2020 Yes, we have the /event and /event_attribute explores in system activity. Those explores will have Event Category and Event Names. The event_attribute explore has more robust information on the details of things that were changed.A few example Event Names are below:create_project login create_connection create_dashboard update_dashboard git_commit git_create_branch git_delete_branch create_role update_role create_content_metadata_access delete_content_metadata_accessCheck out this doc to see a comprehensive list of all event types.Here are some examples of cool things you can find:Event Explore use cases Event Attribute Explore use cases This content is subject to limited support.

210

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

"This filter contains an error and won't be included in the query"Knowledge Drop

Last tested: Aug 14, 2018 This warning message comes up when there is a character mismatch between the field being filtered and the values that are entered in it, like so:One "gotcha" can be if the values were copied and pasted from another place like gmail -- there could be some weird character formatting in that carries over even if you can't see it visually. Verify that you're using a plain text editor or csv to source the values you paste in. This content is subject to limited support.

260

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Steps for Creating a New User (email creds, role, group) via Python SDKKnowledge Drop

Last tested: Nov 8, 2020 There are a few steps to creating a new user with the api/sdk. We have to first create the user, which gives us an ID -> we then write the credentials for the user (think email, LDAP, etc.) -> from there we can assign that user to a group, assign them roles, etc.Below is a script that includes all the necessary sdk calls, this is all wrapped in a single function to call for convenience:import looker_sdkfrom looker_sdk import models ### Create User, Write Email Creds, Assign Roles and Groups ### # initialize sdksdk = looker_sdk.init40(config_file='looker.ini') firstName = "Spike"lastName = "Spiegel"emailName = "swordfishII@somegalaxy.com"roles = [184,36]group = 76 ### function to create new user ###def newUser(fname, lname, email_address, roleIds, groupId): # create user with idnew_user_obj = sdk.create_user(body=models.WriteUser(first_name=fname, last_name=lname)) # assign email credentialsuser_with_email = sdk.create_user_credentials_email(user_id=new_u

2640

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Render Job, "query failed" Error MessageKnowledge Drop

Last tested: Oct 28, 2020 Error occurred while generating this dashboard - contact administrator (error: Render job XXX failed [query failed: Query failed with unexpected exception Failed to kill query]Any render jobs that have an error message starting with query failed: mean there was just a DB problem when running a query -- nothing specific to rendering or scheduling. Check the underlying tiles of the dashboard or look. If dashboard trying running each/downloading each individually to help isolate the error. This content is subject to limited support.

1930

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

What are mode=0 & mode=1 in active_derived_table?Knowledge Drop

Last tested: Nov 10, 2020 The mode column indicates the state of the derived table.mode=0 being inserted into active_derived_table indicates that a table needs building. 2020-09-10 00:35:53.872 +0000 [INFO|5f59582f04833e9887e4d4b663f993dd|db:looker] :: (0.000946s) INSERT INTO `active_derived_table` (`key`, `structure`, `dead_at`, `name`, `connection`, `mode`, `model`, `retired_at`, `full_view_name`) VALUES ('TH9V2WU3F8FXOODPMURFG_some_table', 'THEQ5ULC9Z5BC1VYH13EF_some_table', 0, 'LR$TH9V21599698153866_some_table', 'some_model', 0, '', 32503593600, 'some_table' mode=1 being inserted into active_derived_table indicates that a regen thread has picked up this table and begun building in (typically the entry for the mode=1 build claim will have a pdt log action of "create begin" & pdt log action data of "prod." 2020-09-10 00:35:53.892 +0000 [INFO|5f59582f04833e9887e4d4b663f993dd|db:looker] :: (0.000916s) INSERT INTO `active_derived_table` (`key`, `structure`, `name`, `connection`, `d

100

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

PDT Logs: Consecutive Trigger ChecksKnowledge Drop

Last tested: Nov 2, 2020 If you happen to come across consecutive trigger datagroup check's equal to true for a given table in the pdt event logs and you have confirmed that the cron job shouldn't be causing this, this is likely because we fire off multiple trigger checks before the regenerator builds a PDT.The first trigger check is sent when the regenerator starts its run, the second when it gets around to actually building the table. Note that there will always be a trigger check of true before the regenerator begins building a pdt and as such the last true trigger check should indicate/match up with the time in which the create begin event is logged for the given PDT. This content is subject to limited support.

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

What is errorsfallback@looker.com?Knowledge Drop

Last tested: Sep 12, 2019 ProblemUsers will sometimes see the email address errorsfallback@looker.com in their SMTP logs; this is our error server where emails reporting exceptions will fall back to if their custom SMTP settings block our access to sending emails to Sentry.SolutionThe best way to change this behavior is to allowlist traffic to errorsentry.looker.com, but if that's not possible you can also change which email address to send exceptions to with the --error-emails-to=<s> startup flag. This content is subject to limited support.

230

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can you edit a look's visualization settings using the API?Knowledge Drop

Last tested: Jun 12, 2018 Yep, you can configure a visualization of a query using the query.vis_config property. First call create_query to create a new query with the desired visualization, then create a new look or update an existing look to assign the id of the query you created to the look's query_id property. (look.query is read-only)The content of vis_config varies with each visualization type and is not documented. The best way to figure out what vis_config properties to set to get a particular visualization is to configure a visualization in the Looker UI then use the API to see the resulting query.vis_config properties. This content is subject to limited support.

790

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Does looker change the table(html) schedule format to an attachment if the table results are "too big"?Knowledge Drop

Last tested: Aug 9, 2017 Yes. This content is subject to limited support.

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can you use 2FA with OauthKnowledge Drop

Last tested: Dec 16, 2020 nopeyou can either have 2fa on top of email/pass or google oauth This content is subject to limited support.

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Hide Filters on Embedded DashboardKnowledge Drop

Last tested: Jun 17, 2020 When you hide filters (Un-toggle show filters) on an embedded dashboard -will the dashboard still run the filters?Yes!Hiding of filters just hides them from the UI, so the filters will still be applied (either it is the default filter value in the setting, or if we were to pass a filter value through the url) This content is subject to limited support.

2680

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Model Names in the Same InstanceKnowledge Drop

Last tested: Aug 12, 2020 In the same instance, you can't have two models with the same name, even if they are in different projects.But in the case of imported projects, they can have the same name.A user was wondering if you can import the same remote project twice in difference projects on the same instance. The answer is yes! when you import a project, the imported lookml files don't actually live on this project - hence it is okay if two imported projects have the same model names. This content is subject to limited support.

380

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

This "connection" is overridden by a "connection" declared in a file included belowKnowledge Drop

Last tested: Mar 17, 2020 This is a warning from the content validator - and it's pretty straightforward - you can first check if the included view files have a connection parameterBut if not - you can also check if the view files included the model file! This content is subject to limited support.

890

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Embed Showing Blank Tiles (granting "All" models)Knowledge Drop

Last tested: Nov 3, 2020 If...the dashboard in the iframe is loading in okay, but the tiles are blank (or have a dash on it) the admin query panel shows that these queries erred out "access denied" in the detailsCheck if your models are right in the embed urlYou can't use "All" to include all models, you also cannot use a model set, you need to include each individual model This content is subject to limited support.

290

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Why is my alert icon not showing on hoverKnowledge Drop

Last tested: Jun 25, 2020 Check if you have the required permissionshttps://docs.looker.com/admin-options/settings/roles#create_alertsotherwiseYou might be in dev mode!!! This content is subject to limited support.

740

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

How to Handle \n in dimensions - Newline_to_br LiquidKnowledge Drop

Last tested: Oct 24, 2019 Liquid Reference for newlinedimension: variable {type: stringsql: ${TABLE}.variable ;;html: {{ variable | newline_to_br }} ;;} This content is subject to limited support.

1250

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Group API - User Attribute Group ValueKnowledge Drop

Last tested: Oct 24, 2019 We can use this endpoint to set or update an individual user attribute's group value- https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/group#set_user_attribute_group_valueWe can use this endpoint to set or update an individual or multiple group values in one call, using an array. https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/user-attribute#set_user_attribute_group_values This will not update all groups in the instance, but only the groups we specify in the array. This content is subject to limited support.

990

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Boxplot error message: "Can only combine like series on a single axis."Knowledge Drop

Last tested: Jul 10, 2019 If you see the above error on a boxplot visualization, change the chart type to line and go to Edit Visualization -> Y. We shouldn't have extra Y-axis in the line visualization configuration. Boxplots can only have a single Y-axis value. The boxplot inherits the config we had on the line visualization.Also, check if the Y-axis is showing the 5 measures or "stacked" - it needs to be the 5 measures you want to check. This content is subject to limited support.

540

1 year ago

Page 43 / 85

Badges

sbrylowskihas earned the badge Friendly Face
carriehas earned the badge Helpful
carriehas earned the badge Community Star
carriehas earned the badge Friendly Face
Dawidhas earned the badge Community Star

Show all badges

Sign up

Already have an account? Login

Social Login

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the Terms of Service.

If you’re an EEA-based consumer of digital content, services, or goods, and you’ve agreed to our Terms of Service, then EEA consumer laws provide you with a legal guarantee. Under this guarantee, we’re liable for any lack of conformity that you discover for the one-time supply of digital content or services at any time during the “continuous” supply of digital content or services.
Your national laws may provide an even longer guarantee. Your rights under these legal guarantees aren’t limited by any other commercial guarantees that we provide. If you want to make a guarantee claim or if you would like to delete your account data, please contact us lookerconnect-help@google.com.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

The Kitchen Table

Will selecting "Update" on my License Key affect active LookML code changes or kick off PDTs?Knowledge Drop

Can we define a view: parameter within a Model file? An explore: within a View file?Knowledge Drop

Error: Not authorized to run scheduled planKnowledge Drop

For scheduled PDFs, why do some PDFs timeout < 30 mins but others can successfully run after 60+ mins?Knowledge Drop

Can I see user event activity in system activity? For example, seeing which users committed code?Knowledge Drop

"This filter contains an error and won't be included in the query"Knowledge Drop

Multiple Measures not supported in Map VisKnowledge Drop

Can you restore a folder after you delete it?Knowledge Drop

Why is my custom map layer not loading in public embed?Knowledge Drop

Steps for Creating a New User (email creds, role, group) via Python SDKKnowledge Drop

Render Job, "query failed" Error MessageKnowledge Drop

What are mode=0 & mode=1 in active_derived_table?Knowledge Drop

PDT Logs: Consecutive Trigger ChecksKnowledge Drop

What is errorsfallback@looker.com?Knowledge Drop

Can you edit a look's visualization settings using the API?Knowledge Drop

Does looker change the table(html) schedule format to an attachment if the table results are "too big"?Knowledge Drop

Can you use 2FA with OauthKnowledge Drop

Hide Filters on Embedded DashboardKnowledge Drop

Model Names in the Same InstanceKnowledge Drop

This "connection" is overridden by a "connection" declared in a file included belowKnowledge Drop

Embed Showing Blank Tiles (granting "All" models)Knowledge Drop

Why is my alert icon not showing on hoverKnowledge Drop

How to Handle \n in dimensions - Newline_to_br LiquidKnowledge Drop

Group API - User Attribute Group ValueKnowledge Drop

Boxplot error message: "Can only combine like series on a single axis."Knowledge Drop

Badges

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded