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...
Forum Posts
How to write failed records while writing to bigquery using Apache python operator writetobigquery.
How to write failed records while writing to bigquery using Apache beam python operator.beam.io.WriteToBigQuer...
CAST function
Hello All, I am wondering if something changed with the format clause for the CAST function in BQ as I have ru...
GA4 -> Bigquery Export Bug
GA4-Export intraday-Table had complete data, but the batch load of that day only includes partially that data....
BQ Stored procedure to to get the SP name
Hi,I have stored procedure running in scheduled basis and i need to capture the running SP name to store in th...
Incompatible data schema
We are dumping multiple CSV files to the sources bucket for a datazone with the same number of columns and sam...
BigQuery "Quota exceeded" when using Redash
Hi all, I have a question about BigQuery errors.I am currently using a BI tool called Redash to access BigQuer...
Exceeded rate limits: too many table dml insert operations for this table
I have a workflow which contain more than 100 actions (type: operations) that will insert/update data into a t...
Dataform: Exceeded rate limits: too many updates for this routine.
Hello All,Im running a dataform workflow with about 35 actions, majority of them has no dependency between eac...
TVF not found!
I have created a Table Valued Function in BigQuery. It is in a dataset set for the location EU. When i try to ...
bq load. Do not create table if does not exist.
I would like to load data in to a table from a file in GCS using the bq load command. However, if the target t...
Storing a list of lists in a pandas dataframe to Big Query from a CSV file
I have stored a Pandas dataframe as a cvs file of which some of the columns are list of lists like [['Dog', 13...
Dataform: "Procedure is not found" error occurring more frequently
Hi all,I'm running multiple Dataform workflows across projects for many months now. But over the last week or ...
Get alerts on specific Dataform job failure from multiple files in a workflow
Hi all,I am using Google Cloud Logging and monitoring to create alerts on my Dataform workflow failures. Is it...
Incremental table for last 120 days - remove data older than that and add current date
Hello,I'm trying to create a table which stores all the events from two other table with some aggregations for...
[BigQuery] Regarding Conversion String to Date Type Issue
Hi there ,I have column which contains timestamp and it is String DatatypeI want cast has Date Data type Used ...
BQ pricing calculator results- Is regional storage expensive than multi-region?
From the new Google Cloud pricing calculator it seems like regional storage is more expensive than multi-regio...
Google Sheet to Dataform
I want to create a model in Dataform that is a live connection to a google sheet that is stored in google driv...
LAB
LAB DOES NOT START AND MANY CREDIT I HAVE LOST IN THIS PROBLEM I SEND MANY COMPLINT NOT RESPONSE AND SOLVED MY...
Google Ads Transfer in BigQuery Does not match conversions with Google Ads Dashboard
Hi everyone, How to fix data discrepancy in conversions from Google Ads into Google Bigquery via BigQuery Data...
Bigquery Data transfer from Facebook API started to fail
Is anyone getting the same error?From last Friday the Facebook API started to fail { insertId: "1mliuo3dxxx" j...
Use a different Quota Project For BigQuery
Hi community,I was trying to use a different quota project (other than my resource project where my BQ data re...
Continuous Queries Roadmap
Hi @nickorlove What's the roadmap for BigQuery Continuous Queries looking like at the moment? I have a team th...
Provide READ access to only BigQuery INFORMATION_SCHEMA objects for the Service Account
I would like to provide READ access to only BigQuery INFORMATION_SCHEMA objects for the service account. May i...
BigQuery EXPORT DATA OPTIONS TO JSON Not retaining cell values with value NULL
We are using EXPORT DATA OPTIONS to export tables to newline delimited JSON files.We are not able to export ta...
Missing and wrong data from Google Ads Data Transfer
Hello,We are using Google Ads Data Transfer to export campaign information and gclid data from Google Ads to B...
rateLimitExceeded for ML.GENERATE_TEXT even after increasing the quota.
Hi There!I'm receiving the error "Exceeded rate limits: too many concurrent queries that use ML.GENERATE_TEXT ...
Can we resolve bigquery API memory limit issues with getting more slots?
Hi, I am currently extracting my GA4 data from bigquery using bigquery APIs. As the GA4 daily hits goes over 2...
BigQuery Slot allocation Levels
What are the different levels BigQuery Slot allocation is possible. Is it possible, like Query level, user lev...
File is being created with wrong date when using data export as a scheduled query
I have a scheduled query in Big Query, set to run daily, is meant to export the results of a SQL query that jo...
Best Practice for Managing BigQuery Resources with Terraform: Dataset vs. Dataset and Tables
I’m working on managing Google BigQuery resources using Terraform and am trying to determine the best practice...