tests.system.amazon.aws.example_sql_to_s3¶

Attributes¶

`DAG_ID`
`SECURITY_GROUP_KEY`
`CLUSTER_SUBNET_GROUP_KEY`
`sys_test_context_task`
`DB_LOGIN`
`DB_PASS`
`DB_NAME`
`REDSHIFT_TABLE`
`SQL_QUERY`
`SQL_CREATE_TABLE`
`SQL_INSERT_DATA`
`test_context`
`test_run`

Functions¶

create_connection(conn_id_name, cluster_id)

Module Contents¶

tests.system.amazon.aws.example_sql_to_s3.DAG_ID = 'example_sql_to_s3'[source]¶

tests.system.amazon.aws.example_sql_to_s3.SECURITY_GROUP_KEY = 'SECURITY_GROUP'[source]¶

tests.system.amazon.aws.example_sql_to_s3.CLUSTER_SUBNET_GROUP_KEY = 'CLUSTER_SUBNET_GROUP'[source]¶

tests.system.amazon.aws.example_sql_to_s3.sys_test_context_task[source]¶

tests.system.amazon.aws.example_sql_to_s3.DB_LOGIN = 'adminuser'[source]¶

tests.system.amazon.aws.example_sql_to_s3.DB_PASS = 'MyAmazonPassword1'[source]¶

tests.system.amazon.aws.example_sql_to_s3.DB_NAME = 'dev'[source]¶

tests.system.amazon.aws.example_sql_to_s3.REDSHIFT_TABLE = 'test_table'[source]¶

tests.system.amazon.aws.example_sql_to_s3.SQL_QUERY = 'SELECT * FROM test_table'[source]¶

tests.system.amazon.aws.example_sql_to_s3.SQL_CREATE_TABLE = Multiline-String[source]¶

Show Value

"""
    CREATE TABLE IF NOT EXISTS test_table (
    fruit_id INTEGER,
    name VARCHAR NOT NULL,
    color VARCHAR NOT NULL
    );
"""

tests.system.amazon.aws.example_sql_to_s3.SQL_INSERT_DATA = "INSERT INTO test_table VALUES ( 1, 'Banana', 'Yellow');"[source]¶

tests.system.amazon.aws.example_sql_to_s3.create_connection(conn_id_name, cluster_id)[source]¶

tests.system.amazon.aws.example_sql_to_s3.test_context = None[source]¶

tests.system.amazon.aws.example_sql_to_s3.test_run[source]¶

Was this entry helpful?