Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
#
bigquery
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Embarking on the Big Query Quest: Exploring the Depths of its Inner Workings
Matheus Tramontini
Matheus Tramontini
Matheus Tramontini
Follow
Sep 24
Embarking on the Big Query Quest: Exploring the Depths of its Inner Workings
#
bigquery
#
googlecloud
#
bigdata
#
learning
Comments
Add Comment
5 min read
How to pass an Array of Structs in Bigquery's parameterized queries
matthieucham
matthieucham
matthieucham
Follow
for
Stack Labs
Oct 15
How to pass an Array of Structs in Bigquery's parameterized queries
#
bigquery
#
python
#
googlecloud
#
sql
9
 reactions
Comments
Add Comment
3 min read
Working with Gigantic Google BigQuery Partitioned Tables in DBT
Stephen
Stephen
Stephen
Follow
Sep 20
Working with Gigantic Google BigQuery Partitioned Tables in DBT
#
bigquery
#
dbt
#
dataengineering
#
googlecloud
1
 reaction
Comments
Add Comment
3 min read
Google’s Arcade Program - A Gateway to Creative Coding, Dev-ops, Sec Ops, and More.
Ogunkola Adeola
Ogunkola Adeola
Ogunkola Adeola
Follow
Oct 9
Google’s Arcade Program - A Gateway to Creative Coding, Dev-ops, Sec Ops, and More.
#
googlecloud
#
arcade
#
bigquery
#
cloudcomputing
Comments
1
 comment
3 min read
Snowflake vs. BigQuery: Choosing the Right Cloud Platform for Your Data
Onix Cloud
Onix Cloud
Onix Cloud
Follow
Aug 5
Snowflake vs. BigQuery: Choosing the Right Cloud Platform for Your Data
#
cloud
#
googlecloud
#
bigquery
#
dataengineering
Comments
Add Comment
2 min read
Loading data to Google Big Query using Dataproc workflow templates and cloud Schedule
Jader Lima
Jader Lima
Jader Lima
Follow
Sep 6
Loading data to Google Big Query using Dataproc workflow templates and cloud Schedule
#
gcp
#
dataproc
#
bigquery
#
bigdata
2
 reactions
Comments
Add Comment
12 min read
BigQuery's New JSON Functions: Struct vs. JSON - Choosing the Right Structure
Marcelo Costa
Marcelo Costa
Marcelo Costa
Follow
Aug 25
BigQuery's New JSON Functions: Struct vs. JSON - Choosing the Right Structure
#
bigquery
#
googlecloud
#
database
1
 reaction
Comments
Add Comment
3 min read
Automatically Update BigQuery View Schema Changes
matthieucham
matthieucham
matthieucham
Follow
for
Stack Labs
Jul 30
Automatically Update BigQuery View Schema Changes
#
bigquery
#
eventdriven
#
googlecloud
#
dataengineering
3
 reactions
Comments
Add Comment
5 min read
What is QUALIFY in BigQuery | Understanding QUALIFY in BigQuery: A Guide for Data Scientists | BigQuery Tips
Kemal Cholovich
Kemal Cholovich
Kemal Cholovich
Follow
Jul 17
What is QUALIFY in BigQuery | Understanding QUALIFY in BigQuery: A Guide for Data Scientists | BigQuery Tips
#
bigquery
#
gdg
#
gcp
#
bigqueryqualify
1
 reaction
Comments
Add Comment
4 min read
BigQuery Schema Generation Made Easier with PyPI’s bigquery-schema-generator
Noela Tenku
Noela Tenku
Noela Tenku
Follow
Jul 9
BigQuery Schema Generation Made Easier with PyPI’s bigquery-schema-generator
#
data
#
dataengineering
#
bigquery
#
python
5
 reactions
Comments
2
 comments
2 min read
Clustering in BigQuery (Dynamic Filters & External Queries)
Charlotte Towell
Charlotte Towell
Charlotte Towell
Follow
May 23
Clustering in BigQuery (Dynamic Filters & External Queries)
#
bigquery
#
gcp
#
sql
#
database
Comments
Add Comment
3 min read
MySQL to BigQuery Migration (Syntax & Other Conversions)
Charlotte Towell
Charlotte Towell
Charlotte Towell
Follow
May 19
MySQL to BigQuery Migration (Syntax & Other Conversions)
#
bigquery
#
mysql
#
sql
#
database
Comments
Add Comment
3 min read
Scheduling a BigQuery SQL script, using Apache Airflow, with an example
Raju Nekadi
Raju Nekadi
Raju Nekadi
Follow
May 3
Scheduling a BigQuery SQL script, using Apache Airflow, with an example
#
airflow
#
bigquery
#
dataengineering
#
sql
7
 reactions
Comments
1
 comment
2 min read
How to combine BigQuery with DuckDB
Marcelo Costa
Marcelo Costa
Marcelo Costa
Follow
Apr 27
How to combine BigQuery with DuckDB
#
bigquery
#
googlecloud
#
duckdb
#
analytics
21
 reactions
Comments
Add Comment
3 min read
Applying graph theory for inferring your BigQuery SQL transformations: an experimental DataOps tool
Λ\: Clément Bosc
Λ\: Clément Bosc
Λ\: Clément Bosc
Follow
for
Stack Labs
Apr 16
Applying graph theory for inferring your BigQuery SQL transformations: an experimental DataOps tool
#
dataops
#
bigquery
#
googlecloud
#
data
12
 reactions
Comments
Add Comment
7 min read
Dump/export Cassandra/BigQuery tables and import to Clickhouse
Kiswono Prayogo
Kiswono Prayogo
Kiswono Prayogo
Follow
Feb 27
Dump/export Cassandra/BigQuery tables and import to Clickhouse
#
cassandra
#
bigquery
#
clickhouse
#
tutorial
Comments
Add Comment
2 min read
Building a project in DBT
Cris Crawford
Cris Crawford
Cris Crawford
Follow
Feb 24
Building a project in DBT
#
dbt
#
dataengineering
#
bigquery
#
sql
Comments
Add Comment
5 min read
Stay Fresh: Four Ways to Track Update Times for BigQuery Tables and Views
Metaplane
Metaplane
Metaplane
Follow
Mar 1
Stay Fresh: Four Ways to Track Update Times for BigQuery Tables and Views
#
freshness
#
bigquery
#
sql
#
tutorial
Comments
Add Comment
3 min read
Four Efficient Techniques to Retrieve Row Counts in BigQuery Tables and Views
Metaplane
Metaplane
Metaplane
Follow
Mar 1
Four Efficient Techniques to Retrieve Row Counts in BigQuery Tables and Views
#
rowcounts
#
bigquery
#
sql
#
tutorial
Comments
Add Comment
4 min read
How to use BigQuery Query Caching with Dynamic Wildcard Tables
Marcelo Costa
Marcelo Costa
Marcelo Costa
Follow
Dec 29 '23
How to use BigQuery Query Caching with Dynamic Wildcard Tables
#
bigdata
#
googlecloud
#
bigquery
#
python
Comments
Add Comment
2 min read
Google Cloud to Big Query with Mage
Cris Crawford
Cris Crawford
Cris Crawford
Follow
Jan 28
Google Cloud to Big Query with Mage
#
mage
#
gcs
#
bigquery
#
dataengineering
2
 reactions
Comments
Add Comment
2 min read
How to build an Anomaly Detector using BigQuery
Chloe Caron
Chloe Caron
Chloe Caron
Follow
Jan 18
How to build an Anomaly Detector using BigQuery
#
dataengineering
#
datascience
#
bigquery
#
machinelearning
4
 reactions
Comments
Add Comment
12 min read
A cost-efficient and event-driven BigQuery loading for Intermediate Data Engineers
Adam Hamidallah
Adam Hamidallah
Adam Hamidallah
Follow
for
Stack Labs
Dec 12 '23
A cost-efficient and event-driven BigQuery loading for Intermediate Data Engineers
#
tutorial
#
googlecloud
#
architecture
#
bigquery
13
 reactions
Comments
2
 comments
7 min read
Using Python and ORM (SQLAlchemy) with Google BigQuery
chanon-mike
chanon-mike
chanon-mike
Follow
Nov 30 '23
Using Python and ORM (SQLAlchemy) with Google BigQuery
#
python
#
bigquery
#
googlecloud
#
tutorial
8
 reactions
Comments
Add Comment
2 min read
Google BigQuery: A Beginner’s Guide
DbVisualizer
DbVisualizer
DbVisualizer
Follow
Nov 23 '23
Google BigQuery: A Beginner’s Guide
#
bigquery
Comments
Add Comment
9 min read
How to Impersonate a Service Account Using Bigquery Client Library
Marcelo Costa
Marcelo Costa
Marcelo Costa
Follow
Sep 30 '23
How to Impersonate a Service Account Using Bigquery Client Library
#
googlecloud
#
bigquery
#
cloudcomputing
#
security
1
 reaction
Comments
Add Comment
2 min read
Running Transformations on BigQuery using dbt Cloud: step by step
J
J
J
Follow
Aug 10 '23
Running Transformations on BigQuery using dbt Cloud: step by step
#
bigquery
#
dbt
#
codenewbie
1
 reaction
Comments
Add Comment
6 min read
Batch rename BigQuery tables with SQL
Ivan N
Ivan N
Ivan N
Follow
Aug 3 '23
Batch rename BigQuery tables with SQL
#
bigquery
#
gcp
#
sql
#
regex
2
 reactions
Comments
Add Comment
3 min read
How to Stream Data From Firebase to BigQuery Easily
Adebola
Adebola
Adebola
Follow
Jun 24 '23
How to Stream Data From Firebase to BigQuery Easily
#
firebase
#
bigquery
#
googlecloud
#
firestore
1
 reaction
Comments
Add Comment
3 min read
How to Compare the BigQuery table schemas between many tables from different datasets
Kemal Cholovich
Kemal Cholovich
Kemal Cholovich
Follow
May 30 '23
How to Compare the BigQuery table schemas between many tables from different datasets
#
bigquery
#
scripts
#
python
3
 reactions
Comments
Add Comment
2 min read
Manipulating Complex Structures in BigQuery: A Guide to DDL Operations
iamtodor
iamtodor
iamtodor
Follow
for
FreshBooks
May 26 '23
Manipulating Complex Structures in BigQuery: A Guide to DDL Operations
#
bigquery
8
 reactions
Comments
1
 comment
7 min read
Handling Duplicates in BigQuery
Idris Rampurawala
Idris Rampurawala
Idris Rampurawala
Follow
May 24 '23
Handling Duplicates in BigQuery
#
gcp
#
bigquery
#
webdev
#
database
4
 reactions
Comments
Add Comment
3 min read
Python's BigQuery External CVS tables and null_marker challenge
iamtodor
iamtodor
iamtodor
Follow
May 22 '23
Python's BigQuery External CVS tables and null_marker challenge
#
bigquery
#
python
#
externaltables
Comments
Add Comment
2 min read
How to clone tables in BigQuery
Marcelo Costa
Marcelo Costa
Marcelo Costa
Follow
May 18 '23
How to clone tables in BigQuery
#
bigquery
#
bigdata
#
dataengineering
2
 reactions
Comments
Add Comment
1 min read
BigQuery deduplication strategies
Sagnik Bandyopadhyay
Sagnik Bandyopadhyay
Sagnik Bandyopadhyay
Follow
Apr 30 '23
BigQuery deduplication strategies
#
bigquery
#
sql
#
googlecloud
#
data
4
 reactions
Comments
Add Comment
5 min read
Como evitar SQL Injection utilizando client do BigQuery
Gabriel Ferreira
Gabriel Ferreira
Gabriel Ferreira
Follow
Mar 20 '23
Como evitar SQL Injection utilizando client do BigQuery
#
bigquery
#
sqlinjection
#
node
#
javascript
Comments
Add Comment
1 min read
Bigquery public datasets
Ankit malik
Ankit malik
Ankit malik
Follow
Mar 19 '23
Bigquery public datasets
#
bigquery
#
programming
#
webdev
#
gcp
2
 reactions
Comments
Add Comment
2 min read
DataWarehouse and BigQuery
Ruma Sinha
Ruma Sinha
Ruma Sinha
Follow
Jan 16 '23
DataWarehouse and BigQuery
#
bigquery
#
datawarehouse
#
bigdata
#
distributedcomputing
1
 reaction
Comments
Add Comment
4 min read
BigQuery: Creating a pipeline between MySql and BigQuery using airflow
J
J
J
Follow
Dec 11 '22
BigQuery: Creating a pipeline between MySql and BigQuery using airflow
#
bigquery
#
airflow
#
codenewbie
#
python
2
 reactions
Comments
Add Comment
4 min read
Lessons learnt from the 8 week sql challenge: string_agg
Marian Eerens
Marian Eerens
Marian Eerens
Follow
Jun 7 '22
Lessons learnt from the 8 week sql challenge: string_agg
#
sql
#
bigquery
#
8weeksqlchallenge
#
sqltips
7
 reactions
Comments
Add Comment
1 min read
Lessons learnt from the 8 week sql challenge: window functions & ranking
Marian Eerens
Marian Eerens
Marian Eerens
Follow
May 4 '22
Lessons learnt from the 8 week sql challenge: window functions & ranking
#
sql
#
bigquery
#
8weeksqlchallenge
10
 reactions
Comments
Add Comment
3 min read
Building GCS Buckets and BigQuery Tables with Terraform
Cem Keskin
Cem Keskin
Cem Keskin
Follow
Apr 3 '22
Building GCS Buckets and BigQuery Tables with Terraform
#
dezoomcamp
#
dataengineering
#
bigquery
#
gcp
4
 reactions
Comments
Add Comment
4 min read
Basic Google Big Query Operations with a Salesforce sync demo in MULE 4
Edgar Moran
Edgar Moran
Edgar Moran
Follow
Feb 17 '22
Basic Google Big Query Operations with a Salesforce sync demo in MULE 4
#
mule4
#
google
#
bigquery
#
mulesoft
3
 reactions
Comments
Add Comment
8 min read
[Feedback] GCP : Cross region Data transfer with BigQuery. Part 2 - Schema drift with the Google Analytics use case
Λ\: Clément Bosc
Λ\: Clément Bosc
Λ\: Clément Bosc
Follow
for
Stack Labs
Jan 28 '22
[Feedback] GCP : Cross region Data transfer with BigQuery. Part 2 - Schema drift with the Google Analytics use case
#
bigquery
#
data
#
googlecloud
#
analytics
2
 reactions
Comments
Add Comment
5 min read
What’s new with BigQuery ?
Λ\: Clément Bosc
Λ\: Clément Bosc
Λ\: Clément Bosc
Follow
for
Stack Labs
Oct 25 '21
What’s new with BigQuery ?
#
database
#
analytics
#
sql
#
bigquery
6
 reactions
Comments
Add Comment
5 min read
BigQuery vs Snowflake: The Definitive Guide
Luke Kline
Luke Kline
Luke Kline
Follow
for
Hightouch
Oct 7 '21
BigQuery vs Snowflake: The Definitive Guide
#
snowflake
#
bigquery
#
analytics
#
datawarehouse
2
 reactions
Comments
Add Comment
9 min read
Export Amazon Aurora to BigQuery using BigQuery Data Transfer Service
moga
moga
moga
Follow
Aug 29 '21
Export Amazon Aurora to BigQuery using BigQuery Data Transfer Service
#
aurora
#
bigquery
#
transfer
4
 reactions
Comments
1
 comment
5 min read
#005 How to Convert JSON to NDJSON?
Kemal Cholovich
Kemal Cholovich
Kemal Cholovich
Follow
Aug 9 '21
#005 How to Convert JSON to NDJSON?
#
ndjson
#
bigquery
#
jq
#
json
4
 reactions
Comments
Add Comment
2 min read
Migrate log analysis from AWS ElasticSearch to BigQuery
Jinwook Baek
Jinwook Baek
Jinwook Baek
Follow
Jan 29 '21
Migrate log analysis from AWS ElasticSearch to BigQuery
#
aws
#
elasticsearch
#
bigquery
#
loganalysis
6
 reactions
Comments
Add Comment
12 min read
Implementing months_between() function in BigQuery
Niko Draganić
Niko Draganić
Niko Draganić
Follow
for
Bornfight
Jan 19 '21
Implementing months_between() function in BigQuery
#
bigquery
#
sql
#
googlecloud
12
 reactions
Comments
2
 comments
6 min read
Export AWS/GCP cost and billing data to BigQuery for analytics
Jinwook Baek
Jinwook Baek
Jinwook Baek
Follow
Dec 31 '20
Export AWS/GCP cost and billing data to BigQuery for analytics
#
aws
#
bigquery
#
gcp
#
analytics
13
 reactions
Comments
5
 comments
9 min read
Slicing and dicing Puppet Forge usage data
Ben Ford
Ben Ford
Ben Ford
Follow
for
puppet
Dec 18 '20
Slicing and dicing Puppet Forge usage data
#
metrics
#
puppet
#
forge
#
bigquery
3
 reactions
Comments
Add Comment
4 min read
Connecting to BigQuery From Excel and Python
Peter Jackson
Peter Jackson
Peter Jackson
Follow
Dec 2 '20
Connecting to BigQuery From Excel and Python
#
bigquery
#
excel
#
python
#
odbcdriver
6
 reactions
Comments
Add Comment
2 min read
Go + BigQuery : Beam for Beginners
Brian Michalski
Brian Michalski
Brian Michalski
Follow
Aug 3 '20
Go + BigQuery : Beam for Beginners
#
apachebeam
#
bigquery
#
go
#
googlecloud
9
 reactions
Comments
1
 comment
6 min read
Getting started with BigQuery
Mr. Yap
Mr. Yap
Mr. Yap
Follow
Feb 27 '20
Getting started with BigQuery
#
bigquery
5
 reactions
Comments
Add Comment
2 min read
Access Google BigQuery Data with Entity Framework 6
Jerod Johnson
Jerod Johnson
Jerod Johnson
Follow
Jan 31 '20
Access Google BigQuery Data with Entity Framework 6
#
csharp
#
sql
#
bigquery
#
tutorial
6
 reactions
Comments
Add Comment
3 min read
Load a JSON file to Google BigQuery using Python
Jordi Escudé Gòdia 🎗️
Jordi Escudé Gòdia 🎗️
Jordi Escudé Gòdia 🎗️
Follow
Nov 19 '19
Load a JSON file to Google BigQuery using Python
#
gcp
#
bigquery
#
python
#
json
10
 reactions
Comments
Add Comment
1 min read
Working with BigQuery Analytic Functions
leibole
leibole
leibole
Follow
Oct 21 '19
Working with BigQuery Analytic Functions
#
bigquery
#
bigdata
#
database
#
sql
6
 reactions
Comments
Add Comment
5 min read
New "State of the Web" video: BigQuery!
Rick Viscomi
Rick Viscomi
Rick Viscomi
Follow
for
Google Web Dev
Jul 4 '19
New "State of the Web" video: BigQuery!
#
bigquery
#
webdev
7
 reactions
Comments
Add Comment
1 min read
Learn BigData from Google Cloud Platform.
saif ali
saif ali
saif ali
Follow
Apr 7 '19
Learn BigData from Google Cloud Platform.
#
machinelearning
#
bigdata
#
bigquery
#
gcp
11
 reactions
Comments
Add Comment
2 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account