Apache Airflow Provider - Common SQL

Common SQL

CoreDatabases

An Apache Airflow provider to interact with SQL-like databases.

Version
1.4.0
Downloads
4,649,399/month
Last Published
Apr. 6, 2023
Quick Install

Available Modules

Modules are Python callables available from this provider package.

Types:

SensorsHooksOperators
SqlSensor
Common SQL

Runs a sql statement repeatedly until a criteria is met. It will keep trying until success or failure criteria are met, or if the first cell is not in…

SensorsUpdated a year ago
DbApiHook
Common SQL

Abstract base class for sql hooks.

HooksUpdated a year ago
SQLColumnCheckOperator
Common SQL

Performs one or more of the templated checks in the column_checks dictionary. Checks are performed on a per-column basis specified by the column_mappi…

OperatorsUpdated 10 months ago
SQLTableCheckOperator
Common SQL

Performs one or more of the checks provided in the checks dictionary. Checks should be written to return a boolean result.

OperatorsUpdated 10 months ago
SQLIntervalCheckOperator
Common SQL

Checks that the values of metrics given as SQL expressions are within a certain tolerance of the ones from days_back before.

OperatorsUpdated 10 months ago
BranchSQLOperator
Common SQL

Allows a DAG to “branch” or follow a specified path based on the results of a SQL query.

OperatorsUpdated 10 months ago
SQLThresholdCheckOperator
Common SQL

Performs a value check using sql code against a minimum threshold and a maximum threshold. Thresholds can be in the form of a numeric value OR a sql s…

OperatorsUpdated 10 months ago
SQLCheckOperator
Common SQL

Performs checks against a db. The SQLCheckOperator expects a sql query that will return a single row. Each value on that first row is evaluated using …

OperatorsUpdated 10 months ago
SQLValueCheckOperator
Common SQL

Performs a simple value check using sql code.

OperatorsUpdated 10 months ago
SQLExecuteQueryOperator
Common SQL

Executes SQL code in a specific database :param sql: the SQL code or string pointing to a template file to be executed (templated). File must have a ‘…

OperatorsUpdated 10 months ago
BaseSQLOperator
Common SQL

This is a base class for generic SQL Operator to get a DB Hook

OperatorsUpdated 10 months ago