Import entire schemes without specifying individual table
I really liked how aws dms operated, you pointed it at a schema on your source, told it the target schema in your destination, and had a wildcard supporting whitelist/blacklist feature for tables. Something like that in the future would be much easier for me to manage than having to tweak my automated script that’s bulk loading all of my tables into flows. And it would pick up new tables automatically
Comments: 1
-
02 Oct, '19
Olena Sherbinin AdminAny - https://support.etlworks.com/hc/en-us/articles/360036651013-How-do-I-move-tables-matching-a-wildcard-name-from-one-schema-or-database-to-another
Snowflake - https://support.etlworks.com/hc/en-us/articles/360014726073-Loading-data-in-Snowflake#Loadingmultipletablesbyawildcardname
Redshift - https://support.etlworks.com/hc/en-us/articles/360014630714-Loading-data-in-Amazon-Redshift#Loadingmultipletablesbyawildcardname