Sample Header Ad - 728x90

Snowflake DB Clone?

1 vote
1 answer
129 views
So this may be confusing but just looking to see if anyone has any insight on how to maybe do this in a simpler fashion. So our company utilizes Fivetran for data transport, Snowflake for warehousing and Tableau for BI. Unfortunately, we weren't able to get table or column descriptions from our On-prem into Snowflake; so all of our columns have system names (like FFDITM rather than Item_Number for instance). This obviously was not going to work so I created a new "Transformed" DB and manually added all columns with updated names. I am now in the process of creating streams to update the transformed DB on a daily basis but am running into many problems. I've done a bit of research and I do see that Snowflake does have a Cloning option for cloning our schemas and tables or even our full DB. If this is the case, can I clone our production DB once, then updated schema, table, and column names, and then finally set up streams to update it? That way its not so cumbersome? I attempted to manually do this all manually but it seems there are automated work arounds which will also not eat at our storage.
Asked by AKBirite (11 rep)
Dec 6, 2024, 01:30 AM
Last activity: Dec 7, 2024, 10:14 PM