docs-archive/apache-airflow-providers-snowflake/3.1.0/searchindex.js

Search.setIndex({"docnames": ["_api/airflow/providers/snowflake/hooks/index", "_api/airflow/providers/snowflake/hooks/snowflake/index", "_api/airflow/providers/snowflake/index", "_api/airflow/providers/snowflake/operators/index", "_api/airflow/providers/snowflake/operators/snowflake/index", "_api/airflow/providers/snowflake/transfers/index", "_api/airflow/providers/snowflake/transfers/s3_to_snowflake/index", "_api/airflow/providers/snowflake/transfers/snowflake_to_slack/index", "_api/airflow/providers/snowflake/utils/common/index", "_api/airflow/providers/snowflake/utils/index", "_api/tests/system/providers/snowflake/example_snowflake/index", "_api/tests/system/providers/snowflake/index", "commits", "connections/snowflake", "index", "installing-providers-from-sources", "operators/index", "operators/s3_to_snowflake", "operators/snowflake", "operators/snowflake_to_slack"], "filenames": ["_api/airflow/providers/snowflake/hooks/index.rst", "_api/airflow/providers/snowflake/hooks/snowflake/index.rst", "_api/airflow/providers/snowflake/index.rst", "_api/airflow/providers/snowflake/operators/index.rst", "_api/airflow/providers/snowflake/operators/snowflake/index.rst", "_api/airflow/providers/snowflake/transfers/index.rst", "_api/airflow/providers/snowflake/transfers/s3_to_snowflake/index.rst", "_api/airflow/providers/snowflake/transfers/snowflake_to_slack/index.rst", "_api/airflow/providers/snowflake/utils/common/index.rst", "_api/airflow/providers/snowflake/utils/index.rst", "_api/tests/system/providers/snowflake/example_snowflake/index.rst", "_api/tests/system/providers/snowflake/index.rst", "commits.rst", "connections/snowflake.rst", "index.rst", "installing-providers-from-sources.rst", "operators/index.rst", "operators/s3_to_snowflake.rst", "operators/snowflake.rst", "operators/snowflake_to_slack.rst"], "titles": ["<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.hooks</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.hooks.snowflake</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.operators</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.operators.snowflake</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.transfers</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.transfers.s3_to_snowflake</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.transfers.snowflake_to_slack</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.utils.common</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.utils</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.snowflake.example_snowflake</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.snowflake</span></code>", "Package apache-airflow-providers-snowflake", "Snowflake Connection", "<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-snowflake</span></code>", "Installing from sources", "Snowflake operators", "S3ToSnowflakeOperator", "SnowflakeOperator", "SnowflakeToSlackOperator"], "terms": {"3": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16, 17, 18, 19], "1": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16, 17, 18, 19], "0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16, 17, 18, 19], "2": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16, 17, 18, 19], "4": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15, 16, 17, 18, 19], "dev0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], "thi": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], "an": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], "experiment": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], "featur": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], "snowflakehook": [1, 4, 12, 14], "arg": [1, 12], "kwarg": [1, 4, 6, 7], "sourc": [1, 4, 6, 7, 8, 10, 14, 17, 18, 19], "base": [1, 4, 6, 7, 12, 14], "common": [1, 2, 9, 12, 14], "sql": [1, 4, 7, 8, 12, 14, 18, 19], "dbapihook": [1, 4], "A": [1, 12], "client": [1, 13], "interact": 1, "requir": [1, 4, 8], "snowflake_conn_id": [1, 4, 6, 7, 10, 12, 17, 18, 19], "connect": [1, 4, 6, 7, 12, 14, 17], "The": [1, 4, 7, 13, 14, 15], "host": [1, 19], "login": [1, 13, 18], "password": [1, 13, 18], "field": [1, 7, 12, 14], "must": [1, 6], "setup": [1, 12], "other": [1, 4, 6], "input": [1, 18, 19], "can": [1, 4, 6, 7, 13, 14, 15, 17, 18, 19], "defin": [1, 4, 6, 17], "instanti": 1, "paramet": [1, 4, 6, 7, 8, 12, 13, 14, 17, 18, 19], "refer": [1, 4, 6, 7, 8, 12, 17], "id": [1, 4, 6, 7, 12, 15, 18], "account": [1, 4, 6, 13, 18], "name": [1, 4, 6, 7, 12, 13, 17, 18], "authent": [1, 4, 6, 7, 12, 18], "default": [1, 4, 6, 7, 12, 18], "us": [1, 4, 6, 7, 10, 12, 13, 14, 15], "intern": [1, 4, 6], "externalbrows": [1, 4, 6], "your": [1, 4, 6, 14, 17, 18, 19], "web": [1, 4, 6], "browser": [1, 4, 6], "okta": [1, 4, 6], "adf": [1, 4, 6], "ani": [1, 4, 6, 15], "saml": [1, 4, 6], "compliant": [1, 4, 6], "identifi": [1, 4, 6], "idp": [1, 4, 6], "ha": [1, 4, 6], "been": [1, 4, 6], "http": [1, 4, 6, 8, 14, 15], "your_okta_account_nam": [1, 4, 6], "com": [1, 4, 6, 8, 14, 15], "through": [1, 4, 6], "nativ": [1, 4, 6], "warehous": [1, 4, 6, 7, 13, 18], "databas": [1, 4, 6, 7, 13, 18], "region": [1, 12, 13, 14, 18], "role": [1, 4, 6, 7, 12, 13, 14, 18], "schema": [1, 4, 6, 7, 12, 13, 14, 17, 18], "session_paramet": [1, 4, 6, 12, 13], "you": [1, 4, 6, 7, 12, 13, 14, 15], "set": [1, 4, 6, 7, 13, 18], "session": [1, 4, 6, 13], "level": [1, 4, 6, 12, 13], "time": [1, 4, 6], "insecure_mod": [1, 13], "turn": [1, 13], "off": [1, 13], "ocsp": [1, 13], "certif": [1, 13, 15], "check": [1, 4, 12, 13, 14, 15], "For": [1, 4, 6, 7, 12, 13, 14, 15], "detail": [1, 12, 13, 14, 15], "see": [1, 12, 13, 14, 17], "how": [1, 4, 6, 7, 13, 15], "To": [1, 13, 15], "driver": [1, 13], "commun": [1, 13], "get_sqlalchemy_engin": [1, 12, 14], "depend": [1, 4, 12], "sqlalchemi": [1, 14], "more": [1, 4, 6, 7, 12, 14, 17], "inform": [1, 4, 6, 7, 12], "take": [1, 4, 6, 7, 12, 14], "look": [1, 4, 6, 7], "guid": [1, 4, 6, 7, 12, 15], "snowflakeoper": [1, 4, 12, 16, 17, 19], "conn_name_attr": 1, "default_conn_nam": 1, "snowflake_default": [1, 4, 6, 7, 13], "conn_typ": [1, 13], "hook_nam": 1, "supports_autocommit": 1, "true": [1, 4, 6], "static": [1, 12], "get_connection_form_widget": 1, "return": [1, 4, 7, 8, 12], "widget": 1, "add": [1, 12, 14], "form": [1, 12], "get_ui_field_behaviour": 1, "custom": [1, 17, 19], "behaviour": 1, "get_uri": 1, "self": [1, 4, 6, 15], "overrid": 1, "method": [1, 4, 6, 12, 14], "get_conn": 1, "object": [1, 4], "engine_kwarg": 1, "none": [1, 4, 6, 7, 12, 15], "get": [1, 4, 12, 15], "sqlalchemy_engin": 1, "create_engin": 1, "creat": [1, 4, 6, 15], "engin": 1, "set_autocommit": 1, "conn": [1, 12], "autocommit": [1, 4, 6, 12], "flag": 1, "get_autocommit": 1, "fals": [1, 4, 18], "doe": 1, "support": [1, 12, 14], "from": [1, 4, 6, 7, 12, 14, 17], "type": [1, 4, 8, 12, 13, 14, 17], "bool": [1, 4], "run": [1, 4, 7, 14, 15], "handler": 1, "command": [1, 4, 6, 12, 18], "list": [1, 4, 6, 12, 14], "pass": [1, 4, 7, 12, 14, 17, 18], "statement": [1, 4, 7, 12], "them": [1, 14], "execut": [1, 4, 6, 7, 12, 18, 19], "sequenti": 1, "variabl": [1, 7, 13], "execution_info": 1, "so": [1, 4, 17, 18], "oper": [1, 2, 6, 7, 10, 12, 13, 14], "modifi": 1, "behavior": 1, "result": [1, 7, 10, 19], "queri": [1, 4, 7, 12, 19], "i": [1, 15], "e": [1, 19], "fail": [1, 4], "copi": [1, 6], "process": 1, "file": [1, 4, 6, 10, 12, 13, 14, 15, 17], "union": [1, 7], "str": [1, 4, 6, 7, 8, 12, 14], "string": [1, 4, 6, 8, 10, 12, 17, 18, 19], "possibl": 1, "multipl": [1, 12], "what": 1, "s": [1, 4, 6, 7, 8, 12, 15], "befor": [1, 4, 12], "option": [1, 4, 6, 7, 12, 13, 19], "sequenc": [1, 4, 6, 7, 12], "dict": [1, 4, 6, 12], "render": [1, 4, 6, 7, 12, 14], "callabl": 1, "which": [1, 8], "call": [1, 7, 12], "each": [1, 4], "test_connect": [1, 12, 14], "test": [1, 12, 17, 18, 19], "simpl": [1, 4], "hook": [2, 4, 12, 13, 14], "transfer": [2, 12], "s3_to_snowflak": [2, 5], "snowflake_to_slack": [2, 5, 19], "util": 2, "get_db_hook": 4, "instanc": [4, 17, 18, 19], "do_xcom_push": 4, "model": [4, 6], "baseoper": [4, 6], "code": [4, 12, 14, 15], "singl": [4, 6, 8, 12, 14], "templat": [4, 6, 7, 12, 14], "ar": [4, 7, 13, 14, 15], "recogn": 4, "end": 4, "automat": [4, 6, 14], "commit": [4, 12], "valu": [4, 10], "overwrit": [4, 6], "extra": [4, 6, 7, 13, 14, 18, 19], "json": [4, 6, 7], "template_field": [4, 6, 7, 12, 14], "template_ext": [4, 7], "template_fields_render": [4, 6, 7, 12], "ui_color": 4, "eded": 4, "context": [4, 6, 12], "snowflakecheckoper": 4, "sqlcheckoper": 4, "perform": 4, "against": [4, 7], "expect": 4, "row": 4, "first": [4, 12, 14], "evalu": 4, "python": [4, 12, 13, 14, 15], "cast": 4, "If": [4, 6, 7, 13, 14, 15], "error": [4, 12, 14], "out": [4, 12], "note": [4, 6, 12, 13], "eval": 4, "follow": [4, 13, 15, 17, 18, 19], "empti": [4, 12, 14], "dictionari": [4, 6, 13, 18, 19], "given": [4, 18], "like": 4, "select": [4, 15, 19], "count": 4, "foo": 4, "onli": [4, 14], "craft": 4, "much": 4, "complex": 4, "could": 4, "tabl": [4, 6, 7, 10, 17, 19], "same": [4, 6], "number": [4, 12], "upstream": 4, "todai": [4, 8], "partit": 4, "greater": 4, "than": 4, "yesterdai": 4, "metric": 4, "less": 4, "standard": 4, "deviat": 4, "7": 4, "dai": 4, "averag": 4, "data": [4, 7, 8, 12, 17], "qualiti": 4, "pipelin": 4, "where": [4, 12, 18], "put": 4, "dag": [4, 12, 14, 18], "have": [4, 12, 14], "choic": 4, "stop": [4, 12], "critic": 4, "path": [4, 6, 10, 13, 17, 18], "prevent": 4, "publish": [4, 19], "dubiou": 4, "side": 4, "receiv": 4, "email": 4, "alert": 4, "without": [4, 8], "progress": 4, "snowflakevaluecheckoper": 4, "pass_valu": 4, "toler": 4, "sqlvaluecheckoper": 4, "specifi": [4, 6, 7, 12, 13, 14, 17], "within": 4, "certain": 4, "allow": [4, 7, 12, 14, 17], "accept": 4, "snowflakeintervalcheckoper": 4, "metrics_threshold": 4, "date_filter_column": 4, "ds": 4, "days_back": 4, "sqlintervalcheckoper": 4, "express": [4, 6, 12], "ones": 4, "construct": 4, "metrics_threshold_dict_kei": 4, "date": 4, "supportsab": 4, "int": 4, "between": 4, "we": 4, "want": [4, 14, 15], "ratio": 4, "index": 4, "exampl": [4, 7, 8, 10, 12, 14, 15, 17, 18, 19], "5": 4, "would": 4, "50": 4, "percent": 4, "differ": [4, 7, 15], "current": 4, "prior": [4, 13], "contain": [6, 7, 15, 19], "aw": [6, 17], "s3": [6, 12, 17], "s3tosnowflakeoper": [6, 12, 14, 16], "s3_kei": [6, 12, 14, 17], "stage": [6, 12, 14, 17], "prefix": 6, "file_format": [6, 17], "columns_arrai": 6, "pattern": [6, 12, 14, 17], "load": [6, 17], "kei": [6, 7, 10, 12, 13, 14, 15], "specif": [6, 12, 17], "one": [6, 15, 17], "cloud": 6, "storag": 6, "locat": 6, "limit": [6, 12, 14], "format": [6, 12, 17, 19], "column": 6, "arrai": 6, "regular": 6, "match": [6, 12, 15, 17], "enclos": [6, 8], "quot": [6, 8, 12, 14], "all": [6, 8, 12, 13, 14], "replac": [6, 8], "two": [6, 8], "main": [6, 14, 15], "deriv": 6, "when": [6, 7, 12, 13, 14], "jinja": [6, 7], "get_template_context": 6, "snowflaketoslackoper": [7, 16], "slack_messag": [7, 19], "slack_conn_id": [7, 10, 19], "slack_default": 7, "results_df_nam": 7, "results_df": [7, 10], "slack_token": 7, "slack": [7, 12, 14], "sql_to_slack": 7, "sqltoslackoper": [7, 12, 14], "send": 7, "panda": 7, "datafram": [7, 19], "chang": [7, 12], "tabul": [7, 10], "librari": 7, "ad": [7, 12, 14], "environ": [7, 13], "filter": 7, "nice": 7, "tablefmt": [7, 10], "pretti": [7, 10], "header": [7, 10, 12], "ascii": [7, 10, 19], "messag": [7, 19], "access": 7, "iter": 7, "map": 7, "virtual": 7, "token": 7, "webhook_token": [7, 19], "attribut": [7, 12, 14], "need": [7, 13, 14], "j2": 7, "times_rend": 7, "enclose_param": 8, "param": [8, 12, 14], "doc": [8, 12, 14, 17], "en": 8, "text": [8, 12, 14], "html": 8, "constant": 8, "sale": 8, "project": [8, 12], "sampl": 8, "john": 8, "csv": [8, 10, 17], "awesom": 8, "enclosur": 8, "relat": [10, 13], "my_snowflake_conn": 10, "my_slack_conn": 10, "snowflake_schema": [10, 17, 18], "schema_nam": 10, "snowflake_stag": [10, 17], "stage_nam": 10, "snowflake_warehous": [10, 18], "warehouse_nam": 10, "snowflake_databas": [10, 18], "database_nam": 10, "snowflake_rol": [10, 18], "role_nam": 10, "snowflake_sample_t": [10, 17], "sample_t": 10, "s3_file_path": [10, 17], "sample_fil": 10, "create_table_sql_str": [10, 18], "sql_insert_stat": [10, 18], "sql_list": [10, 18], "sql_multiple_stmt": [10, 18], "snowflake_slack_sql": [10, 19], "snowflake_slack_messag": [10, 19], "multilin": [10, 12, 14], "show": 10, "env_id": 10, "dag_id": [10, 18], "snowflake_op_sql_str": [10, 18], "test_run": 10, "example_snowflak": [11, 17, 18, 19], "version": [12, 13, 14, 15], "high": 12, "changelog": 12, "includ": 12, "latest": 12, "2022": 12, "07": 12, "subject": 12, "46bbfdade0": 12, "move": [12, 14], "class": [12, 14], "24836": [12, 14], "0de31bd73a": 12, "06": 12, "29": 12, "insid": 12, "folder": [12, 15], "24672": 12, "13908c2c91": 12, "gener": [12, 14], "24663": [12, 14], "510a6bab45": 12, "28": 12, "remov": [12, 14, 15], "yaml": 12, "24702": 12, "8a34d25049": 12, "26": 12, "escap": [12, 14], "24607": [12, 14], "66e84001df": 12, "22": 12, "24571": [12, 14], "09": 12, "dcdcf3a2b8": 12, "updat": [12, 14], "releas": [12, 14], "rc2": 12, "mai": 12, "24307": 12, "717a7588bc": 12, "descript": 12, "doubl": 12, "min": 12, "24292": 12, "aeabe994b3": 12, "prepar": [12, 14], "24231": 12, "027b707d21": 12, "05": 12, "explanatori": 12, "contributor": 12, "about": [12, 15], "24229": 12, "c2f10a4ee9": 12, "03": 12, "migrat": [12, 14], "system": [12, 17, 18, 19], "new": 12, "design": 12, "22434": 12, "24151": 12, "86cfd1244a": 12, "20": 12, "fix": 12, "23767": [12, 14], "12": [12, 15], "75c60923e0": 12, "document": [12, 14], "11": [12, 15], "23631": 12, "b6aaf9e2fc": 12, "01": 12, "privat": [12, 13, 14], "23066": [12, 14], "d7dbfb7e26": 12, "bugfix": 12, "22383": 12, "d6ed9cb950": 12, "15": 12, "22266": [12, 14], "14": 12, "16adc035b1": 12, "classifi": 12, "march": 12, "22226": 12, "5d9b088dfa": 12, "22181": [12, 14], "f5b96315fe": 12, "feb": 12, "22056": 12, "02": 12, "08": 12, "d94fa37830": 12, "januari": 12, "delai": 12, "21439": 12, "6c3a67d4fc": 12, "2021": [12, 15, 18], "21257": 12, "39e395f981": 12, "04": 12, "21237": [12, 14], "534e9ae117": 12, "21096": [12, 14], "boolean": [12, 14], "extra__snowflake__insecure_mod": [12, 14], "21155": [12, 14], "cb73053211": 12, "27": 12, "21074": 12, "602abe8394": 12, "line": 12, "now": 12, "sphinx": 12, "autoapi": 12, "typehint": 12, "20951": 12, "9ea459a6bd": 12, "improv": [12, 14], "20745": 12, "31": 12, "f77417eb0d": 12, "k8": 12, "pypi": [12, 14], "compat": 12, "20614": 12, "97496ba2b4": 12, "decemb": 12, "20523": 12, "83f8e178ba": 12, "even": 12, "ext": 12, "20608": 12, "d56e7b56bb": 12, "30": 12, "mypi": 12, "friendli": 12, "20571": 12, "a0821235fb": 12, "everywher": 12, "20565": 12, "a632b74846": 12, "20509": [12, 14], "fcc3b92fb6": 12, "13": 12, "20212": 12, "89a66ae023": 12, "insecur": [12, 14], "mode": [12, 14], "20106": [12, 14], "7fb301b0b4": 12, "unus": [12, 14], "20107": [12, 14], "853576d901": 12, "novemb": 12, "19882": 12, "de9900539c": 12, "duplic": [12, 14], "get_connect": [12, 14], "19543": [12, 14], "10": [12, 14], "d9567eb106": 12, "octob": 12, "19321": 12, "d53d4f9c7c": 12, "25": 12, "tag": [12, 18], "littl": 12, "bit": 12, "up": 12, "part": 12, "19180": 12, "acfb7b5acf": 12, "19041": [12, 14], "0a37be3e3c": 12, "uri": [12, 14], "18650": [12, 14], "840ea3efb9": 12, "septemb": 12, "18613": 12, "ef037e7021": 12, "start_dat": [12, 18], "cleanup": 12, "misc": 12, "18597": 12, "a8970764d9": 12, "17741": [12, 14], "0a68588479": 12, "august": 12, "17890": 12, "be75dcd39c": 12, "23": 12, "meta": 12, "76ed2a49c6": 12, "19": 12, "import": [12, 14, 15], "lazili": 12, "individu": 12, "manag": [12, 15], "17682": 12, "97428efc41": 12, "mess": 12, "17380": 12, "87f408b1e7": 12, "juli": 12, "17116": 12, "0dbd0f420c": 12, "refactor": 12, "default_arg": [12, 18], "miscellan": 12, "16872": 12, "d02ded65ea": 12, "wrongli": 12, "charact": 12, "amazon": 12, "17020": 12, "b916b75079": 12, "17015": 12, "5999cb9a66": 12, "16735": [12, 14], "8b41c2e0b9": 12, "log": 12, "info": 12, "15736": 12, "866a601b76": 12, "pylint": 12, "our": 12, "toolchain": 12, "16682": 12, "18": 12, "bbc627a3da": 12, "16501": 12, "cbf8001d76": 12, "16": 12, "synchron": 12, "after": [12, 14], "buggfix": 12, "16464": 12, "608dd0ddf6": 12, "miss": 12, "16455": 12, "1fba5402bb": 12, "june": 12, "16405": 12, "643e46ca7a": 12, "abil": [12, 14], "usag": [12, 14, 17, 18, 19], "applic": [12, 14], "16420": [12, 14], "9c94b72d44": 12, "16294": 12, "aeb93f8e5b": 12, "restor": [12, 14], "16102": [12, 14], "20f3639403": 12, "s3tosnowflak": [12, 14], "15926": [12, 14], "6f956dc99b": 12, "omit": [12, 14], "15817": [12, 14], "37681bca00": 12, "auto": [12, 14], "appli": [12, 14], "apply_default": [12, 14], "decor": [12, 14], "15667": [12, 14], "807ad32ce5": 12, "pip": [12, 14, 15], "21": 12, "15576": 12, "c6be8b113d": 12, "expos": [12, 14], "query_id": [12, 14], "15533": [12, 14], "814e471d13": 12, "pre": 12, "15583": 12, "7a0d412245": 12, "15408": 12, "042be2e4e0": 12, "april": 12, "15236": 12, "9b76b94c94": 12, "bunch": 12, "addit": [12, 17, 19], "15130": 12, "68e4c4dcb0": 12, "backport": 12, "14886": 12, "e4bf8f3491": 12, "dynam": [12, 14], "14724": [12, 14], "b753c7fa60": 12, "hoc": 12, "four": 12, "previous": 12, "exclud": [12, 14], "14655": 12, "589d6dec92": 12, "next": [12, 14], "wave": [12, 14], "14487": [12, 14], "10343ec29f": 12, "correct": [12, 14, 15], "tool": [12, 14], "rc": [12, 14], "14082": [12, 14], "88bdcfa0df": 12, "14013": 12, "ac2f72c98d": 12, "implement": 12, "13767": 12, "a9ac2b040b": 12, "switch": 12, "f": 12, "flynt": 12, "13732": 12, "3fd5ef3555": 12, "logo": 12, "integr": [12, 13], "13717": 12, "85a3ce1a47": 12, "upload": [12, 14], "12505": [12, 14], "dbf751112f": 12, "argument": [12, 14, 18], "12564": [12, 14], "295d66f914": 12, "2020": 12, "grammar": 12, "warn": [12, 15], "13380": 12, "6cf76d7ac0": 12, "typo": 12, "upgrad": [12, 14], "13148": 12, "32971a1a2d": 12, "12955": 12, "b40dffa085": 12, "renam": 12, "rema": 12, "modul": 12, "aip": 12, "12917": 12, "9b39f24780": 12, "per": 12, "12558": 12, "bd90136aaf": 12, "12681": 12, "2037303eef": 12, "discoveri": 12, "12466": 12, "ef4af21351": 12, "separ": 12, "spell": 12, "job": 12, "build": [12, 15], "12527": 12, "234d689387": 12, "docstr": 12, "12504": 12, "c34ef853c8": 12, "12444": 12, "0080354502": 12, "readm": [12, 14], "0b2": 12, "batch": 12, "12449": 12, "7ca0b6f121": 12, "enabl": [12, 13], "markdownlint": 12, "rule": 12, "md003": 12, "head": 12, "style": 12, "12427": 12, "12438": 12, "ae7cb4a1e2": 12, "17": 12, "wrong": 12, "hash": 12, "12390": 12, "6889a333cf": 12, "ref": 12, "12366": 12, "7825e8f590": 12, "instal": 12, "12304": 12, "9276607b58": 12, "snowflake_hook": 12, "12071": 12, "85a18e13d9": 12, "point": 12, "page": [12, 15], "cross": 12, "12212": 12, "59eb5de78c": 12, "come": 12, "0beta1": 12, "12206": 12, "b2a28d1590": 12, "script": [12, 15], "dev": 12, "12082": 12, "41bf172c1d": 12, "simplifi": 12, "12093": 12, "4e8f9cc8d0": 12, "black": 12, "formmatt": 12, "9550": 12, "d363adb618": 12, "howto": 12, "11975": 12, "ecc3a4df0d": 12, "properti": 12, "10838": 12, "5a439e84eb": 12, "2a1": 12, "11855": 12, "872b1566a1": 12, "11826": 12, "4830687453": 12, "24": 12, "super": 12, "11806": 12, "349b0811c3": 12, "d200": 12, "pydocstyl": 12, "11688": 12, "16e7129719": 12, "11487": 12, "d305876bee": 12, "redund": 12, "11448": 12, "0a0e1af800": 12, "broken": 12, "markdown": 12, "link": [12, 15], "toc": 12, "11249": 12, "ca4238eb4d": 12, "month": 12, "11242": 12, "5220e4c384": 12, "11238": 12, "0161b5ea2b": 12, "increas": 12, "coverag": 12, "11159": 12, "9549274d11": 12, "8b1": 12, "10818": 12, "fdd9b6f65b": 12, "10543": 12, "d1bce91bb2": 12, "d403": 12, "capit": 12, "word": 12, "10530": 12, "3696c34c28": 12, "10528": 12, "ee7ca128a1": 12, "refernc": 12, "10483": 12, "f6734b3b85": 12, "spellcheck": 12, "10280": 12, "cdec301254": 12, "signatur": [12, 14, 15], "sensor": [12, 13], "10205": 12, "24c8e4c2d6": 12, "constructor": 12, "10163": 12, "aeea71274d": 12, "10097": 12, "7d24b088cd": 12, "example_dag": 12, "9985": 12, "d0e7db4024": 12, "fresh": 12, "9408": 12, "12af6a0800": 12, "final": 12, "23rc1": 12, "9404": 12, "c7e5bce57f": 12, "candid": 12, "9370": 12, "f6bd817a3a": 12, "introduc": 12, "9320": 12, "1c9374d257": 12, "9023": 12, "0b0e4f7a4c": 12, "rc3": 12, "relas": 12, "9026": 12, "00642a46d0": 12, "remain": 12, "8994": 12, "1d36b0303b": 12, "8984": 12, "375d1ca229": 12, "8898": 12, "12c5e5d8a": 12, "8891": 12, "a546a10b13": 12, "8422": 12, "f3521fb0e3": 12, "regener": 12, "8886": 12, "92585ca4cb": 12, "autom": 12, "8807": 12, "cd635dd7d5": 12, "5906": 12, "8642": 12, "297ad30885": 12, "8423": 12, "cf1109d661": 12, "6755": 12, "bug": 12, "7380": 12, "97a429f9d0": 12, "6714": 12, "magic": 12, "comment": 12, "utf": 12, "8": 12, "7338": 12, "eee34ee808": 12, "4204": 12, "7248": 12, "17af3beea5": 12, "5816": 12, "6469": 12, "connector": [13, 14], "usernam": 13, "public": 13, "passphras": 13, "oauth": 13, "oath": 13, "private_key_fil": 13, "private_key_cont": 13, "content": 13, "serial": 13, "airflow": [13, 15], "export": 13, "airflow_conn_snowflake_default": 13, "user": [13, 15, 18], "db": [13, 14], "snow": 13, "east": 13, "compon": 13, "should": [13, 15], "url": [13, 19], "encod": 13, "api": 14, "repositori": 14, "top": [14, 15], "exist": [14, 17], "below": [14, 15], "minimum": 14, "via": [14, 15], "those": [14, 15], "might": 14, "order": [14, 17], "verifi": 14, "checksum": [14, 15], "site": 14, "sdist": [14, 15], "asc": [14, 15], "sha512": [14, 15], "wheel": 14, "avail": [14, 15], "explain": 14, "polici": 14, "github": 14, "blob": 14, "md": 14, "mistakenli": 14, "install_requir": 14, "22382": 14, "v1": 14, "20245": 14, "20395": 14, "optimis": 14, "due": 14, "least": 14, "otherwis": 14, "manual": 14, "complet": 14, "initi": 14, "describ": 15, "download": 15, "apach": 15, "provid": [15, 17, 18, 19], "snowflak": [15, 17, 19], "offici": 15, "also": 15, "most": 15, "choos": 15, "drop": 15, "down": 15, "left": 15, "whl": 15, "origin": 15, "softwar": 15, "foundat": 15, "abov": 15, "pgp": 15, "It": 15, "essenti": 15, "sha": 15, "gpg": 15, "pleas": 15, "well": 15, "relev": [15, 17, 19], "distribut": 15, "recommend": 15, "directori": 15, "mirror": 15, "pgpk": 15, "ka": 15, "binari": 15, "pgpv": 15, "tar": 15, "gz": 15, "made": 15, "sat": 15, "sep": 15, "49": 15, "54": 15, "bst": 15, "rsa": 15, "cde15c6e4d3a8ec4ecf4ba4b6674e08ad7de406f": 15, "issuer": 15, "kaxilnaik": 15, "org": 15, "good": 15, "kaxil": 15, "naik": 15, "unknown": 15, "aka": 15, "gmail": 15, "certifi": 15, "trust": 15, "There": 15, "indic": 15, "belong": 15, "owner": 15, "primari": 15, "fingerprint": 15, "cde1": 15, "5c6e": 15, "4d3a": 15, "8ec4": 15, "ecf4": 15, "ba4b": 15, "6674": 15, "e08a": 15, "d7de": 15, "406f": 15, "do": [15, 17], "worri": 15, "sign": 15, "why": 15, "By": 15, "server": 15, "previou": 15, "step": 15, "know": 15, "valid": 15, "alreadi": [15, 17, 18], "sum": 15, "shasum": 15, "512": 15, "diff": 15, "local": 15, "bin": 15, "bash": 15, "package_vers": 15, "package_nam": 15, "provider_download_dir": 15, "mktemp": 15, "d": 15, "dep": 15, "dest": 15, "curl": 15, "apache_airflow_providers_snowflak": 15, "py3": 15, "l": 15, "o": 15, "echo": 15, "ls": 15, "la": 15, "onc": 15, "instruct": 15, "chapter": 15, "temporari": 15, "store": 17, "similarli": [17, 19], "establish": [17, 19], "predefin": [17, 19], "In": 17, "either": 17, "py": [17, 18, 19], "copy_into_t": 17, "task_id": [17, 18, 19], "field_delimit": 17, "structur": 18, "datetim": 18, "catchup": 18, "snowflake_op_with_param": 18, "56": 18, "snowflake_op_sql_list": 18, "snowflake_op_sql_multiple_stmt": 18, "snowflake_op_template_fil": 18, "filenam": 18, "onto": 18, "prioriti": 18, "over": 18, "forth": 18, "post": 19, "channel": 19, "dataset": 19, "g": 19, "slack_report": 19}, "objects": {"airflow.providers": [[2, 0, 0, "-", "snowflake"]], "airflow.providers.snowflake": [[0, 0, 0, "-", "hooks"], [3, 0, 0, "-", "operators"], [5, 0, 0, "-", "transfers"], [9, 0, 0, "-", "utils"]], "airflow.providers.snowflake.hooks": [[1, 0, 0, "-", "snowflake"]], "airflow.providers.snowflake.hooks.snowflake": [[1, 1, 1, "", "SnowflakeHook"]], "airflow.providers.snowflake.hooks.snowflake.SnowflakeHook": [[1, 2, 1, "", "conn_name_attr"], [1, 2, 1, "", "conn_type"], [1, 2, 1, "", "default_conn_name"], [1, 3, 1, "", "get_autocommit"], [1, 3, 1, "", "get_conn"], [1, 3, 1, "", "get_connection_form_widgets"], [1, 3, 1, "", "get_sqlalchemy_engine"], [1, 3, 1, "", "get_ui_field_behaviour"], [1, 3, 1, "", "get_uri"], [1, 2, 1, "", "hook_name"], [1, 3, 1, "", "run"], [1, 3, 1, "", "set_autocommit"], [1, 2, 1, "", "supports_autocommit"], [1, 3, 1, "", "test_connection"]], "airflow.providers.snowflake.operators": [[4, 0, 0, "-", "snowflake"]], "airflow.providers.snowflake.operators.snowflake": [[4, 1, 1, "", "SnowflakeCheckOperator"], [4, 1, 1, "", "SnowflakeIntervalCheckOperator"], [4, 1, 1, "", "SnowflakeOperator"], [4, 1, 1, "", "SnowflakeValueCheckOperator"], [4, 4, 1, "", "get_db_hook"]], "airflow.providers.snowflake.operators.snowflake.SnowflakeCheckOperator": [[4, 3, 1, "", "get_db_hook"], [4, 2, 1, "", "template_ext"], [4, 2, 1, "", "template_fields"], [4, 2, 1, "", "ui_color"]], "airflow.providers.snowflake.operators.snowflake.SnowflakeIntervalCheckOperator": [[4, 3, 1, "", "get_db_hook"]], "airflow.providers.snowflake.operators.snowflake.SnowflakeOperator": [[4, 3, 1, "", "execute"], [4, 3, 1, "", "get_db_hook"], [4, 2, 1, "", "template_ext"], [4, 2, 1, "", "template_fields"], [4, 2, 1, "", "template_fields_renderers"], [4, 2, 1, "", "ui_color"]], "airflow.providers.snowflake.operators.snowflake.SnowflakeValueCheckOperator": [[4, 3, 1, "", "get_db_hook"]], "airflow.providers.snowflake.transfers": [[6, 0, 0, "-", "s3_to_snowflake"], [7, 0, 0, "-", "snowflake_to_slack"]], "airflow.providers.snowflake.transfers.s3_to_snowflake": [[6, 1, 1, "", "S3ToSnowflakeOperator"]], "airflow.providers.snowflake.transfers.s3_to_snowflake.S3ToSnowflakeOperator": [[6, 3, 1, "", "execute"], [6, 2, 1, "", "template_fields"], [6, 2, 1, "", "template_fields_renderers"]], "airflow.providers.snowflake.transfers.snowflake_to_slack": [[7, 1, 1, "", "SnowflakeToSlackOperator"]], "airflow.providers.snowflake.transfers.snowflake_to_slack.SnowflakeToSlackOperator": [[7, 2, 1, "", "template_ext"], [7, 2, 1, "", "template_fields"], [7, 2, 1, "", "template_fields_renderers"], [7, 2, 1, "", "times_rendered"]], "airflow.providers.snowflake.utils": [[8, 0, 0, "-", "common"]], "airflow.providers.snowflake.utils.common": [[8, 4, 1, "", "enclose_param"]], "tests.system.providers": [[11, 0, 0, "-", "snowflake"]], "tests.system.providers.snowflake": [[10, 0, 0, "-", "example_snowflake"]], "tests.system.providers.snowflake.example_snowflake": [[10, 5, 1, "", "CREATE_TABLE_SQL_STRING"], [10, 5, 1, "", "DAG_ID"], [10, 5, 1, "", "ENV_ID"], [10, 5, 1, "", "S3_FILE_PATH"], [10, 5, 1, "", "SLACK_CONN_ID"], [10, 5, 1, "", "SNOWFLAKE_CONN_ID"], [10, 5, 1, "", "SNOWFLAKE_DATABASE"], [10, 5, 1, "", "SNOWFLAKE_ROLE"], [10, 5, 1, "", "SNOWFLAKE_SAMPLE_TABLE"], [10, 5, 1, "", "SNOWFLAKE_SCHEMA"], [10, 5, 1, "", "SNOWFLAKE_SLACK_MESSAGE"], [10, 5, 1, "", "SNOWFLAKE_SLACK_SQL"], [10, 5, 1, "", "SNOWFLAKE_STAGE"], [10, 5, 1, "", "SNOWFLAKE_WAREHOUSE"], [10, 5, 1, "", "SQL_INSERT_STATEMENT"], [10, 5, 1, "", "SQL_LIST"], [10, 5, 1, "", "SQL_MULTIPLE_STMTS"], [10, 5, 1, "", "snowflake_op_sql_str"], [10, 5, 1, "", "test_run"]]}, "objtypes": {"0": "py:module", "1": "py:class", "2": "py:attribute", "3": "py:method", "4": "py:function", "5": "py:data"}, "objnames": {"0": ["py", "module", "Python module"], "1": ["py", "class", "Python class"], "2": ["py", "attribute", "Python attribute"], "3": ["py", "method", "Python method"], "4": ["py", "function", "Python function"], "5": ["py", "data", "Python data"]}, "titleterms": {"airflow": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 14, 18, 19], "provid": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14], "snowflak": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 18], "hook": [0, 1], "submodul": [0, 3, 5, 9, 11], "modul": [1, 4, 6, 7, 8, 10], "content": [1, 4, 6, 7, 8, 10, 14], "class": [1, 4, 6, 7], "subpackag": 2, "oper": [3, 4, 16, 17, 18, 19], "function": [4, 8], "transfer": [5, 6, 7], "s3_to_snowflak": 6, "snowflake_to_slack": 7, "util": [8, 9], "common": 8, "test": [10, 11], "system": [10, 11], "example_snowflak": 10, "packag": [12, 14, 15], "apach": [12, 14], "3": [12, 14], "1": [12, 14], "0": [12, 14], "2": [12, 14], "7": [12, 14], "6": [12, 14], "5": [12, 14], "4": [12, 14], "connect": [13, 18, 19], "authent": 13, "default": 13, "id": 13, "configur": 13, "uri": 13, "format": 13, "exampl": 13, "json": 13, "guid": 14, "refer": 14, "resourc": 14, "commit": 14, "instal": [14, 15], "requir": 14, "cross": 14, "depend": 14, "download": 14, "offici": 14, "changelog": 14, "featur": 14, "bug": 14, "fix": 14, "break": 14, "chang": 14, "misc": 14, "from": 15, "sourc": 15, "releas": 15, "integr": 15, "verifi": 15, "pypi": 15, "s3tosnowflakeoper": 17, "us": [17, 18, 19], "snowflakeoper": 18, "metadata": [18, 19], "snowflaketoslackoper": 19, "slack": 19, "webhook": 19}, "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}})