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
Data transfer doesn't copy data to dataset from another dataset
Hi, everyone.I tried to use data transfer.But it seems doesn't work correctly.I want to copy and overwrite dat...
How to calculate total users from GA UA export to BQ Table
hi guys, I have got data from GA UA property in BQ table, i can see that PV, sessions all match with GA UA UI ...
Detect schema change in BigQuery Tables
Hello Googlers,I'm looking for a metadata field that shows when BigQuery table schema was last changed.I've tr...
request to http://${host}/computeMetadata/v1/instance/service-accounts/default/token?scopes=
Hi, I am getting an error 'request to http://${host}/computeMetadata/v1/instance/service-accounts/default/toke...
Big Query append data daily to spreadsheets.
Hello, guys!I have a table in BigQuery with campaign data that is updated daily at 9 am. Every day, I run a qu...
kafka to parquet
I am trying to run a pipeline tha wirtes kafka messages to parquet file. But i can't and it outputs the error ...
Can someone guide me or help me with documentation how can I connect to BigQuery from DBeaver?
I want to connect to BigQuery using DBeaver tool.
Help with JSON extract in BigQuery
Hi everyone!I need some help with an issue I'm facing while working with JSON data.Context:I'm working with a ...
Troubleshooting Connection Errors between Dataform, Cloud Composer, and GitHub
Hey!We started using Dataform with cloud composer recently we started having a lot of this errors where the Da...
Google Drive API AppScript - Failed Access Permission on API call to drive.revisions.list (GoogleJso
Hi all!I have an AppScript linked to a Google Sheet. The Sheet looks as such:Link Metadata https://docs.google...
BigQuery View Generator
We made a small tool for if you are working with JSON in BigQuery and if you want to generate a view from a JS...
Want some guidance/d over How to establish JDBC connection from my JAVA application to the BigQuery?
I am developing application which connect BigQuery project and read data for procession. Can some one guide me...
What is the table name format allowed?
As we have created table name with hyphen(-) , when we try to get data from it we are facing Bad Request (stat...
Access Control for Monitoring Dashboards
Dear Cloud Community Members,I am trying to maintain access control for monitoring custom dashboards.For examp...
Namespace can not be null.
Hello friends, after updating Data Fusion to version 6.10.0, when creating or duplicating a replication task, ...
Operation timeout. Error code 403 in PowerBi Service
Hello,I started getting the following error a few days ago in PowerBi Service:[BigQuery] (115) Operation timeo...
Error while reading data
Hi, I'm trying to create an external table linked to a bucket, the initial load works fine but as the files in...
Dataproc Metastore not syncing metadata to Data Catalog
Hi,we have created a metastore and it has a database and table, post editing the metastore and enabling the Da...
Bigquery GA4 revenue not matching session source / medium
Hi,Does anyone know how to get revenue displaying with non-null source, medium channels?Thank you in advance!S...
GA4 data export to BigQuery stopped since 12th December
GA4 data export to BigQuery suddenly stopped a few days ago. BQ is still linked to GA4 and GA4 is capturing da...
How to create an array of hours between 2 timestamps?
Start_time: 2023-01-01 07:06:00 UTCEnd_time: 2023-01-01 16:03:00 UTCI need hours in between the two timestamps...
Suggestion around looker dashboard
Hello, I've been using looker at Auto Trader now for a couple of years. The insights we get from it are great ...
Export data from Display & Video to Bigquery.
Hello everyone, I have a problem and haven't found a solution yet, the problem is as follows:We have campaign ...
Relay messages from Java Messaging Service (JMS) to Pub/Sub
Hi, I have a JMS topic and would like to relay messages from that topic to Pub/Sub. I see a Dataflow template ...
Name format to create Dataset.
I Would like to know that, does Dataset name accepts only numbers or alphanumerical or alphabets?Case 1: only ...
Transform a Bigquery table to list of json on dataform
Hello, I have a script on definition/query.sqlx: with data as (SELECT array_agg(struct(obj,val)) as x FROM tab...
How to keep data in events_intraday table
Hi there,I would like to force certain data to insert in the events_intraday_YYMMDD table every day.But as soo...
How to write logs from angular localhost to gcp cloud logging.
We have an angular application in which we have implemented open telemetry. Able to see the logs in console.Ho...
como se cuanto va a procesar mi query?
Estoy en una controversia, si bien el cálculo automático me dice que la query va a procesar más de 20 GB, cuan...
Bigquery Storage
One of the GCP project, GCS is utilized to store application logs that are subsequently utilized in BigQuery. ...
Articles from Product Experts and Googlers
Untangle the API maze with Apigee API Hub
Mirror mirror on the wall, What do I do with my API sprawl, Where can I see them all, How to make sure they listen to my call, And to ensure their compliance doesn’t fall. API Hub is the one to rule them all!
Next-Gen Data Pipelines: Airflow 3 Arrives on Google Cloud Composer
We are thrilled to announce that Google is the first hyperscaler to provide selected customers with access to Apache Airflow 3 on our fully managed Cloud Composer 3 service. Discover how powerful new features like DAG Versioning, a modern React-based UI, and scheduler-managed backfills can help you innovate faster and more reliably.
Configuring GKE rollout sequencing
You can manage the order of automatic cluster upgrades across Google Kubernetes Engine (GKE) clusters in multiple environments using rollout sequencing. For example, you can qualify a new version in pre-production clusters before upgrading production clusters.
