Skip to content

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

conn_id

Airflow connection ID to use for operations.

required

table_name

Fully qualified table name (schema.table for Postgres, dataset.table for BigQuery).

required

project

Optional BigQuery project override.

required

schema_fields

Optional explicit schema description for BigQuery writes.

required

partition_by

BigQuery partition column name.

required

cluster_by

BigQuery clustering columns.

required

location

BigQuery dataset location/region.

required

temporary

If True, operators will attempt to drop this table after use.

required

temp_schema

Optional schema for Postgres temporary tables.

required

date_range

Optional tuple for sharded table ranges.

required

table_type

BigQuery table type (e.g., EXTERNAL).

required

dataset

Optional dataset/schema override for certain databases.

required

extra_config

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

file_path

str

Path to the SQL file (relative or absolute).

required

variables

Optional[Dict[str, Any]]

Variables for Jinja templating. Optional.

None

base_path

Optional[str]

Base directory for relative paths. Optional.

None