After copying data overnight from SQL Server to Snowflake, I wanted to recreate an SSRS report in Data Studio.
Unfortunately the copied tables all had ‘STG_’ appended to the start of their names (e.g. STG_Customers).
There is nothing like ‘Synonym’ built into Snowflake, and I really did not want to go through my SQL Query adding STG_ to every single table name.
My solution was to create Views as table aliases, as Views in Snowflake are blindingly fast.
Database Consultant 