Core Classes API Reference¶
Table¶
Bases: BaseModel
Represents a database table reference with connection and configuration.
This class is JSON serializable for use with Airflow XCom and TaskFlow API.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
|
Airflow connection ID to use for operations. |
required | |
|
Fully qualified table name (schema.table for Postgres, dataset.table for BigQuery). |
required | |
|
Optional BigQuery project override. |
required | |
|
Optional explicit schema description for BigQuery writes. |
required | |
|
BigQuery partition column name. |
required | |
|
BigQuery clustering columns. |
required | |
|
BigQuery dataset location/region. |
required | |
|
If True, operators will attempt to drop this table after use. |
required | |
|
Optional schema for Postgres temporary tables. |
required | |
|
Optional tuple for sharded table ranges. |
required | |
|
BigQuery table type (e.g., EXTERNAL). |
required | |
|
Optional dataset/schema override for certain databases. |
required | |
|
Any additional provider-specific configuration. |
required |
File¶
Represents a SQL file with optional Jinja templating.
The File object helps locate and render SQL files. It searches for files in a few places (absolute path, caller-relative, and configured search paths) and supports rendering with Jinja variables.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
|
str
|
Path to the SQL file (relative or absolute). |
required |
|
Optional[Dict[str, Any]]
|
Variables for Jinja templating. Optional. |
None
|
|
Optional[str]
|
Base directory for relative paths. Optional. |
None
|