matthieucham articles - 11 total
How to pass an Array of Structs in Bigquery's parameterized queries
In Google's Bigquery, SQL queries can be parameterized. If you're not familiar with this concept, it...
Automatically Update BigQuery View Schema Changes
SQL views are virtual tables simplifying data access and security. They offer tailored data...
What exactly is exactly-once delivery ?
GoogleCloud PubSub is the serverless implementation of a Publisher - Subscriber management service....
How to mock a decorator in Python
Programming is the art of adding bugs to an empty text file. Mastering unittest.mock capabilities of...
13 tricks for the new Bigquery Storage Write API in Python
In order to stream data into a BigQuery table programmatically, Google is promoting a new API: The...
BigQuery transactions over multiple queries, with sessions
BigQuery supports transactions since last year (Presented at Google Cloud Next'21) : it is now...
How to overcome Cloud Run's 32MB request limit
Cloud Run is an awesome serverless product provided by Google Cloud which is often a perfect fit to...
Brace yourself: Using BigQuery as an operational backend
BigQuery as backend ? WTF ? BigQuery has become a major player in the field of Data...
Orchestrate Dataflow pipelines easily with GCP Workflows
Dataflow pipelines rarely are on their own. Most of the time, they are part of a more global process....
Tricky Dataflow ep.2 : Import documents from MongoDB views
This is the second episode of my Tricky Dataflow series, in which I present some of the trickiest iss...
Tricky Dataflow ep.1 : Auto create BigQuery tables in pipelines
GCP's Dataflow is a really powerful weapon when you need to manipulate massive amounts of data in a h...