Influence Looker’s Roadmap and join the BI Customer Council (BICC)
Would you like to influence Google Cloud’s BI roadmap more? I’d like to invite you to join the Google Cloud BI...
Data Analytics
Want more from your data? Have questions about products like BigQuery, Dataflow, or Pub/Sub? You're in the right place. Join conversations around data warehouse modernization, streaming analytics, business intelligence, and more.
Focused on Looker? Engage with the Looker Community here.
Focused on Looker? Engage with the Looker Community here.
Forum Posts
Dataform Declaration Aliases
Say you are trying to declare some data sources, but you have an ugly table name. E.g: config { type: "declara...
Can't select Edition Looker (Google Cloud core) instance.
Hi all,I can't select Edition when creating a Looker instance as the picture below. I did complete all the ste...
before and after trigger in oracle can we implement in gcp bigquery
Triggers can run BEFORE the action is taken or AFTER the action is taken.Can we implement is bigquery.
Instance template creation from Compute Engine VM
I have created a VM Instance based on the requirements and I have installed some applications on it.Is it poss...
Missing datasets in Information_schema and audit tables
Hello, I'm encountering two issues with BigQuery on GCP:1. When querying `region-eu.INFORMATION_SCHEMA.SCHEMAT...
Share Looker content with external whitelisted domain
We are attempting to share all Looker content with an external whitelisted domain. We can successfully share i...
Use cases to share tabular data via GCS instead of BigQuery?
Do you know use cases where analytical data product teams need to give access to gcs bucket objects instead of...
Passing Parameters to Dataform
Hi @ms4446 I have the following use case and shall b grateful if you can help.a) I have an Airflow DAG which I...
Cloud Composer version upgrade - points to take note of?
Hi,I am currently using a Cloud Composer instance with version: composer-2.4.1-airflow-2.5.3. As Composer 2.4....
What is the Data Preparations link on the BigQuery studio?
What is the Data Preparations link on BigQuery studio? Not finding any reference or documentation for this fea...
why dataflow job failed logs are not showing
why dataflow job failed logs are not showing and execution details not available. Checked in log explorer also...
appendRows Cost Big Query
Since appendRows() might not directly correlate with bytes processed by atraditional INSERT statement, it migh...
Missing External Data Configuration Section
Hello, I've been quite reliant on the BQ UI's "external data configuration" to give details on the gsheet/gcs ...
Missing google sheet information (link and range) in BigQuery table info
Hi everyone,I noticed this week that for BigQuery tables sourced from Google Sheets, the link to the Google Sh...
Is there posibility to automatically marked field of table by RED mark
We have RAW table, which has one field marked 'RED" in Tag. Data from this RED field load to another tables in...
Syntax Erro
Hi everyone, Could you help identify where I'm going wrong or have possible issues with this code? I can see B...
Dataform: Exceeded rate limits: too many dataset metadata update operations for this dataset.
Hi,When I run all the actions in my Dataform workspace, some actions fail if the dataset does not already exis...
Why a full table scan when joining a clustered column to another table?
Hi, I have a question about the amount of bytes processed when joining a clustered column with another table. ...
Renaming Columns AS or AT in BigQuery
hi all, does anyone have an idea how to rename Columns AS and AT (columns coming from a Google Sheet have no h...
Vertex AI unresponsive when starting notebook
I've been waiting for this notebook to start for over 24 hours now. It contains over a thousand lines of valua...
I was wondering if there is a way to run a file incrementally in Dataform and use UUID to generate p
I was wondering if there is a way to run a file incrementally in Dataform and use UUID to generate primary key...
Dataplex - BigQuery Labels not updating even after changes in lake
Hi, I have been trying to implement dataplex and noticing weird UI errors. For instance, if a BQ dataset was a...
BigQuery Data Transfer Salesforce Returning No Data to Display
I have bigquery data transfer connected with salesforce.The transfer was succeed and I can see the schema exis...
Dataform Post Operation - Auth views
Hi Team,How to manage Auth view access management via Dataform post operations section? I can add a code in ja...
Missing data from Google Ads transfer
Similar to this topicWe have a Google Ads transfer to bring data into BigQuery. Starting August 8, we are miss...
BQ Monitoring console seems irrelevant for some reason
Hello,I am using BQ heavily in a GCP project without any Org meaning standalone project. Does it mean monitori...
does the dashboards built in GCP monitoring using log analytics supports the filtering using labels?
Hi, I am trying to build dashboards for my cloud run using log analytics but I am not able to create any label...
BigQuery ODBC Driver error - failed to decrypt data (v2.5)
Recently, we have upgraded the simba ODBC driver for Google BigQuery to 2.5.0.1001, and re-created the sytem D...
Resources exceeded during query execution: Google Sheets service overloaded for spreadsheet
So I have a gsheet with 1.5k row and a few simple formulas that is not heavy at all to run. Im consuming this ...
How to Calculate Query Cost?
I am trying to calculate the cost of each BQ query run in an org and for the same, I looking for an exact form...
Articles from Product Experts and Googlers
NLP2SQL using dynamic RAG based few-shot examples
This is a second part of NLP2SQL blog series that explores into a specific approach and reference architecture showcasing the transformative power of Generative AI in revolutionizing database interaction.
Generate SQL from questions in natural language using NLP2SQL
This is a first part of NLP2SQL blog series that explores the overview design guide & best practices related to transformation brought about by Generative AI in the traditional method of database interaction.
Creating a signed embedded Looker iFrame for testing
Learn how to use Looker’s signed iFrame URLs to embed content (Dashboards/Looks) or Explores within customer facing applications.
