Using SMC or DIS is best practise.   But you need to find a way to  migrate 800+ tables in a single library from one DBMS to new DBMS. updating them individually is not an option. So the best option was to update the library.   I managed to change the server and other relevant properties of the library using SAS metadata functions.   But the solution I opted  involves no programmatic metadata manipulation of the library but uppercasing the physicalName/Name of all table which is an unfortunate requirement of SNOWFLAKE       Solution we used:   Delete the exiting impala Library (say with the libref 'implib')  in the target environment (say Test) under which all the tables are registered. create a new SNOWFLAKE library with the same libref 'implib' in the target environment (TEST)  Export all the table from source environment (Dev) to Test.  SAS metadata engine is smart enough to  pick up the target library(newly created Snowflake library) with the same name 'implib'.   Then programmatically uppercase (which is required for SNOWFLAKE) the PhysicalName/Name of all tables using metadata_setattr() function. Finally update metadata of tables selecting them all and updating manually (or programmatically if preferred). ... View more