Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Topics started by andrew.rose

4 Topics

andrew.rose
Looker Staff
andrew.roseLooker Staff
published in Technical Tips & Tricks

Can I enable SSL for a connection to a MySQL internal DB?Knowledge Drop

Last tested: Jan 18, 2019If you host your own instance, yes, you can. In the looker-db file that contains information about the MySQL connection, add the line "ssl: true" to enable SSL. This content is subject to limited support.                   

110
andrew.rose
Looker Staff
1 year ago
andrew.rose
Looker Staff
andrew.roseLooker Staff
published in Technical Tips & Tricks

How do I calculate the number of digits in a value using table calcs?Knowledge Drop

Last tested: May 18, 2020 We can do this using the power of logarithms! Looker's log() function uses log base 10, so it will return an integer for each value that is a power of 10 - eg. log(1) = 0, log(10) = 1, and so on. So, for integer values of log(x), we can return "log(x) + 1". For all other values, we can round up using the ceiling() function.Here's the syntax:if((ceiling(log(${value})) - log(${value})) < 0.00000001, log(${value})+1, ceiling(log(${value})))One fun thing to note - all of these functions can be used in a custom dimension as well! This content is subject to limited support.                   

260
andrew.rose
Looker Staff
1 year ago
andrew.rose
Looker Staff
andrew.roseLooker Staff
published in Technical Tips & Tricks

How do I reference SAML groups by their AccountName values when setting up SAML authentication using Azure Active Directory?Knowledge Drop

Last tested: Sep 17, 2020 The ProblemBy default, when setting up SAML auth with Azure AD, the SAML groups are brought into Looker by their GUID values. This makes each group name into a long, ugly hash, instead of a human-readable name.A SolutionOne user mentioned that they were able to get Looker to use other formats for their SAML groups in ActiveDirectory - here's the process they used:In Azure AD go to Azure Active Directory > Enterprise Applications > New Application (at the top) > Non-gallery application (at the top) Type the name in (i.e. Looker – Production), and click Add Go to Properties in the new Enterprise Application, enable users for sign-in, disable user assignment required, disable visible to users Go to Single Sign-On section, select SAML Edit the basic SAML configuration, set Identifier to whatever (i.e.https://somenonexistentdomain.biz), set the Reply URL to https://<your_looker_server>:9999/samlcallback, and click Save Edit the User Attributes &

2390
andrew.rose
Looker Staff
1 year ago
andrew.rose
Looker Staff
andrew.roseLooker Staff
published in Technical Tips & Tricks

What standard are Looker's timezones based on?Knowledge Drop

Last tested: Apr 2, 2019 We have a list of timezone settings Looker can use in this doc here: https://docs.looker.com/reference/embedding/timezones​But, where do these timezone names come from? Did we at Looker just make up all these names for different timezones?Nope! These are the names provided by the IANA Time Zone Database. Here's the link to the IANA website, that has downloadable lists of all these timezone names (if users want to access these names in a script they're writing, for example): https://www.iana.org/time-zones​This content is subject to limited support.                 

260
andrew.rose
Looker Staff
1 year ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service