Skip to content

Sensors API Reference

PostgresSqlSensor

Bases: SqlSensor

PostgreSQL SQL sensor with retry logic.

This sensor executes a SQL query and succeeds when the query returns any rows. It includes retry logic and will skip the task if the poke fails after the specified number of retries.

Parameters:

Name Type Description Default

conn_id

The PostgreSQL connection ID to use. Defaults to 'postgres_default'.

'postgres_default'

retries

Number of retries before skipping the task. Defaults to 1.

1

**kwargs

Additional arguments passed to SqlSensor.

{}

BigQuerySqlSensor

Bases: SqlSensor

BigQuery SQL sensor with retry logic.

This sensor executes a SQL query against BigQuery and succeeds when the query returns any rows. It includes retry logic and will skip the task if the poke fails after the specified number of retries.

Parameters:

Name Type Description Default

conn_id

The BigQuery connection ID to use.

required

location

str

BigQuery location. Defaults to 'us-central1'.

'us-central1'

retries

Number of retries before skipping the task. Defaults to 1.

1

**kwargs

Additional arguments passed to SqlSensor.

{}