How to make reports both Snowflake and some other DB like Redshift compatible?

[LazyUser]

I have created a lot of reports in Redshift and now the company is moving from Redshift to Snowflake. I have executed same DDLs in SF that I used in RS and SF create table and column names with upper case. Now I tried to refresh reports already powered with RS with SF (I am using ODBC connector) and I got error in M queries that tables could not be found since it was searching for column with lower case. 

I then replaced table names but after loading the tables, all my relationships have broken, visuals which were using columns were also broken, however DAX was working fine. 

Any tips to avoid this in future for other reports? 

[amitchandak]

@LazyUser , Carefully replace top part of each and every query with snowflake details. Please refer if my video on that can help

Abstract Thesis Part 51: Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0

Add a new Table using snowflake, take that and replace top part on redshift connection