Skip to content
Navigation menu
Search
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
Geolocation with BigQuery: De-identify 76 million IP addresses in 20 seconds
Felipe Hoffa
Felipe Hoffa
Felipe Hoffa
Follow
for
Google Cloud
Jul 8 '19
Geolocation with BigQuery: De-identify 76 million IP addresses in 20 seconds
#
gcp
#
bigquery
#
sql
#
gis
14
reactions
Comments
Add Comment
5 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
12
reactions
Comments
2
comments
7 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
11
reactions
Comments
2
comments
6 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
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
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
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
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
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
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
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
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
6
reactions
Comments
Add Comment
1 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
6
reactions
Comments
5
comments
9 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
5
reactions
Comments
Add Comment
4 min read
Mercado Libre Goes Big(Query), Moneyball Goes Cloud, Plus Plugging a $300B Retail Search Hole
Cloudnomics
Cloudnomics
Cloudnomics
Follow
Jun 9 '22
Mercado Libre Goes Big(Query), Moneyball Goes Cloud, Plus Plugging a $300B Retail Search Hole
#
googlecloud
#
bigquery
#
cloud
#
bigdata
5
reactions
Comments
Add Comment
6 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
5
reactions
Comments
Add Comment
2 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
Running Transformations on BigQuery using dbt Cloud: step by step
James Wachuka
James Wachuka
James Wachuka
Follow
Aug 10 '23
Running Transformations on BigQuery using dbt Cloud: step by step
#
bigquery
#
dbt
#
codenewbie
5
reactions
Comments
Add Comment
6 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
5
reactions
Comments
Add Comment
7 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
5
reactions
Comments
1
comment
7 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
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
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
3
reactions
Comments
Add Comment
3 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
☁️ Using BigQuery Billing Export to Manage your Invoice ☁️
jsrios
jsrios
jsrios
Follow
Jul 15 '20
☁️ Using BigQuery Billing Export to Manage your Invoice ☁️
#
googlecloud
#
gcp
#
bigquery
#
100daysofcloud
3
reactions
Comments
Add Comment
2 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
More Data, More Problems: How BuzzFeed Scaled its Data Operation
Matt Semanyshyn
Matt Semanyshyn
Matt Semanyshyn
Follow
for
BuzzFeed Tech
Dec 23 '20
More Data, More Problems: How BuzzFeed Scaled its Data Operation
#
bigquery
#
database
#
datamodel
#
data
3
reactions
Comments
Add Comment
5 min read
Google BigQuery Tutorial | Analyze Data in BigQuery | Google Cloud Platform Training
Damon Lamare
Damon Lamare
Damon Lamare
Follow
Dec 16 '22
Google BigQuery Tutorial | Analyze Data in BigQuery | Google Cloud Platform Training
#
bigquery
#
tutorial
#
beginners
2
reactions
Comments
Add Comment
1 min read
ODBC Driver for Google BigQuery – A New Connectivity Solution from Devart
Devart Software
Devart Software
Devart Software
Follow
May 19 '20
ODBC Driver for Google BigQuery – A New Connectivity Solution from Devart
#
odbc
#
connectivity
#
database
#
bigquery
2
reactions
Comments
Add Comment
2 min read
BigQuery: Creating a pipeline between MySql and BigQuery using airflow
James Wachuka
James Wachuka
James Wachuka
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
#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
2
reactions
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
[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
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
Regex Operations in BigQuery
Smit Thakkar
Smit Thakkar
Smit Thakkar
Follow
Aug 12 '21
Regex Operations in BigQuery
#
regex
#
bigquery
2
reactions
Comments
Add Comment
3 min read
How a simple left join can be your biggest nightmare.
Alok Chaudhary
Alok Chaudhary
Alok Chaudhary
Follow
Dec 20 '22
How a simple left join can be your biggest nightmare.
#
spark
#
bigquery
#
python
1
reaction
Comments
Add Comment
1 min read
Exporting Google Cloud Storage File List to BigQuery (CSV)
Uri Shaked
Uri Shaked
Uri Shaked
Follow
Jul 30 '20
Exporting Google Cloud Storage File List to BigQuery (CSV)
#
googlecloud
#
bigquery
#
gsutil
1
reaction
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
1
reaction
Comments
Add Comment
2 min read
BigQuery deduplication strategies
Sagnik Bandyopadhyay
Sagnik Bandyopadhyay
Sagnik Bandyopadhyay
Follow
Apr 30 '23
BigQuery deduplication strategies
#
bigquery
#
sql
#
googlecloud
#
data
1
reaction
Comments
Add Comment
5 min read
Tricky Dataflow ep.1 : Auto create BigQuery tables in pipelines
matthieucham
matthieucham
matthieucham
Follow
for
Stack Labs
Feb 3 '21
Tricky Dataflow ep.1 : Auto create BigQuery tables in pipelines
#
googlecloud
#
dataflow
#
bigquery
#
bigdata
1
reaction
Comments
Add Comment
3 min read
BigQueryベストプラクティス (パフォーマンス:2)
Atsumi
Atsumi
Atsumi
Follow
May 21 '20
BigQueryベストプラクティス (パフォーマンス:2)
#
bigquery
1
reaction
Comments
Add Comment
2 min read
Query large amounts of data from BigQuery faster with Golang
Ronny Medina
Ronny Medina
Ronny Medina
Follow
Oct 29 '23
Query large amounts of data from BigQuery faster with Golang
#
go
#
bigquery
1
reaction
Comments
2
comments
2 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
1
reaction
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
1
reaction
Comments
Add Comment
2 min read
BigQueryベストプラクティス (パフォーマンス:3)
Atsumi
Atsumi
Atsumi
Follow
Jun 1 '20
BigQueryベストプラクティス (パフォーマンス:3)
#
bigquery
1
reaction
Comments
Add Comment
1 min read
How To Access And Query Your Google BigQuery Data Using Python And R
Team RudderStack
Team RudderStack
Team RudderStack
Follow
for
RudderStack
Sep 17 '21
How To Access And Query Your Google BigQuery Data Using Python And R
#
python
#
r
#
bigquery
#
rudderstack
1
reaction
Comments
Add Comment
5 min read
[Feedback] GCP : Cross region Data transfer with BigQuery. Part 1 - Workflows and DTS at the rescue
Λ\: Clément Bosc
Λ\: Clément Bosc
Λ\: Clément Bosc
Follow
for
Stack Labs
Jan 24 '22
[Feedback] GCP : Cross region Data transfer with BigQuery. Part 1 - Workflows and DTS at the rescue
#
bigquery
#
data
#
googlecloud
#
analytics
1
reaction
Comments
Add Comment
5 min read
Export Firebase Firestore data to BigQuery
yosan
yosan
yosan
Follow
Jul 21 '20
Export Firebase Firestore data to BigQuery
#
firebase
#
gcp
#
bigquery
#
firestore
1
reaction
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
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
BigQueryベストプラクティス (コスト管理)
Atsumi
Atsumi
Atsumi
Follow
Apr 23 '20
BigQueryベストプラクティス (コスト管理)
#
bigquery
Comments
Add Comment
1 min read
BigQueryベストプラクティス (パフォーマンス:1)
Atsumi
Atsumi
Atsumi
Follow
Apr 30 '20
BigQueryベストプラクティス (パフォーマンス:1)
#
bigquery
Comments
Add Comment
1 min read
BigQuery: date sharded tables vs. native table partitions
Mark McCracken
Mark McCracken
Mark McCracken
Follow
Jan 25 '21
BigQuery: date sharded tables vs. native table partitions
#
bigquery
#
gcp
#
datawarehousing
#
partitioning
Comments
Add Comment
1 min read
Classificação e controle de acesso a dados sensíveis em Data Lake no GCP
Ronan
Ronan
Ronan
Follow
Jan 29 '21
Classificação e controle de acesso a dados sensíveis em Data Lake no GCP
#
bigquery
#
dataflow
#
lgpd
#
ptbr
Comments
Add Comment
7 min read
Announcing Hasura 2.0.0-alpha.10
Hasura
Hasura
Hasura
Follow
for
Hasura
Apr 30 '21
Announcing Hasura 2.0.0-alpha.10
#
releases
#
graphqlengine
#
bigquery
Comments
Add Comment
3 min read
How To Capture More than Group When Using BigQuery Regex
Oluwabukunmi Ige
Oluwabukunmi Ige
Oluwabukunmi Ige
Follow
May 15 '21
How To Capture More than Group When Using BigQuery Regex
#
sql
#
bigquery
Comments
Add Comment
2 min read
The Hasura Community Call Roundup - May 2021
Hasura
Hasura
Hasura
Follow
for
Hasura
Jun 4 '21
The Hasura Community Call Roundup - May 2021
#
community
#
inheritedroles
#
bigquery
#
citus
Comments
Add Comment
6 min read
Announcing Hasura 2.0.0-beta.2
Hasura
Hasura
Hasura
Follow
for
Hasura
Jun 17 '21
Announcing Hasura 2.0.0-beta.2
#
releases
#
graphqlengine
#
bigquery
#
console
Comments
Add Comment
3 min read
How our marketing ops team built a realtime lead-to-account matching solution with Hasura, BigQuery, Zapier and Salesforce.
Hasura
Hasura
Hasura
Follow
for
Hasura
Sep 13 '21
How our marketing ops team built a realtime lead-to-account matching solution with Hasura, BigQuery, Zapier and Salesforce.
#
bigquery
Comments
Add Comment
5 min read
Tutorial: Get instant GraphQL APIs on BigQuery with Hasura
Hasura
Hasura
Hasura
Follow
for
Hasura
Sep 24 '21
Tutorial: Get instant GraphQL APIs on BigQuery with Hasura
#
graphql
#
bigquery
#
api
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