Skip to main content

Use Database References

Enable the use of database variables for compatability with SchemaChange for dynamic cross-database interactions, enhancing modularity and eliminating the need to hardcode database names. When set to Y, BimlFlex generates database variable references (using the value from SnowflakeDatabaseVariable) in DDL scripts instead of literal database names, enabling cross-database references where staging and target tables reside in separate Snowflake databases. Use this setting when your architecture requires objects to reference tables across database boundaries at runtime.

Notes:

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is N.
  • Requires SnowflakeDatabaseVariable to be configured with the variable name used in generated DDL scripts.