blob: e1d053db12b9938fd0d8818d5a4a6d30b31f9529 [file] [log] [blame]
Search.setIndex({"docnames": ["_api/airflow/providers/common/sql/hooks/index", "_api/airflow/providers/common/sql/hooks/sql/index", "_api/airflow/providers/common/sql/index", "_api/airflow/providers/common/sql/operators/index", "_api/airflow/providers/common/sql/operators/sql/index", "_api/airflow/providers/common/sql/sensors/index", "_api/airflow/providers/common/sql/sensors/sql/index", "_api/tests/system/providers/common/sql/example_sql_column_table_check/index", "_api/tests/system/providers/common/sql/index", "commits", "connections", "index", "installing-providers-from-sources", "operators"], "filenames": ["_api/airflow/providers/common/sql/hooks/index.rst", "_api/airflow/providers/common/sql/hooks/sql/index.rst", "_api/airflow/providers/common/sql/index.rst", "_api/airflow/providers/common/sql/operators/index.rst", "_api/airflow/providers/common/sql/operators/sql/index.rst", "_api/airflow/providers/common/sql/sensors/index.rst", "_api/airflow/providers/common/sql/sensors/sql/index.rst", "_api/tests/system/providers/common/sql/example_sql_column_table_check/index.rst", "_api/tests/system/providers/common/sql/index.rst", "commits.rst", "connections.rst", "index.rst", "installing-providers-from-sources.rst", "operators.rst"], "titles": ["<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.common.sql.hooks</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.common.sql.hooks.sql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.common.sql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.common.sql.operators</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.common.sql.operators.sql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.common.sql.sensors</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.common.sql.sensors.sql</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.common.sql.example_sql_column_table_check</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.common.sql</span></code>", "Package apache-airflow-providers-common-sql", "Connecting to a SQL DB", "<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-common-sql</span></code>", "Installing from sources", "SQL Operators"], "terms": {"1": [0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 12, 13], "0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 12, 13], "2": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], "4": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], "dev0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], "thi": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], "i": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], "an": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], "experiment": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], "featur": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13], "fetch_all_handl": [1, 9, 11], "cursor": 1, "sourc": [1, 4, 6, 7, 11, 13], "handler": 1, "dbapihook": [1, 4, 9, 11], "run": [1, 4, 6, 9, 11, 12, 13], "return": [1, 4, 6], "result": [1, 4, 13], "connectorprotocol": [1, 11], "base": [1, 4, 6], "typing_extens": 1, "protocol": 1, "A": [1, 6], "where": [1, 4, 13], "you": [1, 4, 11, 12], "can": [1, 4, 6, 10, 11, 12, 13], "connect": [1, 4, 6, 11, 13], "databas": [1, 4, 10, 11, 13], "host": 1, "port": 1, "usernam": 1, "schema": 1, "paramet": [1, 4, 6, 9, 10, 11], "str": [1, 4, 6], "The": [1, 4, 6, 10, 12, 13], "int": [1, 4, 13], "us": [1, 4, 9, 11, 12, 13], "authent": 1, "author": 1, "object": [1, 4], "type": [1, 4, 11], "ani": [1, 4, 10, 12, 13], "basefordbapihook": 1, "basehook": 1, "arg": [1, 10], "none": [1, 4, 6, 12], "log_sql": 1, "true": [1, 4], "kwarg": [1, 4, 6], "dbapi": [1, 10], "abstract": 1, "option": [1, 4, 6], "db": [1, 4, 9, 11], "overrid": [1, 4, 6, 9, 11], "specifi": [1, 4, 13], "make": 1, "sure": 1, "chang": [1, 9], "valu": [1, 4, 6], "constructor": [1, 6], "deriv": [1, 4, 6], "should": [1, 4, 6, 12], "done": 1, "befor": [1, 4, 6], "call": [1, 6], "__init__": 1, "bool": [1, 4], "whether": [1, 4], "log": [1, 4], "queri": [1, 4, 6, 13], "when": [1, 4, 13], "": [1, 4, 12, 13], "execut": [1, 4], "default": [1, 4], "conn_name_attr": 1, "default_conn_nam": 1, "default_conn_id": [1, 4], "supports_autocommit": 1, "fals": [1, 4, 6], "connector": 1, "get_conn": 1, "get_uri": 1, "extract": 1, "uri": 1, "from": [1, 4, 11], "get_sqlalchemy_engin": 1, "engine_kwarg": 1, "get": [1, 4, 12], "sqlalchemy_engin": 1, "create_engin": 1, "creat": [1, 4, 12], "engin": 1, "get_pandas_df": 1, "panda": 1, "datafram": 1, "statement": [1, 4, 6, 9, 11, 13], "list": [1, 4, 9, 11], "render": [1, 4, 6], "pass": [1, 6, 10], "io": 1, "read_sql": 1, "method": [1, 4, 9, 11], "get_pandas_df_by_chunk": 1, "chunksiz": 1, "gener": [1, 4], "number": [1, 4, 13], "row": [1, 4, 6, 13], "includ": [1, 9, 11, 13], "each": [1, 4, 13], "chunk": 1, "get_record": 1, "set": [1, 4, 13], "record": 1, "union": [1, 4], "iter": [1, 4], "map": [1, 4, 13], "get_first": 1, "first": [1, 4, 6, 13], "static": 1, "strip_sql_str": 1, "split_sql_str": 1, "split": [1, 9, 11], "string": [1, 4, 6, 9, 11, 13], "multipl": 1, "express": [1, 4], "potenti": 1, "consist": 1, "individu": 1, "autocommit": 1, "split_stat": 1, "return_last": 1, "command": 1, "them": 1, "sequenti": 1, "what": 1, "callabl": [1, 6], "which": [1, 4, 6, 9, 11, 13], "singl": [1, 4], "separ": 1, "onli": [1, 4, 6], "last": 1, "all": [1, 9, 11], "after": 1, "wa": 1, "set_autocommit": 1, "conn": 1, "flag": 1, "get_autocommit": 1, "doe": 1, "support": [1, 11], "get_cursor": 1, "insert_row": 1, "tabl": [1, 4], "target_field": 1, "commit_everi": 1, "1000": [1, 4, 13], "replac": 1, "wai": 1, "insert": 1, "tupl": 1, "new": 1, "transact": 1, "everi": 1, "name": [1, 4, 13], "target": 1, "column": [1, 4], "fill": 1, "maximum": [1, 4, 13], "one": [1, 4, 6, 12], "instead": 1, "bulk_dump": 1, "tmp_file": 1, "dump": 1, "tab": 1, "delimit": 1, "file": [1, 12], "path": [1, 4], "bulk_load": 1, "load": 1, "test_connect": 1, "test": [1, 9, 11, 13], "specif": 1, "hook": [2, 4, 6, 10], "oper": [2, 9, 10, 11], "sensor": 2, "parse_boolean": [4, 13], "val": 4, "try": [4, 6], "pars": 4, "boolean": [4, 6, 13], "rais": [4, 6], "valueerror": 4, "input": 4, "valid": [4, 12, 13], "like": [4, 10, 13], "basesqloper": 4, "conn_id": [4, 6], "hook_param": [4, 6], "model": 4, "baseoper": 4, "get_db_hook": 4, "behavior": 4, "retriev": 4, "custom": 4, "sqlcolumncheckoper": [4, 11, 13], "column_map": [4, 13], "partition_claus": 4, "perform": [4, 13], "more": [4, 10], "templat": [4, 13], "check": [4, 12], "column_check": [4, 7, 13], "dictionari": [4, 13], "ar": [4, 6, 11, 12, 13], "per": 4, "basi": 4, "take": [4, 6], "follow": [4, 12], "equal_to": [4, 13], "exact": 4, "equal": 4, "cannot": 4, "other": [4, 10, 13], "comparison": 4, "greater_than": [4, 13], "strictli": 4, "greater": 4, "than": 4, "less_than": [4, 13], "less": [4, 9, 11], "geq_to": [4, 13], "leq_to": [4, 13], "toler": [4, 13], "percentag": [4, 13], "mai": [4, 13], "off": 4, "expect": 4, "dict": 4, "associ": 4, "e": 4, "g": 4, "col_nam": [4, 13], "null_check": [4, 13], "min": [4, 13], "5": [4, 13], "10": [4, 9, 13], "max": [4, 13], "01": [4, 13], "partial": 4, "ad": 4, "claus": 4, "built": 4, "date": 4, "1970": 4, "id": [4, 12, 13], "overwrit": 4, "defin": [4, 6], "For": [4, 9, 10, 12], "inform": [4, 9], "how": [4, 12, 13], "look": [4, 13], "guid": [4, 12], "template_field": [4, 6], "context": [4, 6], "main": [4, 12], "same": [4, 13], "jinja": 4, "refer": 4, "get_template_context": 4, "sqltablecheckoper": [4, 11, 13], "written": 4, "row_count_check": [4, 13], "check_stat": [4, 13], "count": [4, 13], "column_sum_check": [4, 13], "col_a": [4, 13], "col_b": [4, 13], "col_c": [4, 13], "sql_check_templ": 4, "multilin": 4, "show": 4, "select": [4, 12], "_check_nam": 4, "AS": 4, "check_nam": 4, "check_result": 4, "case": [4, 6], "THEN": 4, "els": 4, "end": 4, "sqlcheckoper": [4, 9, 11], "against": [4, 6, 13], "evalu": [4, 6], "python": [4, 11, 12], "cast": 4, "If": [4, 6, 12], "fail": [4, 6], "error": 4, "out": [4, 13], "note": 4, "eval": 4, "empti": [4, 6], "given": [4, 13], "foo": 4, "craft": 4, "much": 4, "complex": 4, "could": 4, "instanc": 4, "ha": 4, "upstream": 4, "todai": 4, "partit": 4, "yesterdai": 4, "metric": 4, "3": 4, "standard": 4, "deviat": 4, "7": 4, "dai": 4, "averag": 4, "data": [4, 13], "qualiti": [4, 13], "your": 4, "pipelin": 4, "depend": 4, "put": 4, "dag": [4, 11], "have": [4, 6], "choic": 4, "stop": 4, "critic": 4, "prevent": 4, "publish": 4, "dubiou": 4, "side": 4, "receiv": 4, "email": 4, "alert": 4, "without": 4, "progress": 4, "sequenc": [4, 6], "template_ext": [4, 6], "hql": [4, 6, 9, 11], "template_fields_render": 4, "ui_color": [4, 6], "fff7e6": 4, "sqlvaluecheckoper": 4, "pass_valu": 4, "simpl": 4, "code": [4, 12], "__mapper_args__": 4, "sqlintervalcheckoper": 4, "metrics_threshold": 4, "date_filter_column": 4, "d": [4, 12], "days_back": 4, "ratio_formula": 4, "max_over_min": 4, "ignore_zero": 4, "within": 4, "certain": 4, "ones": 4, "supportsab": 4, "between": [4, 13], "we": 4, "want": [4, 12], "filter": 4, "formula": 4, "comput": 4, "ratio": 4, "two": [4, 13], "assum": 4, "cur": 4, "ref": 4, "relative_diff": 4, "ab": 4, "ignor": 4, "zero": [4, 6], "index": 4, "sql1": 4, "sql2": 4, "sqlthresholdcheckoper": 4, "min_threshold": 4, "max_threshold": 4, "minimum": [4, 11, 13], "threshold": 4, "form": 4, "numer": 4, "OR": 4, "push": 4, "meta_data": 4, "send": 4, "info": 4, "metadata": 4, "extern": 4, "branchsqloper": 4, "follow_task_ids_if_tru": 4, "follow_task_ids_if_fals": 4, "skipmixin": 4, "allow": [4, 9, 10, 11], "branch": 4, "recogn": 4, "integ": 4, "otherwis": 4, "y": 4, "ye": 4, "n": 4, "task": [4, 13], "a22034": 4, "ui_fgcolor": 4, "f7f7f7": 4, "sqlsensor": [6, 9, 11], "success": [6, 13], "failur": 6, "fail_on_empti": 6, "basesensoroper": 6, "repeatedli": 6, "until": 6, "criteria": 6, "met": 6, "It": [6, 12], "keep": 6, "cell": 6, "argument": [6, 13], "retri": 6, "airflowexcept": 6, "also": [6, 12], "been": 6, "To": [6, 12], "need": 6, "least": 6, "contain": [6, 12], "non": 6, "first_cel": 6, "explicitli": 6, "extra": 6, "config": 6, "param": 6, "underli": 6, "match": [6, 12], "desir": 6, "7c7287": 6, "poke": 6, "function": [6, 9, 11], "while": 6, "airflow_db_metadata_t": [7, 13], "ab_rol": 7, "connection_arg": 7, "test_run": 7, "example_sql_column_table_check": [8, 13], "detail": [9, 11, 12], "commit": 9, "version": [9, 11, 12], "high": 9, "level": [9, 13], "changelog": 9, "see": [9, 11], "latest": 9, "2022": 9, "08": 9, "15": 9, "subject": 9, "7a19651369": 9, "fix": 9, "25713": [9, 11], "5923788143": 9, "add": [9, 11], "amazon": 9, "25636": 9, "d82436b382": 9, "05": 9, "api": [9, 11], "25430": [9, 11], "348a28957a": 9, "04": 9, "align": [9, 11], "logo": [9, 11], "locat": [9, 11], "25538": [9, 11], "acab8f52dd": 9, "07": 9, "29": 9, "move": [9, 11], "old": [9, 11], "25350": [9, 11], "b0fd105f4a": 9, "28": 9, "legaci": [9, 11], "25293": [9, 11], "5d4abbd58c": 9, "27": 9, "deprec": [9, 11], "synchron": [9, 11], "25299": [9, 11], "df00436569": 9, "22": 9, "unifi": [9, 11], "23971": [9, 11], "be7cb1e837": 9, "variou": [9, 10, 11, 13], "updat": [9, 11], "25164": [9, 11], "46bbfdade0": 9, "class": [9, 11], "24836": 9, "provid": [10, 12, 13], "packag": 10, "access": 10, "directli": 10, "simpli": 10, "suffici": 10, "complic": 10, "addit": 10, "kei": [10, 12, 13], "word": 10, "under": [10, 13], "do": [10, 12], "exampl": [11, 12, 13], "pypi": 11, "repositori": 11, "releas": 11, "top": [11, 12], "exist": 11, "below": [11, 12, 13], "via": [11, 12], "pip": [11, 12], "sqlpars": 11, "improv": 11, "taskflow": 11, "hint": 11, "paramspec": 11, "25173": 11, "initi": 11, "page": 12, "describ": [12, 13], "download": 12, "apach": 12, "airflow": [12, 13], "common": [12, 13], "sql": 12, "offici": 12, "most": 12, "choos": 12, "differ": 12, "drop": 12, "down": 12, "left": 12, "sdist": 12, "whl": 12, "origin": 12, "checksum": 12, "signatur": 12, "avail": 12, "softwar": 12, "foundat": 12, "asc": 12, "sha512": 12, "those": 12, "link": 12, "abov": 12, "build": [12, 13], "pgp": 12, "essenti": 12, "sha": 12, "gpg": 12, "pleas": 12, "well": [12, 13], "relev": 12, "distribut": 12, "recommend": 12, "directori": 12, "mirror": 12, "pgpk": 12, "ka": 12, "binari": 12, "pgpv": 12, "tar": 12, "gz": 12, "made": 12, "sat": 12, "11": 12, "sep": 12, "12": 12, "49": 12, "54": 12, "2021": 12, "bst": 12, "rsa": 12, "cde15c6e4d3a8ec4ecf4ba4b6674e08ad7de406f": 12, "issuer": 12, "kaxilnaik": 12, "org": 12, "good": 12, "kaxil": 12, "naik": 12, "unknown": 12, "aka": 12, "gmail": 12, "com": 12, "warn": 12, "user": 12, "certifi": 12, "trust": 12, "There": 12, "indic": 12, "belong": 12, "owner": 12, "primari": 12, "fingerprint": 12, "cde1": 12, "5c6e": 12, "4d3a": 12, "8ec4": 12, "ecf4": 12, "ba4b": 12, "6674": 12, "e08a": 12, "d7de": 12, "406f": 12, "correct": 12, "worri": 12, "about": 12, "certif": 12, "manag": 12, "self": 12, "sign": 12, "why": 12, "By": 12, "import": 12, "server": 12, "previou": 12, "step": 12, "know": 12, "alreadi": 12, "sum": 12, "shasum": 12, "512": 12, "diff": 12, "local": 12, "script": 12, "bin": 12, "bash": 12, "package_vers": 12, "package_nam": 12, "provider_download_dir": 12, "mktemp": 12, "dep": 12, "dest": 12, "curl": 12, "http": 12, "apache_airflow_providers_common_sql": 12, "py3": 12, "l": 12, "o": 12, "echo": 12, "la": 12, "onc": 12, "instruct": 12, "chapter": 12, "remov": 12, "temporari": 12, "folder": 12, "These": 13, "As": 13, "relationship": 13, "must": 13, "suppli": 13, "three": 13, "nest": 13, "entri": 13, "its": 13, "null": 13, "distinct_check": 13, "distinct": 13, "unique_check": 13, "either": 13, "condit": 13, "compat": 13, "both": 13, "lower": 13, "upper": 13, "bound": 13, "still": 13, "consid": 13, "demonstr": 13, "instanti": 13, "system": 13, "py": 13, "task_id": 13, "referenc": 13, "resolv": 13}, "objects": {"airflow.providers.common": [[2, 0, 0, "-", "sql"]], "airflow.providers.common.sql": [[0, 0, 0, "-", "hooks"], [3, 0, 0, "-", "operators"], [5, 0, 0, "-", "sensors"]], "airflow.providers.common.sql.hooks": [[1, 0, 0, "-", "sql"]], "airflow.providers.common.sql.hooks.sql": [[1, 1, 1, "", "BaseForDbApiHook"], [1, 2, 1, "", "ConnectorProtocol"], [1, 2, 1, "", "DbApiHook"], [1, 5, 1, "", "fetch_all_handler"]], "airflow.providers.common.sql.hooks.sql.ConnectorProtocol": [[1, 3, 1, "", "connect"]], "airflow.providers.common.sql.hooks.sql.DbApiHook": [[1, 3, 1, "", "bulk_dump"], [1, 3, 1, "", "bulk_load"], [1, 4, 1, "", "conn_name_attr"], [1, 4, 1, "", "connector"], [1, 4, 1, "", "default_conn_name"], [1, 3, 1, "", "get_autocommit"], [1, 3, 1, "", "get_conn"], [1, 3, 1, "", "get_cursor"], [1, 3, 1, "", "get_first"], [1, 3, 1, "", "get_pandas_df"], [1, 3, 1, "", "get_pandas_df_by_chunks"], [1, 3, 1, "", "get_records"], [1, 3, 1, "", "get_sqlalchemy_engine"], [1, 3, 1, "", "get_uri"], [1, 3, 1, "", "insert_rows"], [1, 3, 1, "", "run"], [1, 3, 1, "", "set_autocommit"], [1, 3, 1, "", "split_sql_string"], [1, 3, 1, "", "strip_sql_string"], [1, 4, 1, "", "supports_autocommit"], [1, 3, 1, "", "test_connection"]], "airflow.providers.common.sql.operators": [[4, 0, 0, "-", "sql"]], "airflow.providers.common.sql.operators.sql": [[4, 2, 1, "", "BaseSQLOperator"], [4, 2, 1, "", "BranchSQLOperator"], [4, 2, 1, "", "SQLCheckOperator"], [4, 2, 1, "", "SQLColumnCheckOperator"], [4, 2, 1, "", "SQLIntervalCheckOperator"], [4, 2, 1, "", "SQLTableCheckOperator"], [4, 2, 1, "", "SQLThresholdCheckOperator"], [4, 2, 1, "", "SQLValueCheckOperator"], [4, 5, 1, "", "parse_boolean"]], "airflow.providers.common.sql.operators.sql.BaseSQLOperator": [[4, 3, 1, "", "get_db_hook"]], "airflow.providers.common.sql.operators.sql.BranchSQLOperator": [[4, 3, 1, "", "execute"], [4, 4, 1, "", "template_ext"], [4, 4, 1, "", "template_fields"], [4, 4, 1, "", "template_fields_renderers"], [4, 4, 1, "", "ui_color"], [4, 4, 1, "", "ui_fgcolor"]], "airflow.providers.common.sql.operators.sql.SQLCheckOperator": [[4, 3, 1, "", "execute"], [4, 4, 1, "", "template_ext"], [4, 4, 1, "", "template_fields"], [4, 4, 1, "", "template_fields_renderers"], [4, 4, 1, "", "ui_color"]], "airflow.providers.common.sql.operators.sql.SQLColumnCheckOperator": [[4, 4, 1, "", "column_checks"], [4, 3, 1, "", "execute"], [4, 4, 1, "", "template_fields"]], "airflow.providers.common.sql.operators.sql.SQLIntervalCheckOperator": [[4, 4, 1, "", "__mapper_args__"], [4, 3, 1, "", "execute"], [4, 4, 1, "", "ratio_formulas"], [4, 4, 1, "", "template_ext"], [4, 4, 1, "", "template_fields"], [4, 4, 1, "", "template_fields_renderers"], [4, 4, 1, "", "ui_color"]], "airflow.providers.common.sql.operators.sql.SQLTableCheckOperator": [[4, 3, 1, "", "execute"], [4, 4, 1, "", "sql_check_template"], [4, 4, 1, "", "template_fields"]], "airflow.providers.common.sql.operators.sql.SQLThresholdCheckOperator": [[4, 3, 1, "", "execute"], [4, 3, 1, "", "push"], [4, 4, 1, "", "template_ext"], [4, 4, 1, "", "template_fields"], [4, 4, 1, "", "template_fields_renderers"]], "airflow.providers.common.sql.operators.sql.SQLValueCheckOperator": [[4, 4, 1, "", "__mapper_args__"], [4, 3, 1, "", "execute"], [4, 4, 1, "", "template_ext"], [4, 4, 1, "", "template_fields"], [4, 4, 1, "", "template_fields_renderers"], [4, 4, 1, "", "ui_color"]], "airflow.providers.common.sql.sensors": [[6, 0, 0, "-", "sql"]], "airflow.providers.common.sql.sensors.sql": [[6, 2, 1, "", "SqlSensor"]], "airflow.providers.common.sql.sensors.sql.SqlSensor": [[6, 3, 1, "", "poke"], [6, 4, 1, "", "template_ext"], [6, 4, 1, "", "template_fields"], [6, 4, 1, "", "ui_color"]], "tests.system.providers.common": [[8, 0, 0, "-", "sql"]], "tests.system.providers.common.sql": [[7, 0, 0, "-", "example_sql_column_table_check"]], "tests.system.providers.common.sql.example_sql_column_table_check": [[7, 1, 1, "", "AIRFLOW_DB_METADATA_TABLE"], [7, 1, 1, "", "column_check"], [7, 1, 1, "", "connection_args"], [7, 1, 1, "", "test_run"]]}, "objtypes": {"0": "py:module", "1": "py:data", "2": "py:class", "3": "py:method", "4": "py:attribute", "5": "py:function"}, "objnames": {"0": ["py", "module", "Python module"], "1": ["py", "data", "Python data"], "2": ["py", "class", "Python class"], "3": ["py", "method", "Python method"], "4": ["py", "attribute", "Python attribute"], "5": ["py", "function", "Python function"]}, "titleterms": {"airflow": [0, 1, 2, 3, 4, 5, 6, 9, 11], "provid": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11], "common": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11], "sql": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13], "hook": [0, 1], "submodul": [0, 3, 5, 8], "modul": [1, 4, 6, 7], "content": [1, 4, 6, 7, 11], "class": [1, 4, 6], "function": [1, 4], "attribut": 1, "subpackag": 2, "oper": [3, 4, 13], "sensor": [5, 6], "test": [7, 8], "system": [7, 8], "example_sql_column_table_check": 7, "packag": [9, 11, 12], "apach": [9, 11], "1": [9, 11], "0": [9, 11], "connect": 10, "db": 10, "default": 10, "id": 10, "guid": 11, "refer": 11, "resourc": 11, "commit": 11, "instal": [11, 12], "requir": 11, "changelog": 11, "featur": 11, "bug": 11, "fix": 11, "from": 12, "sourc": 12, "releas": 12, "integr": 12, "verifi": 12, "pypi": 12, "check": 13, "tabl": 13, "column": 13, "valu": 13}, "envversion": {"sphinx.domains.c": 2, "sphinx.domains.changeset": 1, "sphinx.domains.citation": 1, "sphinx.domains.cpp": 6, "sphinx.domains.index": 1, "sphinx.domains.javascript": 2, "sphinx.domains.math": 2, "sphinx.domains.python": 3, "sphinx.domains.rst": 2, "sphinx.domains.std": 2, "sphinx.ext.viewcode": 1, "sphinx.ext.intersphinx": 1, "sphinx": 56}})