| :py:mod:`tests.system.providers.snowflake.example_snowflake` |
| ============================================================ |
| |
| .. py:module:: tests.system.providers.snowflake.example_snowflake |
| |
| .. autoapi-nested-parse:: |
| |
| Example use of Snowflake related operators. |
| |
| |
| |
| Module Contents |
| --------------- |
| |
| .. py:data:: SNOWFLAKE_CONN_ID |
| :annotation: = my_snowflake_conn |
| |
| |
| |
| .. py:data:: SLACK_CONN_ID |
| :annotation: = my_slack_conn |
| |
| |
| |
| .. py:data:: SNOWFLAKE_SCHEMA |
| :annotation: = schema_name |
| |
| |
| |
| .. py:data:: SNOWFLAKE_STAGE |
| :annotation: = stage_name |
| |
| |
| |
| .. py:data:: SNOWFLAKE_WAREHOUSE |
| :annotation: = warehouse_name |
| |
| |
| |
| .. py:data:: SNOWFLAKE_DATABASE |
| :annotation: = database_name |
| |
| |
| |
| .. py:data:: SNOWFLAKE_ROLE |
| :annotation: = role_name |
| |
| |
| |
| .. py:data:: SNOWFLAKE_SAMPLE_TABLE |
| :annotation: = sample_table |
| |
| |
| |
| .. py:data:: S3_FILE_PATH |
| :annotation: = </path/to/file/sample_file.csv |
| |
| |
| |
| .. py:data:: CREATE_TABLE_SQL_STRING |
| |
| |
| |
| |
| .. py:data:: SQL_INSERT_STATEMENT |
| |
| |
| |
| |
| .. py:data:: SQL_LIST |
| |
| |
| |
| |
| .. py:data:: SQL_MULTIPLE_STMTS |
| |
| |
| |
| |
| .. py:data:: SNOWFLAKE_SLACK_SQL |
| |
| |
| |
| |
| .. py:data:: SNOWFLAKE_SLACK_MESSAGE |
| :annotation: = Multiline-String |
| |
| .. raw:: html |
| |
| <details><summary>Show Value</summary> |
| |
| .. code-block:: text |
| :linenos: |
| |
| Results in an ASCII table: |
| ```{{ results_df | tabulate(tablefmt='pretty', headers='keys') }}``` |
| |
| .. raw:: html |
| |
| </details> |
| |
| |
| |
| .. py:data:: ENV_ID |
| |
| |
| |
| |
| .. py:data:: DAG_ID |
| :annotation: = example_snowflake |
| |
| |
| |
| .. py:data:: snowflake_op_sql_str |
| |
| |
| |
| |
| .. py:data:: test_run |
| |
| |
| |
| |