Problem triggering Cloud Functions with Looker Actions
Hello everyone,I spent the last two days trying to figure out how to trigger a Cloud Function from Looker.I ha...
Forum Posts
Seeking Advice: Running a Chisq_test or T-test in Looker for Conversion Analysis
Hello everyone, I'm new to Looker and I'm interested in conducting a conversion analysis. I would like to perf...
BigQuery Table Sampling: LookML Syntax Explanation
Table sampling is a feature that enables users to query random subsets of data from a large BigQuery tables, w...
Update(write-back) data on BigQuery from Looks?
Is there a way to let users update data on DB right from looks? I read about actions here but I found it very ...
Partition pruning from looker filters based on labels
Hi,we have bigquery table as source for our view/explore.This table has (to simplify) columns:REGION_NAME, REG...
How do you handle this string 2023-01-06T00:00:00.000Z when casting as timestamp
Hello!I’ve been working in Looker trying for at least an hour to try to cast this string format (in a table co...
Point to one or another table based on date filter
Hi!I have two tables on BQ, one table has the historical information (= 2022).I’m trying to create a Liquid se...
Issue working with time fields from BigQuery inside Dimension in LookML
I have a TIME field inside my source table in BigQuery that have the time (hh : mm :ss) of my transactions:Whe...
Auto-Switch between Dev & Prod Schema and PDTs
I would like to share an approach to auto-switch between development and production datasets on a single looke...
Inherit labels from BigQuery
Hello community!We use labels in bigquery to define ownership of datasets and tables, e.g. fact_attributions i...
How to connect tables in datasets belonging to different projects
i have a requirement, where i need to join tables in different datasets belonging to different projects
Designing the perfect model
What is the best approach when you have billions of rows in one table, should I make a star schema and make ag...
Firebase Block - Derived Tables Issue
I am currently using the Firebase block available on Github. When generating one of the predefined derived tab...
LookML cannot parse Liquid
Hi Looker team,Database Dialect: BigQueryContext:We build the SQL-based derived tables.In the SQL, there are s...
Conditionally multiplying a numeric filter
We have an implementation of Period-over-Period analysis that we’ve paired with a date granularity filter so t...
Google analytics GA4 Block LookML error
I have connected GA4 block and setup the connection successfully , most of the dashboards are working fine exc...
Finding closest matches by name in BigQuery
We’ve all been there before: someone gives you a dataset without ID’s, keyed only by name. You either file it ...
Best practice: writing views in BigQuery vs Looker
We have a daily data feed to BigQuery for most of our data tables. In the past we used SQL Runner in Looker to...
Convert String ($1,234.50) to Number field
I have a string field that contains a dollar figure of total cost. It is a string field but I need it to be nu...
Convert String (yyyy-mm-dd) to Date field
I have a field in my database that is a string field but it contains dates in the following format: “yyyy-mm-d...
Using Looker to send data to analytics
Hi everyone, I’m fairly new to Looker and I’ve been looking for info about this for a few days, and I don’t re...
display historical pipeline with hubspot deal_stage table from fivetran
When I am working on cRM data, I always use the crm block form keboola with a bit of the salesforce block. I w...
GoogleJsonResponseException: API call to bigquery.jobs.query failed with error: Access Denied: Project ppc-big-query: User does not have bigquery.jobs.create permission
I’m having issues running a BigQuery function from the submit button in the sidebar. The query function works ...
[Analytic Block] Supercharge your KPI tracking for multi-dimensional dataset: Looker and BQML
Hi there @Looker Community! We have been recently working on the topic of KPI tracking and implementation of t...
bigquery daily shared tables and different date selectors (ga4 app exports)
Hi there, we are trying to set up a GA4 bigquery integration (marketplace block does not work, we have too man...
Convert UTC to local time zone in Looker (have bigquery database)
I am not able to convert my UTC timestamp column to a local destination timezone using a different column in m...
Dimension does not execute in explore
I have:dimension: fl { type: string sql: CONCAT('flt-', ${departure_date}, '_' , ${oa.iata}, '-', ${da.iata}) ...
How to convert table string column(which is having time stamp in 1609999 format) to date format in looker
I have table which hold timestamp in number format but the data type of the table column is string.How to type...
Machine Learning
Machine learning is a subfield of artificial intelligence, which is broadly defined as the capability of a mac...
Does anyone know how to code custom dimension to get "week_end_date" as a new dimension? Versus week_start_date.
Hello Looker community,I would like to find a way to create a new dimension grouping data for a datatype date ...