I am new to BQ and experienced in OLTP RDBMS, I found the data in BQ for my company are mostly in STRING type while it was VARCHAR(255) or even less in the OLTP
I currently have a JSON array that looks like this in Big Query: [{"name":"","username":null},{"name":"Jimmy Dean","username":"iamjc"},{"name":"Ben Simmons","us
I've been struggling for a while to get a query to return the number of sessions and users per source/campaign/medium/content, based on the current session of t
I am running the following cloud function. It runs with success and indicates data was loaded to the table. But when I query the BigQuery no data has been added
I have a query that looks like this SELECT ids FROM `table_name` The results set is as follows | ids | |-----| | 1 | | 2 | | 3 | I need to save this res
currently I am facing issues getting my beam pipeline running on Dataflow to write data from Pub/Sub into BigQuery. I've looked through the various steps and al
I am using a third-party tool that use the Adwords Reporting https://developers.google.com/adwords/api/docs/appendix/reports/all-reports to retrieve data. At th
I understand there's already another post, but it's a bit old and it doesn't really answer the question. I understand that we can use the parameter DATA_SPLIT_
I have a command line that I execute to select data from view and exporting to a staging table in BigQuery: bq mk --transfer_config --headless=true --project_i
I have two datasources - Salesforce(SF) and BigQuery(BQ). All the data from SF is available in BQ. So my question is can we load data from BQ to SF?. Here's w
I am loading parquet file into BigQuery using bq load command, my parquet file contains column name start with number (e.g. 00_abc, 01_xyz). since BigQuery don'
I have a BigQuery table with a column of type "DATE". When I query the table with the nodejs client library as per below, the date elements in the data are obje
The following query sorts a binary column in BigQuery: with tbl as ( select B'123' as col union all select B'234' ) select * from tbl order by col; ----------
I activated google analytics 4 bigquery linking, and it works correctly. I wonder what is the limitation of this link. Api metrics shows that link using api met
I would like to convert all the keys into column headers and all the values into respective average values in a row underneath, grouped by dat
I moved some of my data from PostgreSQL to BigQuery. Before PostgreSQL database was using 130 GB of storage, now I only need 30GB. However, in the Google Cloud
I am trying to connect third party ranking management system (https://tranco-list.eu/) with metabase. Tranco is giving us an option to see the record on Google
I am trying to use analytical functions (e.g. FIRST_VALUE), while still benefiting from from partition pruning. This while the table is partitioned on a DATETIM
Is there anyway to avoid formatting the comments? To reproduce, paste below example SQL code to BQ: --important comment on table info select * from mytable1;
I'm trying to run the following query but it keeps throwing this error after it keeps running for around 1 to 2 hours An internal error occurred and the reques
axe