Hello everyone,I spent the last two days trying to figure out how to trigger a Cloud Function from Looker.I ha...
Hello everyone, I'm new to Looker and I'm interested in conducting a conversion analysis. I would like to perf...
Table sampling is a feature that enables users to query random subsets of data from a large BigQuery tables, w...
Is there a way to let users update data on DB right from looks? I read about actions here but I found it very ...
Hi,we have bigquery table as source for our view/explore.This table has (to simplify) columns:REGION_NAME, REG...
Hello!I’ve been working in Looker trying for at least an hour to try to cast this string format (in a table co...
Hi!I have two tables on BQ, one table has the historical information (= 2022).I’m trying to create a Liquid se...
I have a TIME field inside my source table in BigQuery that have the time (hh : mm :ss) of my transactions:Whe...
I would like to share an approach to auto-switch between development and production datasets on a single looke...
Hello community!We use labels in bigquery to define ownership of datasets and tables, e.g. fact_attributions i...
i have a requirement, where i need to join tables in different datasets belonging to different projects
What is the best approach when you have billions of rows in one table, should I make a star schema and make ag...
I am currently using the Firebase block available on Github. When generating one of the predefined derived tab...
Hi Looker team,Database Dialect: BigQueryContext:We build the SQL-based derived tables.In the SQL, there are s...
We have an implementation of Period-over-Period analysis that we’ve paired with a date granularity filter so t...
I have connected GA4 block and setup the connection successfully , most of the dashboards are working fine exc...
We’ve all been there before: someone gives you a dataset without ID’s, keyed only by name. You either file it ...
We have a daily data feed to BigQuery for most of our data tables. In the past we used SQL Runner in Looker to...
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...
I have a field in my database that is a string field but it contains dates in the following format: “yyyy-mm-d...
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...
When I am working on cRM data, I always use the crm block form keboola with a bit of the salesforce block. I w...
I’m having issues running a BigQuery function from the submit button in the sidebar. The query function works ...
Hi there @Looker Community! We have been recently working on the topic of KPI tracking and implementation of t...
Hi there, we are trying to set up a GA4 bigquery integration (marketplace block does not work, we have too man...
I am not able to convert my UTC timestamp column to a local destination timezone using a different column in m...
I have:dimension: fl { type: string sql: CONCAT('flt-', ${departure_date}, '_' , ${oa.iata}, '-', ${da.iata}) ...
I have table which hold timestamp in number format but the data type of the table column is string.How to type...
Machine learning is a subfield of artificial intelligence, which is broadly defined as the capability of a mac...
Hello Looker community,I would like to find a way to create a new dimension grouping data for a datatype date ...