Search.setIndex({"docnames": ["_api/airflow/providers/postgres/hooks/index", "_api/airflow/providers/postgres/hooks/postgres/index", "_api/airflow/providers/postgres/index", "_api/airflow/providers/postgres/operators/index", "_api/airflow/providers/postgres/operators/postgres/index", "_api/tests/system/providers/postgres/example_postgres/index", "_api/tests/system/providers/postgres/index", "commits", "connections/postgres", "index", "installing-providers-from-sources", "operators/postgres_operator_howto_guide"], "filenames": ["_api/airflow/providers/postgres/hooks/index.rst", "_api/airflow/providers/postgres/hooks/postgres/index.rst", "_api/airflow/providers/postgres/index.rst", "_api/airflow/providers/postgres/operators/index.rst", "_api/airflow/providers/postgres/operators/postgres/index.rst", "_api/tests/system/providers/postgres/example_postgres/index.rst", "_api/tests/system/providers/postgres/index.rst", "commits.rst", "connections/postgres.rst", "index.rst", "installing-providers-from-sources.rst", "operators/postgres_operator_howto_guide.rst"], "titles": ["<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.hooks</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.hooks.postgres</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.operators</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.postgres.operators.postgres</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.postgres.example_postgres</span></code>", "<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">tests.system.providers.postgres</span></code>", "Package apache-airflow-providers-postgres", "PostgreSQL Connection", "<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-postgres</span></code>", "Installing from sources", "How-to Guide for PostgresOperator"], "terms": {"5": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "2": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "1": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "4": [0, 1, 2, 3, 4, 5, 6, 8, 10, 11], "0": [0, 1, 2, 3, 4, 5, 6, 8, 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], "i": [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], "cursortyp": 1, "sourc": [1, 4, 5, 9, 11], "postgreshook": [1, 7, 9, 11], "arg": [1, 7], "kwarg": [1, 4], "base": [1, 4, 11], "common": [1, 7, 9], "sql": [1, 4, 7, 9, 11], "dbapihook": [1, 7, 9], "interact": [1, 11], "you": [1, 8, 9, 10, 11], "can": [1, 8, 9, 10, 11], "specifi": [1, 8, 9], "ssl": [1, 8], "paramet": [1, 4, 7, 8], "extra": [1, 7, 8, 9], "field": [1, 7, 8, 9], "your": [1, 9], "connect": [1, 4, 7, 9], "sslmode": [1, 8], "requir": [1, 8, 11], "sslcert": [1, 8], "path": 1, "cert": [1, 8], "pem": [1, 8], "etc": 1, "also": [1, 10], "choos": [1, 10], "cursor": 1, "dictcursor": 1, "refer": [1, 4, 7, 8], "psycopg2": [1, 7, 9], "more": [1, 4, 7, 8, 9, 11], "detail": [1, 7, 8, 9, 10], "note": [1, 7, 8], "For": [1, 7, 8, 9, 10], "redshift": [1, 8], "us": [1, 4, 7, 8, 9, 10, 11], "keepalives_idl": [1, 8], "set": [1, 8, 11], "less": 1, "than": [1, 8], "300": 1, "second": [1, 7, 8, 9], "aw": [1, 7, 8], "iam": [1, 7, 8, 9], "authent": [1, 8], "true": [1, 4, 8], "leav": 1, "password": [1, 8], "empti": 1, "aws_default": 1, "get": [1, 7, 10, 11], "temporari": [1, 10], "token": 1, "unless": 1, "overrid": [1, 7, 9], "exampl": [1, 7, 8, 9, 10, 11], "aws_conn_id": [1, 8], "my_aws_conn": 1, "The": [1, 4, 8, 9, 10], "cluster": [1, 7, 8, 9], "identifi": [1, 7, 8, 9], "extract": 1, "from": [1, 7, 8, 9], "begin": 1, "host": [1, 8], "so": 1, "option": [1, 4, 8, 11], "It": [1, 10, 11], "howev": 1, "overridden": 1, "my_cluster_id": 1, "postgres_conn_id": [1, 4, 11], "conn": [1, 4], "id": [1, 4, 8, 10], "specif": [1, 4, 7], "databas": [1, 4, 8], "conn_name_attr": 1, "default_conn_nam": 1, "postgres_default": [1, 4, 11], "conn_typ": 1, "hook_nam": 1, "supports_autocommit": 1, "get_conn": 1, "establish": 1, "copy_expert": 1, "filenam": 1, "execut": [1, 4], "method": [1, 4, 7, 9], "necessari": 1, "copi": 1, "command": [1, 4, 7], "without": 1, "access": 1, "superus": 1, "call": [1, 11], "statement": [1, 4, 11], "input": 1, "file": [1, 4, 7, 8, 9, 10, 11], "doe": 1, "exist": [1, 9, 11], "creat": [1, 4, 10], "data": [1, 7], "load": 1, "oper": [1, 2, 7, 9], "succe": 1, "user": [1, 8, 10], "want": [1, 9, 10], "awar": 1, "when": [1, 4, 8, 9, 11], "thei": 1, "have": [1, 7, 9, 11], "check": [1, 7, 9, 10], "its": [1, 11], "themselv": 1, "get_uri": [1, 7, 9], "uri": [1, 8, 9], "return": [1, 9], "bulk_load": 1, "tabl": 1, "tmp_file": 1, "tab": 1, "delimit": 1, "bulk_dump": 1, "dump": [1, 11], "get_iam_token": 1, "awshook": [1, 7, 9], "retriev": 1, "port": 1, "If": [1, 8, 9, 10], "none": [1, 4, 7, 10], "default": [1, 4, 7, 8], "each": [1, 4], "servic": 1, "get_table_primary_kei": 1, "schema": [1, 7, 8, 9], "public": [1, 7, 9], "helper": 1, "primari": [1, 10, 11], "kei": [1, 8, 10, 11], "str": [1, 4], "name": [1, 4, 7, 8, 11], "target": 1, "column": 1, "list": [1, 4, 7, 8, 9], "type": [1, 7, 8, 9], "hook": [2, 7, 8], "postgresoper": [4, 7, 9], "autocommit": 4, "fals": [4, 11], "runtime_paramet": [4, 11], "model": 4, "baseoper": [4, 11], "code": [4, 10, 11], "union": 4, "iter": 4, "singl": 4, "string": [4, 7], "templat": [4, 7, 9], "ar": [4, 8, 9, 10, 11], "recogn": 4, "end": 4, "bool": 4, "automat": [4, 9], "commit": [4, 7], "valu": [4, 8, 11], "map": 4, "render": [4, 7, 9], "queri": [4, 11], "which": [4, 7, 8, 9, 11], "overwrit": 4, "defin": [4, 11], "one": [4, 10], "template_field": [4, 7], "sequenc": [4, 7], "template_fields_render": [4, 7, 9], "template_ext": 4, "ui_color": 4, "eded": 4, "context": [4, 7], "main": [4, 9, 10], "deriv": 4, "same": 4, "dictionari": [4, 8], "jinja": 4, "get_template_context": 4, "env_id": [5, 11], "dag_id": [5, 11], "postgres_operator_dag": [5, 11], "create_pet_t": [5, 11], "test_run": 5, "example_postgr": [6, 11], "postgresql": [7, 9, 11], "chang": 7, "version": [7, 9, 10], "high": 7, "level": 7, "changelog": 7, "see": [7, 9], "inform": 7, "includ": 7, "latest": 7, "2022": 7, "09": 7, "05": [7, 11], "subject": 7, "54e7d20176": 7, "bump": [7, 9], "dep": [7, 9, 10], "fix": 7, "issu": [7, 9], "sqltablecheckoper": [7, 9], "26143": [7, 9], "14d56a5a9": 7, "08": [7, 11], "23": [7, 11], "non": 7, "binari": [7, 10], "25710": 7, "ca9229b6f": 7, "18": 7, "add": [7, 9], "lower": 7, "bound": 7, "25789": 7, "10": [7, 9], "e5ac6c7cfb": 7, "prepar": 7, "doc": 7, "new": [7, 9], "releas": [7, 9], "august": 7, "25618": 7, "4eb0a410bb": 7, "02": 7, "onli": [7, 9], "": [7, 8, 9, 10, 11], "dure": [7, 9, 11], "author": [7, 8, 9], "25424": [7, 9], "df00436569": 7, "07": [7, 11], "22": 7, "unifi": [7, 9], "run": [7, 9, 10], "23971": [7, 9], "13": 7, "d2459a241b": 7, "document": [7, 8, 9], "juli": 7, "25030": 7, "46bbfdade0": 7, "move": [7, 9], "all": [7, 8, 9, 11], "class": [7, 9, 11], "24836": [7, 9], "0de31bd73a": 7, "06": [7, 11], "29": 7, "depend": [7, 11], "insid": [7, 11], "folder": [7, 10, 11], "24672": 7, "510a6bab45": 7, "28": 7, "remov": [7, 9, 10], "yaml": 7, "24702": 7, "dcdcf3a2b8": 7, "updat": [7, 9], "rc2": 7, "mai": 7, "24307": 7, "717a7588bc": 7, "descript": 7, "doubl": 7, "min": 7, "24292": 7, "aeabe994b3": 7, "24231": 7, "027b707d21": 7, "explanatori": 7, "contributor": 7, "about": [7, 10], "24229": 7, "c60bb9edc0": 7, "03": 7, "migrat": [7, 9], "dag": [7, 9], "design": 7, "22458": 7, "24148": 7, "d7dbfb7e26": 7, "bugfix": 7, "22383": 7, "0ec56775df": 7, "abil": [7, 9], "pass": [7, 8, 9], "config": [7, 9], "param": [7, 9, 11], "21551": [7, 9], "14": 7, "16adc035b1": 7, "classifi": [7, 9], "march": 7, "22226": 7, "f5b96315fe": 7, "feb": 7, "22056": 7, "59c450ee54": 7, "25": 7, "make": [7, 9, 11], "21764": [7, 9], "d94fa37830": 7, "januari": 7, "delai": 7, "21439": 7, "8f81b9a01c": 7, "condit": [7, 9], "lexer": [7, 9], "21403": [7, 9], "6c3a67d4fc": 7, "2021": [7, 10], "21257": 7, "39e395f981": 7, "04": 7, "21237": [7, 9], "e07139ab73": 7, "01": [7, 11], "30": 7, "replac": [7, 8, 9], "usag": [7, 9], "21205": [7, 9], "602abe8394": 7, "20": 7, "line": 7, "now": [7, 11], "sphinx": 7, "autoapi": 7, "support": [7, 8, 9], "typehint": 7, "20951": 7, "f77417eb0d": 7, "12": [7, 10, 11], "31": [7, 11], "k8": 7, "pypi": [7, 9], "compat": 7, "20614": 7, "97496ba2b4": 7, "decemb": 7, "20523": 7, "83f8e178ba": 7, "even": 7, "ext": 7, "20608": 7, "c84b435cc9": 7, "mypi": 7, "error": 7, "20600": 7, "d56e7b56bb": 7, "friendli": 7, "20571": 7, "a0821235fb": 7, "everywher": 7, "20565": 7, "dad2f8103b": 7, "15": 7, "20190": 7, "11": [7, 10, 11], "853576d901": 7, "novemb": 7, "19882": 7, "c97a2e8ab8": 7, "26": 7, "19489": [7, 9], "client_encod": [7, 8, 9], "19827": [7, 9], "83b51e5306": 7, "amazon": [7, 8, 9], "deprec": [7, 9], "try": [7, 9], "19815": [7, 9], "d58df468c8": 7, "24": 7, "revert": 7, "adjust": 7, "built": 7, "base_aw": 7, "avoid": [7, 9], "warn": [7, 10], "19725": 7, "19791": 7, "4be04143a5": 7, "355dec8fea": 7, "17": 7, "misc": 7, "typo": 7, "languag": 7, "improv": 7, "19599": 7, "d9567eb106": 7, "octob": 7, "19321": 7, "86a2a19ad2": 7, "f": 7, "18855": 7, "840ea3efb9": 7, "septemb": 7, "18613": 7, "ef037e7021": 7, "static": 7, "start_dat": [7, 11], "cleanup": 7, "18597": 7, "778be7993d": 7, "18236": [7, 9], "81ebd78db4": 7, "ad": [7, 9], "upsert": [7, 9], "s3toredshift": [7, 9], "18027": [7, 9], "0a68588479": 7, "17890": 7, "be75dcd39c": 7, "meta": 7, "76ed2a49c6": 7, "19": 7, "import": [7, 9, 10], "lazili": 7, "individu": 7, "manag": [7, 10], "17682": 7, "04b6559f8a": 7, "privat": [7, 9], "17423": [7, 9], "bcf719bfb4": 7, "refactor": [7, 11], "annot": 7, "17331": 7, "e0a41971a1": 7, "27": 7, "log": 7, "17214": 7, "87f408b1e7": 7, "17116": 7, "0dbd0f420c": 7, "default_arg": 7, "pattern": 7, "miscellan": 7, "16872": 7, "d02ded65ea": 7, "wrongli": 7, "escap": 7, "charact": [7, 8], "17020": 7, "b916b75079": 7, "17015": 7, "866a601b76": 7, "pylint": 7, "our": [7, 11], "toolchain": 7, "16682": 7, "3ee916e9e1": 7, "instanc": [7, 9], "attribut": [7, 9, 11], "16521": [7, 9], "bbc627a3da": 7, "16501": 7, "cbf8001d76": 7, "16": 7, "synchron": 7, "after": [7, 8], "buggfix": 7, "16464": 7, "1fba5402bb": 7, "june": 7, "16405": 7, "d99afc3c21": 7, "postgres_hook_aws_conn_id": [7, 9], "16100": [7, 9], "9c94b72d44": 7, "16294": 7, "9c8391a13f": 7, "spell": 7, "15699": 7, "37681bca00": 7, "auto": [7, 9], "appli": [7, 9], "apply_default": [7, 9], "decor": [7, 9], "15667": [7, 9], "fc845caf78": 7, "deepcopi": [7, 9], "mutat": [7, 9], "obj": [7, 9], "15412": [7, 9], "807ad32ce5": 7, "pip": [7, 9, 10], "21": 7, "15576": 7, "5b2fe0e740": 7, "popular": 7, "15393": 7, "70c74c1f68": 7, "do": [7, 9, 10], "forward": [7, 9], "15360": [7, 9], "68e4c4dcb0": 7, "backport": 7, "14886": 7, "6e6526a0f6": 7, "broken": 7, "14734": 7, "88bdcfa0df": 7, "wave": 7, "14013": 7, "ac2f72c98d": 7, "implement": [7, 11], "tool": 7, "13767": 7, "a9ac2b040b": 7, "switch": 7, "flynt": 7, "13732": 7, "3fd5ef3555": 7, "miss": 7, "logo": 7, "integr": 7, "13717": 7, "9c75ea3c14": 7, "how": [7, 10], "To": [7, 10, 11], "guid": [7, 10], "13281": 7, "295d66f914": 7, "2020": [7, 11], "grammar": 7, "13380": 7, "6cf76d7ac0": 7, "upgrad": [7, 9], "13148": 7, "32971a1a2d": 7, "12955": 7, "b40dffa085": 7, "renam": 7, "rema": 7, "modul": 7, "match": [7, 10], "aip": 7, "12917": 7, "9b39f24780": 7, "dynam": [7, 11], "form": 7, "per": 7, "12558": 7, "2037303eef": 7, "discoveri": 7, "12466": 7, "c34ef853c8": 7, "separ": 7, "out": [7, 8, 11], "build": [7, 10], "12444": 7, "0080354502": 7, "readm": [7, 9], "0b2": 7, "batch": 7, "12449": 7, "ae7cb4a1e2": 7, "wrong": 7, "hash": 7, "12390": 7, "6889a333cf": 7, "ref": 7, "12366": 7, "7825e8f590": 7, "instal": 7, "12304": 7, "85a18e13d9": 7, "point": 7, "project": 7, "page": [7, 10], "cross": 7, "12212": 7, "59eb5de78c": 7, "up": [7, 11], "come": 7, "0beta1": 7, "12206": 7, "b2a28d1590": 7, "script": [7, 10], "dev": 7, "12082": 7, "4e8f9cc8d0": 7, "enabl": [7, 8], "black": 7, "python": [7, 8, 9, 10], "formmatt": 7, "9550": 7, "8c42cf1b00": 7, "pyupgrad": 7, "6": 7, "11447": 7, "5a439e84eb": 7, "2a1": 7, "11855": 7, "872b1566a1": 7, "gener": 7, "setup": 7, "11826": 7, "349b0811c3": 7, "d200": 7, "pydocstyl": 7, "11688": 7, "a4dc11fae6": 7, "paramat": 7, "11019": 7, "3cddc11821": 7, "template_fields_rend": 7, "simplehttpoper": 7, "11555": 7, "16e7129719": 7, "11487": 7, "d305876bee": 7, "redund": 7, "dict": 7, "11448": 7, "0a0e1af800": 7, "markdown": 7, "link": [7, 10], "toc": 7, "11249": 7, "ca4238eb4d": 7, "month": 7, "11242": 7, "5220e4c384": 7, "11238": 7, "eff1525d12": 7, "increas": 7, "coverag": 7, "10864": 7, "9549274d11": 7, "8b1": 7, "10818": 7, "fdd9b6f65b": 7, "10543": 7, "3696c34c28": 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, 8], "fresh": 7, "9408": 7, "12af6a0800": 7, "final": [7, 11], "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, "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, "a28c66f23d": 7, "4734": 7, "function": 7, "insert_row": 7, "8625": 7, "68d1714f29": 7, "6822": 7, "should": [7, 8, 9, 10, 11], "cach": 7, "boto3": 7, "client": [7, 8], "7541": 7, "4bde99f132": 7, "7802": 7, "9cbd7de6d1": 7, "6792": 7, "_oper": 7, "_hook": 7, "_sensor": 7, "test": [7, 11], "7412": 7, "97a429f9d0": 7, "6714": 7, "magic": 7, "comment": 7, "utf": 7, "8": [7, 9], "7338": 7, "82c0e5aff6": 7, "6655": 7, "7271": 7, "059eda05f8": 7, "6610": 7, "softwar": [7, 10], "7231": 7, "postgr": [8, 10], "provid": [8, 10, 11], "login": 8, "json": 8, "follow": [8, 10], "standard": 8, "determin": 8, "whether": 8, "what": 8, "prioriti": 8, "secur": 8, "tcp": 8, "ip": 8, "negoti": 8, "server": [8, 10], "There": [8, 10], "six": 8, "mode": 8, "disabl": 8, "allow": 8, "prefer": 8, "verifi": [8, 9], "ca": 8, "full": 8, "certif": [8, 10], "sslkei": 8, "sslrootcert": 8, "contain": [8, 10, 11], "sslcrl": 8, "revoc": 8, "crl": 8, "application_nam": 8, "control": [8, 11], "inact": 8, "send": 8, "keepal": 8, "messag": 8, "encod": 8, "found": 8, "tmp": 8, "sslca": 8, "addit": 8, "rd": 8, "aurora": 8, "via": [8, 9, 10], "otherwis": [8, 9], "uniqu": 8, "request": [8, 11], "credenti": 8, "case": 8, "sensit": 8, "hostnam": 8, "aws_awesome_rds_conn": 8, "aws_awesome_redshift_conn": 8, "awesom": 8, "airflow_conn_": 8, "conn_id": 8, "variabl": 8, "syntax": 8, "db": [8, 9], "where": [8, 9, 11], "compon": 8, "url": 8, "export": 8, "airflow_conn_postgres_default": 8, "postgres_us": 8, "xxxxxxxxxxxx": 8, "5432": 8, "postgresdb": 8, "2ftmp": 8, "2fclient": 8, "2fserver": 8, "api": 9, "repositori": 9, "top": [9, 10], "below": [9, 10, 11], "minimum": 9, "those": [9, 10], "might": 9, "need": 9, "order": 9, "them": 9, "checksum": [9, 10], "site": 9, "sdist": [9, 10], "asc": [9, 10], "sha512": [9, 10], "wheel": 9, "avail": [9, 10, 11], "explain": 9, "polici": 9, "http": [9, 10], "github": 9, "com": [9, 10], "blob": 9, "md": 9, "mistakenli": 9, "install_requir": 9, "22382": 9, "trove": [9, 11], "framework": 9, "instead": [9, 11], "prefix": 9, "sqlalchemi": 9, "ani": [9, 10], "reflect": 9, "optimis": 9, "due": 9, "first": 9, "least": 9, "manual": 9, "complet": 9, "howto": 9, "initi": 9, "describ": 10, "download": 10, "apach": [10, 11], "airflow": [10, 11], "offici": 10, "most": 10, "differ": [10, 11], "select": [10, 11], "drop": 10, "down": [10, 11], "left": 10, "whl": 10, "origin": 10, "foundat": 10, "abov": 10, "pgp": 10, "essenti": [10, 11], "sha": 10, "gpg": 10, "pleas": 10, "well": 10, "relev": 10, "distribut": 10, "recommend": 10, "directori": [10, 11], "mirror": 10, "pgpk": 10, "ka": 10, "pgpv": 10, "tar": 10, "gz": 10, "made": [10, 11], "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, "indic": 10, "belong": 10, "owner": [10, 11], "fingerprint": 10, "cde1": 10, "5c6e": 10, "4d3a": 10, "8ec4": 10, "ecf4": 10, "ba4b": 10, "6674": 10, "e08a": 10, "d7de": 10, "406f": 10, "worri": 10, "self": 10, "sign": 10, "why": 10, "By": 10, "previou": 10, "step": 10, "know": 10, "valid": 10, "alreadi": [10, 11], "sum": 10, "shasum": 10, "512": 10, "diff": 10, "local": 10, "bin": 10, "bash": 10, "package_vers": 10, "package_nam": 10, "provider_download_dir": 10, "mktemp": 10, "d": 10, "dest": 10, "curl": 10, "apache_airflow_providers_postgr": 10, "py3": 10, "l": 10, "o": [10, 11], "echo": 10, "la": 10, "onc": [10, 11], "instruct": 10, "chapter": 10, "ha": 11, "robust": 11, "variou": 11, "task": 11, "workflow": 11, "graph": 11, "direct": 11, "acycl": 11, "node": 11, "edg": 11, "A": 11, "unit": 11, "work": 11, "pipelin": 11, "purpos": 11, "involv": 11, "In": 11, "resid": 11, "under": 11, "hood": 11, "deleg": 11, "heavi": 11, "lift": 11, "carri": 11, "two": 11, "These": 11, "eventu": 11, "fed": 11, "object": 11, "directli": 11, "snippet": 11, "system": 11, "py": 11, "populate_pet_t": 11, "get_all_pet": 11, "get_birth_d": 11, "instanti": 11, "environ": 11, "system_tests_env_id": 11, "datetim": 11, "schedul": 11, "catchup": 11, "task_id": 11, "IF": 11, "NOT": 11, "pet": 11, "pet_id": 11, "serial": 11, "varchar": 11, "null": 11, "pet_typ": 11, "birth_dat": 11, "date": 11, "isn": 11, "t": 11, "quit": 11, "appeal": 11, "maintain": 11, "pain": 11, "somewher": 11, "road": 11, "prevent": 11, "offer": 11, "eleg": 11, "solut": 11, "simpli": 11, "put": 11, "pet_schema": 11, "like": 11, "let": 11, "sai": 11, "we": 11, "popul": 11, "INTO": 11, "max": 11, "dog": 11, "2018": 11, "jane": 11, "susi": 11, "cat": 11, "2019": 11, "phil": 11, "lester": 11, "hamster": 11, "lili": 11, "quinci": 11, "parrot": 11, "2013": 11, "ann": 11, "simpl": 11, "possibl": 11, "inject": 11, "runtim": 11, "virtu": 11, "inherit": 11, "both": 11, "mani": 11, "interest": 11, "wai": 11, "find": 11, "between": 11, "symmetr": 11, "begin_d": 11, "AND": 11, "end_dat": 11, "tidi": 11, "thing": 11, "And": 11, "time": 11, "free": 11, "parent": 11, "statement_timeout": 11, "3000m": 11, "everyth": 11, "togeth": 11, "look": 11, "explor": 11, "postgreoper": 11, "quickli": 11, "highlight": 11, "takeawai": 11, "packag": 11, "best": 11, "practic": 11, "subdirectori": 11, "store": 11}, "objects": {"airflow.providers": [[2, 0, 0, "-", "postgres"]], "airflow.providers.postgres": [[0, 0, 0, "-", "hooks"], [3, 0, 0, "-", "operators"]], "airflow.providers.postgres.hooks": [[1, 0, 0, "-", "postgres"]], "airflow.providers.postgres.hooks.postgres": [[1, 1, 1, "", "CursorType"], [1, 2, 1, "", "PostgresHook"]], "airflow.providers.postgres.hooks.postgres.PostgresHook": [[1, 3, 1, "", "bulk_dump"], [1, 3, 1, "", "bulk_load"], [1, 4, 1, "", "conn_name_attr"], [1, 4, 1, "", "conn_type"], [1, 3, 1, "", "copy_expert"], [1, 4, 1, "", "default_conn_name"], [1, 3, 1, "", "get_conn"], [1, 3, 1, "", "get_iam_token"], [1, 3, 1, "", "get_table_primary_key"], [1, 3, 1, "", "get_uri"], [1, 4, 1, "", "hook_name"], [1, 4, 1, "", "supports_autocommit"]], "airflow.providers.postgres.operators": [[4, 0, 0, "-", "postgres"]], "airflow.providers.postgres.operators.postgres": [[4, 2, 1, "", "PostgresOperator"]], "airflow.providers.postgres.operators.postgres.PostgresOperator": [[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"]], "tests.system.providers": [[6, 0, 0, "-", "postgres"]], "tests.system.providers.postgres": [[5, 0, 0, "-", "example_postgres"]], "tests.system.providers.postgres.example_postgres": [[5, 1, 1, "", "DAG_ID"], [5, 1, 1, "", "ENV_ID"], [5, 1, 1, "", "create_pet_table"], [5, 1, 1, "", "test_run"]]}, "objtypes": {"0": "py:module", "1": "py:data", "2": "py:class", "3": "py:method", "4": "py:attribute"}, "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"]}, "titleterms": {"airflow": [0, 1, 2, 3, 4, 7, 9], "provid": [0, 1, 2, 3, 4, 5, 6, 7, 9], "postgr": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11], "hook": [0, 1], "submodul": [0, 3, 6], "modul": [1, 4, 5], "content": [1, 4, 5, 9], "class": [1, 4], "attribut": 1, "subpackag": 2, "oper": [3, 4, 11], "test": [5, 6], "system": [5, 6], "example_postgr": 5, "packag": [7, 9, 10], "apach": [7, 9], "5": [7, 9], "2": [7, 9], "1": [7, 9], "0": [7, 9], "4": [7, 9], "3": [7, 9], "postgresql": 8, "connect": 8, "configur": [8, 11], "guid": [9, 11], "refer": 9, "resourc": 9, "commit": 9, "instal": [9, 10], "requir": 9, "cross": 9, "depend": 9, "download": 9, "offici": 9, "changelog": 9, "bug": 9, "fix": 9, "featur": 9, "break": 9, "chang": 9, "misc": 9, "from": [10, 11], "sourc": 10, "releas": 10, "integr": 10, "verifi": 10, "pypi": 10, "how": 11, "postgresoper": 11, "introduct": 11, "common": 11, "databas": 11, "creat": 11, "tabl": 11, "insert": 11, "data": 11, "fetch": 11, "record": 11, "your": 11, "pass": 11, "paramet": 11, "server": 11, "The": 11, "complet": 11, "dag": 11, "conclus": 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}})