Currently, when using Copy Job to transfer Snowflake data into MS Fabric Lakehouse, we can use the variable library to parameterize the Snowflake connection but cannot parameterize the target Snowflake database. This issue arises when switching the Snowflake source system between DEV and PROD environments using the variable library, as these environments may have different database names.
Suggestion: Add this as a parameter in the Copy Job using a variable library to swap the database based on environments OR add a parameter to the Snowflake connection for the database (currently only includes the "warehouse" parameter).
No CommentsBe the first to comment
