SQL Pattern: How can I count the number of comma separated values in a string?
Knowledge DropLast tested: Aug 16, 2017 This might not be a common request, but the method to do so is below:S...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
How do BigQuery OAuth connections work with GCP IAM?
Knowledge DropLast tested: Jun 26, 2020 BigQuery customers have the option of using OAuth for BigQuery connect...
SnowflakeSQLException: JDBC Driver encountered communication error. Message: HTTP status=400
Knowledge DropLast tested: Nov 3, 2020 HTTPS 400 = Bad Request. See: https://developer.mozilla.org/en-US/docs/...
Dealing with reserve Words in Athena
Knowledge DropLast tested: Apr 13, 2020 Scenario:We have a table in that we want to query in Athena, whose col...
Creating Primary Key for repeated nested field in BQ
Knowledge DropLast tested: Apr 3, 2020 If you run into a BQ challenge where no primary key was present in any ...
A Cure For Merged Results
Knowledge DropLast tested: Jan 29, 2021 Let's say that we have the salary table stored in our PostgreSQL datab...
Can I use a transient schema for PDTs?
Knowledge DropLast tested: Aug 19, 2020 What are transient schemas? https://docs.snowflake.com/en/user-guide/t...
Duration type returning imprecise data
Knowledge DropLast tested: Jul 24, 2020 Date/time diffs tend to count whole units between timestamps - if a du...
What to do if you try to calculate the distance between identical locations and get ACOS values that are out of the [-1,1] range?
Knowledge DropLast tested: Sep 14, 2017 You can check for those coordinates that are identical, then add a sma...
BIGQUERY (HowTo): BigQuery Cluster and Partition Best Practices
Knowledge DropLast tested: Sep 21, 2018Default to INNER join If LEFT is required, denormalize, nest, or figure...
Bigquery Error while reading table: Found corrupted data while opening file
Knowledge DropLast tested: Jun 30, 2020 This error indicates that one of the tables being queried has 'corrupt...
Generate Date Series/ Create a calendar view of future dates
Knowledge DropLast tested: Aug 26, 2019Some dialects have a generate_series function that makes this trivial. ...
