Snowflake - Placeholder values - 1.8
Please consult the article Replace the placeholders in the Artifacts to learn how to replace the placeholders with the values explained below.
Placeholder values
Depending on the Generator Configuration you are using for a Snowflake Target Technology, you can replace the placeholder values with the following:
database_name
It contains the target Snowflake database name.
schema_name
It contains the target Snowflake schema name.
default_warehouse_name
It contains the target Snowflake warehouse name.
snowflake_stage_database_name
For a Stage File generator, it contains the Snowflake database name where the external stage is stored.
snowflake_stage_schema_name
For a Stage File generator, it contains the Snowflake schema name where the external stage is stored.
snowflake_stage_name
For a Stage File generator, it contains the external stage name.
snowflake_file_format_database_name
For a Stage File generator, it contains the Snowflake database name where the file format is stored.
snowflake_file_format_schema_name
For a Stage File generator, it contains the Snowflake schema name where the file format is stored.
snowflake_file_format_name
For a Stage File generator, it contains the file format name.
warehouse_name
It contains the target Snowflake warehouse name for the Load Control.
load_interval
It is the default load interval the scheduled tasks will use.
suspend_task_after_num_failures
It is the default number of failures before suspending the root task.
application_name
For logging, you can fill application name to easily identify the logs concerning your Project in Snowflake.
application_environment_name
For logging, you can fill application environment name to easily identify the logs concerning your Project in Snowflake depending on the target environment (development, integration, production...).
It is DEV by default.
You can download a replacement_config.json example here for:
- Snowflake Stage File
- Snowflake Dimensional and Mart
- This example is similar for Snowflake Stage, Dimensional, and Datamart
- Snowflake DataVault and Mart
- This example is similar for Snowflake Stage, DataVault, and Datamart