
- BigQuery - Home
- BigQuery - Overview
- BigQuery - Initial Setup
- BigQuery vs Local SQL Engines
- BigQuery - Google Cloud Console
- BigQuery - Google Cloud Hierarchy
- What is Dremel?
- What is BigQuery Studio?
- BigQuery - Datasets
- BigQuery - Tables
- BigQuery - Views
- BigQuery - Create Table
- BigQuery - Basic Schema Design
- BigQuery - Alter Table
- BigQuery - Copy Table
- Delete and Recover Table
- BigQuery - Populate Table
- Standard SQL vs Legacy SQL
- BigQuery - Write First Query
- BigQuery - CRUD Operations
- Partitioning & Clustering
- BigQuery - Data Types
- BigQuery - Complex Data Types
- BigQuery - STRUCT Data Type
- BigQuery - ARRAY Data Type
- BigQuery - JSON Data Type
- BigQuery - Table Metadata
- BigQuery - User-defined Functions
- Connecting to External Sources
- Integrate Scheduled Queries
- Integrate BigQuery API
- BigQuery - Integrate Airflow
- Integrate Connected Sheets
- Integrate Data Transfers
- BigQuery - Materialized View
- BigQuery - Roles & Permissions
- BigQuery - Query Optimization
- BigQuery - BI Engine
- Monitoring Usage & Performance
- BigQuery - Data Warehouse
- Challenges & Best Practices
BigQuery - Connecting to External Sources
While the majority of the tutorial, up to this point, has concerned the UI and the cloud terminal, it's time to explore connecting to BigQuery through external sources.
Limitations of Writing Queries in the UI
Even though it may be convenient to write queries in BigQuery Studio, the truth is, this only fulfills a limited range of purposes −
- Initially developing a SQL query or script
- Debugging a query
- Conducting spot checks or quality assurance
Simply writing and running queries in the UI doesn't help deliver automated data solutions. This means that in the BigQuery SQL environment, you can't −
- Access the BigQuery API
- Integrate with Airflow
- Create ETL pipelines
External BigQuery Integrations
In the following chapters, we'll explore how to integrate BigQuery with −
- BigQuery Scheduled Queries
- BigQuery API (Python)
- Cloud Composer / Airflow
- Google Sheets
- BigQuery Data Transfers
External BigQuery integrations empower developers to leverage the power of SQL to perform the following tasks −
- Create automated extract load (EL)
- Extract transform load (ETL)
- Extract load transform (ELT) jobs
Advertisements