Search.setIndex({"docnames": ["_api/airflow/providers/jdbc/hooks/index", "_api/airflow/providers/jdbc/hooks/jdbc/index", "_api/airflow/providers/jdbc/index", "_api/airflow/providers/jdbc/operators/index", "_api/airflow/providers/jdbc/operators/jdbc/index", "_api/tests/system/providers/jdbc/example_jdbc_queries/index", "_api/tests/system/providers/jdbc/index", "commits", "connections/jdbc", "index", "installing-providers-from-sources", "operators"], "filenames": ["_api/airflow/providers/jdbc/hooks/index.rst", "_api/airflow/providers/jdbc/hooks/jdbc/index.rst", "_api/airflow/providers/jdbc/index.rst", "_api/airflow/providers/jdbc/operators/index.rst", "_api/airflow/providers/jdbc/operators/jdbc/index.rst", "_api/tests/system/providers/jdbc/example_jdbc_queries/index.rst", "_api/tests/system/providers/jdbc/index.rst", "commits.rst", "connections/jdbc.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.jdbc.hooks</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.jdbc.hooks.jdbc</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.jdbc</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.jdbc.operators</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.jdbc.operators.jdbc</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.jdbc.example_jdbc_queries</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.jdbc</span></code>", "Package apache-airflow-providers-jdbc", "JDBC connection", "<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-jdbc</span></code>", "Installing from sources", "JdbcOperator"], "terms": {"3": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "1": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "0": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "2": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "4": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], "dev0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], "thi": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], "an": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], "experiment": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], "featur": [0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 11], "jdbchook": [1, 7, 9], "arg": [1, 7], "schema": [1, 8], "none": [1, 4, 10], "log_sql": 1, "true": [1, 4, 11], "kwarg": [1, 4], "sourc": [1, 4, 5, 8, 9, 11], "base": [1, 4], "common": [1, 7, 9], "sql": [1, 4, 7, 9, 11], "dbapihook": [1, 4], "gener": [1, 7], "db": [1, 9], "access": [1, 11], "url": [1, 8], "usernam": 1, "password": [1, 8], "taken": 1, "from": [1, 7, 9, 11], "predefin": [1, 4], "connect": [1, 7, 9, 11], "note": [1, 7], "whole": 1, "must": [1, 11], "specifi": [1, 8, 9], "host": [1, 8, 11], "field": [1, 7, 9], "rais": 1, "error": [1, 11], "given": 1, "id": [1, 10], "doesn": 1, "t": 1, "exist": [1, 9], "conn_name_attr": 1, "jdbc_conn_id": [1, 4, 11], "default_conn_nam": 1, "jdbc_default": [1, 4], "conn_typ": 1, "hook_nam": 1, "supports_autocommit": 1, "static": [1, 7], "get_connection_form_widget": 1, "return": [1, 4], "widget": 1, "add": [1, 7, 9, 11], "form": [1, 7], "get_ui_field_behaviour": 1, "custom": 1, "behaviour": 1, "get_conn": 1, "self": [1, 4, 10], "object": 1, "set_autocommit": 1, "conn": [1, 11], "autocommit": [1, 4, 11], "enabl": [1, 7, 8], "disabl": 1, "paramet": [1, 4, 7, 8, 9, 11], "jaydebeapi": [1, 4, 9, 11], "The": [1, 8, 9, 10, 11], "bool": [1, 4], "s": [1, 7, 10], "set": [1, 11], "get_autocommit": 1, "get": [1, 10], "fals": [1, 4, 11], "type": [1, 7, 8, 9], "hook": [2, 7], "oper": [2, 7, 9, 11], "fetch_all_handl": 4, "cursor": 4, "handler": [4, 7, 9], "run": [4, 7, 9, 10, 11], "result": 4, "jdbcoper": [4, 5, 7, 8, 9], "model": 4, "baseoper": 4, "execut": [4, 7, 11], "code": [4, 10, 11], "databas": [4, 7, 8, 9, 11], "us": [4, 7, 8, 9, 10, 11], "driver": [4, 8, 11], "requir": [4, 8], "For": [4, 7, 8, 9, 10], "more": [4, 7, 9], "inform": [4, 7, 11], "how": [4, 7, 10, 11], "take": 4, "look": 4, "guid": [4, 7, 10], "union": 4, "str": 4, "list": [4, 7, 9, 11], "singl": 4, "string": [4, 7, 11], "statement": [4, 11], "refer": [4, 7, 11], "templat": [4, 7, 9], "file": [4, 7, 9, 10, 11], "ar": [4, 8, 9, 10, 11], "recogn": [4, 11], "end": [4, 11], "each": [4, 11], "command": [4, 7, 11], "automat": [4, 9], "commit": [4, 7, 11], "default": [4, 7, 11], "valu": [4, 11], "option": [4, 7, 8, 9], "map": 4, "iter": 4, "render": [4, 7, 9], "queri": 4, "template_field": [4, 7], "sequenc": [4, 7, 8], "template_ext": 4, "template_fields_render": 4, "ui_color": 4, "eded": 4, "context": [4, 7], "main": [4, 9, 10], "method": 4, "deriv": 4, "when": [4, 7, 9], "creat": [4, 10], "same": 4, "dictionari": [4, 8], "jinja": [4, 11], "get_template_context": 4, "exampl": [5, 7, 9, 10], "dag": [5, 7, 9], "demonstr": 5, "usag": [5, 7], "env_id": 5, "dag_id": 5, "example_jdbc_oper": 5, "run_this_last": 5, "test_run": 5, "example_jdbc_queri": [6, 11], "java": [7, 8, 9, 11], "detail": [7, 9, 10], "chang": 7, "version": [7, 9, 10], "high": 7, "level": 7, "changelog": 7, "see": [7, 9], "includ": 7, "latest": 7, "2022": 7, "07": 7, "subject": 7, "46bbfdade0": 7, "move": [7, 9], "all": [7, 9], "class": [7, 8, 9], "24836": [7, 9], "0de31bd73a": 7, "06": 7, "29": 7, "depend": 7, "insid": 7, "folder": [7, 10], "24672": 7, "510a6bab45": 7, "28": 7, "remov": [7, 9, 10], "name": [7, 8], "yaml": 7, "24702": 7, "09": 7, "dcdcf3a2b8": 7, "updat": [7, 9], "releas": [7, 9], "rc2": 7, "mai": [7, 11], "24307": 7, "717a7588bc": 7, "descript": 7, "doubl": 7, "min": 7, "specif": 7, "24292": 7, "aeabe994b3": 7, "prepar": 7, "doc": 7, "24231": 7, "027b707d21": 7, "05": 7, "explanatori": 7, "contributor": 7, "about": [7, 10], "24229": 7, "9f7ab0dd0a": 7, "03": 7, "migrat": [7, 9], "new": [7, 11], "design": 7, "22450": 7, "24137": 7, "b205a67af": 7, "22": 7, "23817": [7, 9], "75c60923e0": 7, "12": [7, 10], "document": [7, 9], "11": [7, 10], "23631": 7, "8b6b0848a3": 7, "04": 7, "23": 7, "brees": 7, "build": [7, 8, 10], "pull": 7, "verifi": [7, 9], "imag": 7, "23104": 7, "49e336ae03": 7, "13": 7, "replac": [7, 11], "dummyoper": 7, "emptyoper": 7, "22974": 7, "d7dbfb7e26": 7, "bugfix": 7, "22383": 7, "14": 7, "16adc035b1": 7, "classifi": [7, 9], "march": 7, "22226": 7, "f5b96315fe": 7, "feb": 7, "22056": 7, "02": 7, "08": 7, "d94fa37830": 7, "fix": 7, "januari": 7, "delai": 7, "21439": 7, "6c3a67d4fc": 7, "2021": [7, 10], "21257": 7, "39e395f981": 7, "21237": [7, 9], "cb73053211": 7, "01": 7, "27": 7, "21074": [7, 9], "602abe8394": 7, "20": 7, "line": 7, "now": 7, "sphinx": 7, "autoapi": 7, "support": [7, 8, 9], "typehint": 7, "20951": 7, "f77417eb0d": 7, "31": 7, "k8": 7, "pypi": [7, 9], "compat": 7, "20614": 7, "97496ba2b4": 7, "decemb": 7, "20523": 7, "83f8e178ba": 7, "even": 7, "ext": 7, "20608": 7, "d56e7b56bb": 7, "30": 7, "have": [7, 9, 11], "mypi": 7, "friendli": 7, "20571": 7, "a0821235fb": 7, "everywher": 7, "20565": 7, "853576d901": 7, "novemb": 7, "19882": 7, "d9567eb106": 7, "10": [7, 9], "octob": 7, "19321": 7, "840ea3efb9": 7, "septemb": 7, "18613": 7, "ef037e7021": 7, "start_dat": 7, "cleanup": 7, "misc": 7, "18597": 7, "0a68588479": 7, "august": 7, "17890": 7, "be75dcd39c": 7, "meta": 7, "data": [7, 8, 11], "76ed2a49c6": 7, "19": 7, "import": [7, 9, 10], "lazili": 7, "individu": 7, "manag": [7, 10], "17682": 7, "bb52098cd6": 7, "annot": [7, 9], "oracleoper": [7, 9], "sqliteoper": [7, 9], "17406": [7, 9], "87f408b1e7": 7, "26": 7, "juli": 7, "17116": 7, "0dbd0f420c": 7, "refactor": 7, "default_arg": 7, "pattern": 7, "miscellan": 7, "16872": 7, "18": 7, "bbc627a3da": 7, "16501": 7, "cbf8001d76": 7, "16": 7, "synchron": 7, "after": [7, 11], "buggfix": 7, "16464": 7, "1fba5402bb": 7, "15": 7, "june": 7, "16405": 7, "9c94b72d44": 7, "16294": 7, "37681bca00": 7, "auto": [7, 9], "appli": [7, 9], "apply_default": [7, 9], "decor": [7, 9], "15667": [7, 9], "807ad32ce5": 7, "pip": [7, 9, 10, 11], "21": 7, "15576": 7, "40a2476a5d": 7, "interact": 7, "15518": 7, "68e4c4dcb0": 7, "backport": 7, "14886": 7, "6e6526a0f6": 7, "broken": 7, "14734": 7, "f5a35f4c80": 7, "some": 7, "small": 7, "typo": 7, "also": [7, 10], "test": [7, 11], "rst": 7, "14594": 7, "88bdcfa0df": 7, "wave": 7, "14013": 7, "ac2f72c98d": 7, "implement": 7, "tool": 7, "13767": 7, "3fd5ef3555": 7, "miss": [7, 11], "logo": 7, "integr": 7, "13717": 7, "295d66f914": 7, "2020": 7, "grammar": 7, "warn": [7, 10], "13380": 7, "6cf76d7ac0": 7, "upgrad": [7, 9], "13148": 7, "32971a1a2d": 7, "12955": 7, "d5589673a9": 7, "dummy_oper": 7, "py": [7, 11], "dummi": 7, "11178": 7, "11293": 7, "b40dffa085": 7, "renam": 7, "rema": 7, "modul": [7, 11], "match": [7, 10], "aip": 7, "12917": 7, "9b39f24780": 7, "dynam": 7, "per": 7, "12558": 7, "bd90136aaf": 7, "12681": 7, "2037303eef": 7, "discoveri": 7, "12466": 7, "c34ef853c8": 7, "separ": 7, "out": [7, 8], "12444": 7, "0080354502": 7, "readm": [7, 9], "0b2": 7, "batch": 7, "12449": 7, "ae7cb4a1e2": 7, "17": 7, "wrong": 7, "hash": 7, "12390": 7, "6889a333cf": 7, "improv": 7, "ref": 7, "12366": 7, "7825e8f590": 7, "instal": [7, 11], "12304": 7, "85a18e13d9": 7, "point": [7, 11], "project": 7, "page": [7, 10], "cross": 7, "12212": 7, "59eb5de78c": 7, "up": 7, "come": 7, "0beta1": 7, "12206": 7, "b2a28d1590": 7, "script": [7, 10], "dev": 7, "12082": 7, "41bf172c1d": 7, "simplifi": 7, "express": 7, "12093": 7, "4e8f9cc8d0": 7, "black": 7, "python": [7, 8, 9, 10, 11], "formmatt": 7, "9550": 7, "a7ad20455c": 7, "11946": 7, "ba9c044d20": 7, "11472": 7, "5a439e84eb": 7, "2a1": 7, "11855": 7, "872b1566a1": 7, "25": 7, "setup": 7, "11826": 7, "16e7129719": 7, "ad": [7, 8, 9], "11487": 7, "0a0e1af800": 7, "markdown": 7, "link": [7, 10], "toc": 7, "11249": 7, "ca4238eb4d": 7, "month": 7, "11242": 7, "5220e4c384": 7, "11238": 7, "54353f8745": 7, "increas": 7, "coverag": 7, "five": 7, "differ": [7, 10], "11170": 7, "f3e87c5030": 7, "d202": 7, "pydocstyl": 7, "check": [7, 10], "11032": 7, "9dd8310dc1": 7, "11021": 7, "fdd9b6f65b": 7, "10543": 7, "3696c34c28": 7, "24": 7, "word": 7, "10528": 7, "ee7ca128a1": 7, "refernc": 7, "10483": 7, "cdec301254": 7, "correct": [7, 10], "signatur": [7, 9, 10], "sensor": 7, "10205": 7, "aeea71274d": 7, "constructor": 7, "10097": 7, "d0e7db4024": 7, "number": 7, "fresh": 7, "9408": 7, "12af6a0800": 7, "final": 7, "6": 7, "23rc1": 7, "9404": 7, "c7e5bce57f": 7, "candid": 7, "9370": 7, "f6bd817a3a": 7, "introduc": 7, "transfer": 7, "9320": 7, "0b0e4f7a4c": 7, "rc3": 7, "relas": 7, "9026": 7, "00642a46d0": 7, "remain": 7, "wrongli": 7, "8994": 7, "1d36b0303b": 7, "8984": 7, "375d1ca229": 7, "8898": 7, "12c5e5d8a": 7, "8891": 7, "f3521fb0e3": 7, "regener": 7, "8886": 7, "92585ca4cb": 7, "autom": 7, "8807": 7, "4bde99f132": 7, "make": 7, "pylint": 7, "7802": 7, "ca8857beaa": 7, "instanc": 7, "attribut": 7, "variabl": [7, 11], "7819": 7, "97a429f9d0": 7, "6714": 7, "magic": 7, "comment": 7, "utf": 7, "8": 7, "7338": 7, "9a04013b0": 7, "6646": 7, "protocol": 7, "7268": 7, "login": 8, "user": [8, 10], "port": 8, "Not": 8, "extra": [8, 9], "json": 8, "can": [8, 9, 10, 11], "follow": [8, 10], "standard": 8, "conn_prefix": 8, "front": 8, "extra__jdbc__drv_clsnam": 8, "full": 8, "qualifi": 8, "extra__jdbc__drv_path": 8, "jar": [8, 11], "filenam": 8, "lib": 8, "api": [9, 11], "repositori": 9, "you": [9, 10, 11], "top": [9, 10], "below": [9, 10], "minimum": 9, "via": [9, 10, 11], "those": [9, 10], "might": 9, "need": [9, 11], "order": 9, "them": 9, "checksum": [9, 10], "site": 9, "sdist": [9, 10], "asc": [9, 10], "sha512": [9, 10], "wheel": 9, "onli": 9, "avail": [9, 10, 11], "explain": 9, "polici": 9, "http": [9, 10], "github": 9, "com": [9, 10, 11], "blob": 9, "md": 9, "mistakenli": 9, "install_requir": 9, "22382": 9, "trove": 9, "framework": 9, "optimis": 9, "due": 9, "If": [9, 10], "your": [9, 11], "want": [9, 10], "first": 9, "least": 9, "otherwis": 9, "manual": 9, "complet": 9, "initi": 9, "describ": 10, "download": 10, "apach": [10, 11], "airflow": [10, 11], "provid": [10, 11], "jdbc": [10, 11], "offici": 10, "most": 10, "choos": 10, "select": [10, 11], "drop": 10, "down": 10, "left": 10, "whl": 10, "origin": 10, "softwar": 10, "foundat": 10, "abov": 10, "contain": 10, "pgp": 10, "kei": 10, "It": 10, "essenti": 10, "sha": 10, "gpg": 10, "pleas": 10, "well": 10, "relev": 10, "distribut": 10, "recommend": 10, "directori": 10, "mirror": 10, "i": 10, "pgpk": 10, "ka": 10, "To": [10, 11], "binari": 10, "pgpv": 10, "tar": 10, "gz": 10, "made": 10, "sat": 10, "sep": 10, "49": 10, "54": 10, "bst": 10, "rsa": 10, "cde15c6e4d3a8ec4ecf4ba4b6674e08ad7de406f": 10, "issuer": 10, "kaxilnaik": 10, "org": 10, "good": 10, "kaxil": 10, "naik": 10, "unknown": 10, "aka": 10, "gmail": 10, "certifi": 10, "trust": 10, "There": 10, "indic": 10, "belong": 10, "owner": 10, "primari": 10, "fingerprint": 10, "cde1": 10, "5c6e": 10, "4d3a": 10, "8ec4": 10, "ecf4": 10, "ba4b": 10, "6674": 10, "e08a": 10, "d7de": 10, "406f": 10, "do": 10, "worri": 10, "certif": 10, "sign": 10, "why": 10, "By": 10, "server": 10, "previou": 10, "step": 10, "know": 10, "valid": 10, "alreadi": 10, "sum": 10, "shasum": 10, "512": 10, "diff": 10, "should": [10, 11], "one": 10, "local": 10, "bin": 10, "bash": [10, 11], "package_vers": 10, "package_nam": 10, "provider_download_dir": 10, "mktemp": 10, "d": 10, "dep": 10, "dest": 10, "curl": 10, "apache_airflow_providers_jdbc": 10, "py3": 10, "ani": 10, "l": 10, "o": 10, "echo": 10, "ls": 10, "la": 10, "onc": [10, 11], "instruct": 10, "chapter": 10, "temporari": 10, "applic": 11, "program": 11, "interfac": 11, "languag": 11, "which": 11, "defin": 11, "client": 11, "block": 11, "jvm": 11, "java_hom": 11, "env": 11, "satisfi": 11, "abl": 11, "snippet": 11, "ones": 11, "relat": 11, "other": 11, "messag": 11, "case": 11, "A": 11, "refus": 11, "mean": 11, "where": 11, "listen": 11, "driver_class": 11, "exasol": 11, "exadriv": 11, "driver_path": 11, "opt": 11, "exasolution_jdbc": 11, "7": 11, "exajdbc": 11, "connection_url": 11, "exa": 11, "localhost": 11, "credenti": 11, "against": 11, "storag": 11, "pass": 11, "system": 11, "insert_data": 11, "task_id": 11, "insert": 11, "my_schema": 11, "my_tabl": 11, "dt": 11, "source_data": 11, "my_jdbc_connect": 11, "receiv": 11, "parameter": 11, "delete_data": 11, "delet": 11, "ds": 11}, "objects": {"airflow.providers": [[2, 0, 0, "-", "jdbc"]], "airflow.providers.jdbc": [[0, 0, 0, "-", "hooks"], [3, 0, 0, "-", "operators"]], "airflow.providers.jdbc.hooks": [[1, 0, 0, "-", "jdbc"]], "airflow.providers.jdbc.hooks.jdbc": [[1, 1, 1, "", "JdbcHook"]], "airflow.providers.jdbc.hooks.jdbc.JdbcHook": [[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_ui_field_behaviour"], [1, 2, 1, "", "hook_name"], [1, 3, 1, "", "set_autocommit"], [1, 2, 1, "", "supports_autocommit"]], "airflow.providers.jdbc.operators": [[4, 0, 0, "-", "jdbc"]], "airflow.providers.jdbc.operators.jdbc": [[4, 1, 1, "", "JdbcOperator"], [4, 4, 1, "", "fetch_all_handler"]], "airflow.providers.jdbc.operators.jdbc.JdbcOperator": [[4, 3, 1, "", "execute"], [4, 2, 1, "", "template_ext"], [4, 2, 1, "", "template_fields"], [4, 2, 1, "", "template_fields_renderers"], [4, 2, 1, "", "ui_color"]], "tests.system.providers": [[6, 0, 0, "-", "jdbc"]], "tests.system.providers.jdbc": [[5, 0, 0, "-", "example_jdbc_queries"]], "tests.system.providers.jdbc.example_jdbc_queries": [[5, 5, 1, "", "DAG_ID"], [5, 5, 1, "", "ENV_ID"], [5, 5, 1, "", "run_this_last"], [5, 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, 7, 9], "provid": [0, 1, 2, 3, 4, 5, 6, 7, 9], "jdbc": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9], "hook": [0, 1], "submodul": [0, 3, 6], "modul": [1, 4, 5], "content": [1, 4, 5, 9], "class": [1, 4], "subpackag": 2, "oper": [3, 4], "function": 4, "test": [5, 6], "system": [5, 6], "example_jdbc_queri": 5, "packag": [7, 9, 10], "apach": [7, 9], "3": [7, 9], "1": [7, 9], "0": [7, 9], "2": [7, 9], "connect": 8, "configur": 8, "guid": 9, "refer": 9, "resourc": 9, "commit": 9, "instal": [9, 10], "requir": 9, "cross": 9, "depend": 9, "download": 9, "offici": 9, "changelog": 9, "featur": 9, "break": 9, "chang": 9, "bug": 9, "fix": 9, "misc": 9, "from": 10, "sourc": 10, "releas": 10, "integr": 10, "verifi": 10, "pypi": 10, "jdbcoper": 11, "prerequisit": 11, "task": 11, "usag": 11, "templat": 11}, "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}})