`tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql`¶

Example Airflow DAG for Google BigQuery service.

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.bigquery.example_bigquery_to_mssql.ENV_ID[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.PROJECT_ID[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.DAG_ID = 'bigquery_to_mssql'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.REGION = 'us-west2'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.ZONE[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.NETWORK = 'default'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.CONNECTION_ID[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.CONNECTION_TYPE = 'mssql'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.BIGQUERY_DATASET_NAME[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.BIGQUERY_TABLE = 'table_42'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.INSERT_ROWS_QUERY[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.DB_PORT = 1433[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.DB_USER_NAME = 'sa'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.DB_USER_PASSWORD = '5FHq4fSZ85kK6g0n'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.SETUP_MSSQL_COMMAND[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.SQL_TABLE = 'test_table'[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.SQL_CREATE_TABLE[source]¶

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

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.GCE_INSTANCE_NAME[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.GCE_INSTANCE_BODY[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.FIREWALL_RULE_NAME[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.CREATE_FIREWALL_RULE_COMMAND[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.DELETE_FIREWALL_RULE_COMMAND[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.DELETE_PERSISTENT_DISK_COMMAND[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.log[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.create_bigquery_dataset[source]¶

tests.system.providers.google.cloud.bigquery.example_bigquery_to_mssql.test_run[source]¶

Was this entry helpful?