Snowflake - Placeholder values - 1.10
Please consult the article Replace the placeholders in the Artifacts to learn how to replace the placeholders with the values described 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 used by scheduled tasks.
suspend_task_after_num_failures
It is the default number of failures before suspending the root task.
application_name
For logging, you can set the application name to easily identify logs related to your Project in Snowflake.
application_environment_name
For logging, you can set the 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 Data Store
- 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