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 |
|---|---|---|---|
|
The PostgreSQL connection ID to use. Defaults to 'postgres_default'. |
'postgres_default'
|
|
|
Number of retries before skipping the task. Defaults to 1. |
1
|
|
|
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 |
|---|---|---|---|
|
The BigQuery connection ID to use. |
required | |
|
str
|
BigQuery location. Defaults to 'us-central1'. |
'us-central1'
|
|
Number of retries before skipping the task. Defaults to 1. |
1
|
|
|
Additional arguments passed to SqlSensor. |
{}
|