Export data from Cloud SQL to GCS using BigQuery Federated Query and Scheduled Query
Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
More from this blog
Integrates DuckDB with Google BigQuery
Background In today's data-driven world, the ability to efficiently query and manage large datasets is crucial for businesses. DuckDB, an in-process SQL OLAP database management system, offers a powerful solution for handling complex analytical queri...
Sep 24, 20255 min read
Missing DAGs in Airflow UI: A Cloud Composer Filter Bug
I recently assisted a customer in troubleshooting an issue with their Google Cloud Composer environment and found myself delving deep to uncover the problem. They had 22 DAGs, but only 11 were visible in the UI. It turns out this is a known bug that ...
Aug 29, 20253 min read
Effective Use of Google Cloud IAM Deny Policies for BigQuery Data Security
Background Recently, I assisted a customer who required protection for sensitive data in BigQuery, ensuring access was restricted to a small group of individuals. They wanted to prevent any accidental access by employees. To address this, I recommend...
Mar 28, 20252 min read
How to Implement IAM Authentication in Cloud SQL PostgreSQL: A Step-by-Step Tutorial
Background IAM Authentication in Cloud SQL for PostgreSQL lets you manage database user access using Google Cloud Identity and Access Management (IAM) identities instead of traditional PostgreSQL usernames and passwords. This integrates database acce...
Feb 1, 20252 min read
How to trigger the DAG in Amazon Managed Workflows for Apache Airflow (MWAA)
Background Directed Acyclic Graphs (DAGs) in Amazon Managed Workflows for Apache Airflow (MWAA) can be triggered in several ways, depending on how much automation and integration you need. While you can manually trigger DAGs using the Airflow UI, we ...
Jan 1, 20253 min read
