Use Database References
Enable the use of database variables for compatibility with SchemaChange for dynamic cross-database interactions, enhancing modularity and eliminating the need to hardcode database names.
When enabled, database names in the generated SnowDT scripts (stored procedures, views, and table create scripts) are replaced with the variable text from Database Variable, so the deployment tooling can resolve database names at deploy time instead of using hardcoded literals.
When to Change This Setting
Enable it when deploying the SnowDT output with SchemaChange or similar tooling where the physical database names differ per environment.
Related Settings
| Setting | Interaction |
|---|---|
| Database Variable | The variable text substituted for database names |
| Additional Database References | Extra database names to match that are not defined as connections |
| SSDT Use Database References | The equivalent option for SSDT database projects |
Notes
- This setting is part of the Snowflake settings category.
- The default value for this setting is
N.