tests.system.providers.google.cloud.transfers.example_postgres_to_gcs

Example DAG using PostgresSQLToGCSOperator.

This DAG relies on the following OS environment variables

  • AIRFLOW__API__GOOGLE_KEY_PATH - Path to service account key file. Note, you can skip this variable if you run this DAG in a Composer environment.

Module Contents

tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.DAG_ID = 'postgres_to_gcs'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.ENV_ID[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.PROJECT_ID[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.REGION = 'europe-west2'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.ZONE[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.NETWORK = 'default'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.CONNECTION_ID[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.CONNECTION_TYPE = 'postgres'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.BUCKET_NAME[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.FILE_NAME = 'result.json'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.DB_NAME = 'testdb'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.DB_PORT = 5432[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.DB_USER_NAME = 'root'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.DB_USER_PASSWORD = 'demo_password'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.SETUP_POSTGRES_COMMAND[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.SQL_TABLE = 'test_table'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.SQL_CREATE[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.SQL_INSERT[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.SQL_SELECT[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.GCE_MACHINE_TYPE = 'n1-standard-1'[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.GCE_INSTANCE_NAME[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.GCE_INSTANCE_BODY[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.FIREWALL_RULE_NAME[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.CREATE_FIREWALL_RULE_COMMAND[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.DELETE_FIREWALL_RULE_COMMAND[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.DELETE_PERSISTENT_DISK_COMMAND[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.log[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.create_gce_instance[source]
tests.system.providers.google.cloud.transfers.example_postgres_to_gcs.test_run[source]

Was this entry helpful?