General Looker administration
All your administration & self-hosting questions and content
- 451 Topics
- 1,199 Replies
Hi all,We have several dashboards which be available in Looker web application and also embedded in our application (the production environment)How I can get total dashboard views by “source of view”, i.e., Looker or Embedded Best,
Looker migrate_internal_data to Mysql 5.7 is failing with table 'active_pdt_materialize_task' doesn't exist
Looker Jar version : 21.30.xOS : AWS Linux 2Java: 1.8.xWe are trying to migrate the internal Hypersql DB to Mysql, Please find the migration logs below:[gclooker@ip-xxx-xx-xx-xxx looker]$ java -Xms26000m -Xmx26000m -jar looker.jar migrate_internal_data looker-db.ymlSource database connection successfulDestination database connection successfulTables createdBegin copying dataBegin copying records for table: access_tokenCopied 0 for access_token in 0.00460505485534668 secBegin copying records for table: action_hub_secret_user_stateCopied 0 for action_hub_secret_user_state in 0.001283884048461914 secBegin copying records for table: action_hub_state_authenticationCopied 0 for action_hub_state_authentication in 0.005942821502685547 secBegin copying records for table: active_data_maintenance_taskCopied 0 for active_data_maintenance_task in 0.008505105972290039 secBegin copying records for table: active_derived_tableCopied 1 for active_derived_table in 0.01741194725036621 secSequel::Database
Something odd with the version we are using, it has only 1 Model Set its ALL … doesn't get us to create new models.It says it is created, i can confirm on the API Explorer route.. But on the admin page no matter what we do it doesnt show.
Hi everyone,We connected Looker with BigQuery and everything is working fine. Now we need to update the JSON key of the Service Account we use for Looker. The process is described here: https://docs.looker.com/setup-and-management/database-config/google-bigquery. Actually, we already have the connection, so we just need to click “Edit” and upload the new key. However, when we do that and we click “Test” to test the connection, we receive a “Validation Failed” error, with no other information 😥. Do you have any idea of what the problem could be?Thanks.
My use case is to analyze which views/tables are least used. I have made a visual in which I have shown view name and their usage time in descending order but some of the lest used views are already deleted. So I want this analysis to be done which are not deleted.
Looker can not start because: Unable to initialize the keystore. Please check your environment. [Invalid keystore options]
Brand new installation of version 22.8.39 running with: start --no-daemonize --no-log-to-file --no-ssl2022-06-06 17:08:12.634 +0000 [INFO|007e4|crypt] :: Initializing GCM Encryption2022-06-06 17:08:12.637 +0000 [FATAL|007e4|crypt] :: Unable to initialize the keystore. [Invalid keystore options]2022-06-06 17:08:12.644 +0000 [ERROR|007e4|encryption_keyset] :: Unable to initialize the keystore. Please check your environment. [Invalid keystore options]lLooker can not start because: Unable to initialize the keystore. Please check your environment. [Invalid keystore options]l2022-06-06 17:08:12.648 +0000 [WARN|007e4|ruby:stderr] :: Looker can not start because: Unable to initialize the keystore. Please check your environment. [Invalid keystore options]2022-06-06 17:08:12.650 +0000 [ERROR|007e4|crypt] :: Unable to initialize the keystore. Please check your environment. [Invalid keystore options] I believe this started with 22.8. How do I disable the keystore? We’re not using SSL.
We are trying to use some Looker features that utilize the chromium-browser, like downloading a PDF or PNG. However, when we choose to download something, a chromium-browser process starts to render the PDF, and the process never finishes.When we show the process-list, with hierarchy, we can see the processes running (they have --type=renderer) but it always times out. See below: root@d78a8793f6e7:/# ps aux -HeUSER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMANDroot 22282 0.0 0.0 18644 3424 pts/1 Ss+ 19:02 0:00 bashroot 19357 0.0 0.0 18632 3488 pts/0 Ss 18:41 0:00 bashroot 30647 0.0 0.0 34408 2888 pts/0 R+ 19:57 0:00 ps aux -Heroot 1 0.8 0.0 55268 20192 ? Ss May17 11:09 /usr/bin/python /usr/local/bin/supervisord -c /supervisord.confroot 8 0.0 0.0 4632 792 ? S May17 0:00 /bin/sh /looker-start.shroot 10 0.0 0.0 4632 1712 ? S May17 0:00 /bin/sh /lo
For the context: My company is merging with a different company and our data sit in two separate instances. However, we have just started the work in Looker within our own enterprise instance but in the near future, all of our work (Looks, dashboards...) will need to move over to a new instance due to the merge.My question is:Is it possible to move all our work in Looker from one instance to another or we have to rebuild everything?The data source of our Looker work resides in a cloud-based data warehouse, which can be transferred to the new instance without big issues.Many thanks
Hi,When I try to install a data dictionary I get an error as below. The URL is correct and I have all necessary privillages. Any idea what is going on?“Could not install listing: Unable to load marketplace project. Invalid target uri: https://github.com/looker-open-source/app-data-dictionary.git. Original Message: Error resolving prototype. Problem cloning remote dependency: Unable to reach repository at "https://github.com/looker-open-source/app-data-dictionary.git". The URL may be incorrect or you have not configured credentials.. Check your manifest.”
I’m genuinely curious what databases are being used. Your experiences with them, good and bad. Would you use something else if you could? Why?For context, we’re almost exclusively using Snowflake. I suppose the honeymoon period has worn off and I’m seeking thoughts on what else works in practice. Not what the platform marketing or new business person says...Thanks in advance for your thoughts.
Hi y’all, We’ve been Looker Partners since 2019, and we use our partner instance for internal training and demo’s to customers. Now a few months back the snowlooker connection which originally pointed at snowflake, got stopped. Is there a BQ alternative? I’ve messaged multiple resource in GCP and Looker on this. Would love to start using this again as it was a great resource. Thanks
Our security team identified that the web server accepts arbitrary origin request header. The application implements cross-origin resource sharing (CORS) policy for this request that allows access from any domain. We tried request with different origins (www.fakedomain.com) and it is accepted by server and valid response is sent back. (poc attached: “cors origin”)Although, in our caseEmbedded Domain Allow list is empty, which we are assuming that it permits request only from our looker domain Same-Origin Protections for Looker Login Pages was enabled still the security team was able to successfully request access from a different domain please help us understand is there any additional steps to be followed to ensure that,request with different origins (www.fakedomain.com) , is not accepted by the server.
It appears I need the Hubspot contact ID to do an update? OK, I can do that.But… what am I updating? it does not say what fields are being updated?I want to update a campaign name or ID to say this email address is now to be associated with this campaign? How do I do that??ALSO … I have setup the Looker Action with my Hubspot API key but when I run a test Hubspot says no activity on the API has occured.Help!!
Is it possible to send a scheduled report to a group of people. But only send to specific people within this group if they meets certain criteria.e.g. filter through the list of users in the group. Then use the user attribute filter and IF this user meets the criteria then send the report to them, if the report does not meet the criteria then do not send the report to that specific user.Currently the report sends to all users in the group if the criteria is met by only 1 person. The idea is to remove spam from everyones mailbox and only send to those who require it.The alternative is to create 30+ schedules for each individual but that would be sub optimal.
Problem: All users are locked out of the instance either because:you enabled SAML/LDAP on your instance without an alternate account login setup, and you set those authentication methods with incorrect configurations you disabled SAML/LDAP while you are logged in to looker via SAML/LDAP without an alternate account login set up Solution: toggle those features OFF via code depending on two situations:If you know your client id/secret: run the custom codes below LDAP: https://github.com/lanlooker/Looker-Tutorials/blob/main/07_Update_LDAP.ipynb SAML: https://github.com/ryookuriki/Looker-Tutorials/blob/main/update_SAML.ipynb If you DON’T know your client id/secret: 1. Have DCL disable the feature for you via Looker Support 2. Obtain client id/secret from Admin > Users for your account 3. Have DCL enable the feature for you via Looker Support (This will most likely lock you out of your instance again 4. Run the code below to toggle the feature OFF LDAP: https://github.com/lanlooker/Loo
Our organization requires specifying server side encryption with all PutObject requests to S3 (see https://docs.aws.amazon.com/AmazonS3/latest/userguide/UsingServerSideEncryption.html).Does Looker provide any way to add additional headers to S3 file delivery? Specifically I need to specify:"s3:x-amz-server-side-encryption": "AES256"
Hey, we are trying to upgrade our Customer/on-prem hosted looker instance version to latest release. And we are facing the below error while starting the looker on an instance.“The --force-gcm-encryption flag can only be used on a new Looker install”“--force-gcm-encryption flag was used but Legacy crypt canary exists” Does anyone faced this issue? May I know how to resolve this?
We’ve followed the instructions outlined here. The encryption migration process returned success, we were able to successfully start the Looker instance, so it looks like it worked, however the database appears to still be unencrypted. Looking through the logs during migration we see that a value `crypt_canary_gcm` was inserted into the `SETTINGS` table, but when we query the Looker DB, we don’t see that value present. Is there anything else we should be looking at to confirm that the migration to GCM was successful? Is there anything else we should be doing to enable DB encryption?
I am trying to install a Looker Block from a Git URL, and I receive the following error during the last step, clicking “Install” after configuring the block:An unexpected problem occurred. Please try again. Below are some screenshots that illustrate the issue:
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.