`tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets`¶

Example DAG using SQLToGoogleSheetsOperator.

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.sql_to_sheets.example_sql_to_sheets.DAG_ID = 'sql_to_sheets'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.ENV_ID[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.PROJECT_ID[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.REGION = 'europe-west2'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.ZONE[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.NETWORK = 'default'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.CONNECTION_ID[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.CONNECTION_TYPE = 'postgres'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.BUCKET_NAME[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.FILE_NAME = 'result.json'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.DB_NAME = 'testdb'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.DB_PORT = 5432[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.DB_USER_NAME = 'root'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.DB_USER_PASSWORD = 'demo_password'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.SETUP_POSTGRES_COMMAND[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.SQL_TABLE = 'test_table'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.SQL_CREATE[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.SQL_INSERT[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.SQL_SELECT[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.GCE_MACHINE_TYPE = 'n1-standard-1'[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.GCE_INSTANCE_NAME[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.GCE_INSTANCE_BODY[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.FIREWALL_RULE_NAME[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.CREATE_FIREWALL_RULE_COMMAND[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.DELETE_FIREWALL_RULE_COMMAND[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.DELETE_PERSISTENT_DISK_COMMAND[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.SHEETS_CONNECTION_ID[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.SPREADSHEET[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.log[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.create_gce_instance[source]¶

tests.system.providers.google.cloud.sql_to_sheets.example_sql_to_sheets.test_run[source]¶

Was this entry helpful?