Usage¶
Detailed guides for using AirSQL operators, sensors, and transfer operators.
Query Operations¶
Execute SQL queries with various output strategies.
- Query Overview - Introduction to query operations
- Return DataFrame - Execute SQL and return pandas DataFrame
- Query to Table - Execute SQL and write to table
- Append to Table - Execute SQL and append to existing table
- Replace Table - Execute SQL and replace table content
- Truncate and Reload - Truncate table and insert new data
- Merge/Upsert - Execute SQL and merge with conflict resolution
- Load DataFrame - Load pandas DataFrame directly
- Merge DataFrame - Merge DataFrame with upsert logic
- Extract and Load - Extract via SQL and load in one task
- Extract and Merge - Extract via SQL and merge in one task
- Data Quality Checks - Execute data quality validation
- DDL Operations - Execute DDL statements
Sensors¶
Monitor database conditions with SQL-based sensors.
- Sensors Guide - SQL sensors with retry logic
Transfers¶
Move data between different systems.
- Transfers Guide - Transfer operators for BigQuery, Postgres, GCS