Summary:
After duplicating a database instance, a user is unable to see any new tables created in the Warehouse Catalog for the new database instance. No new tables are returned.
Steps to Reproduce:
1) Modify the read SQL within the warehouse catalog for a database instance.
2) Duplicate the existing database instance.
3) Create new tables in the data warehouse.
4) Open Warehouse Catalog to view new tables in the duplicated database instance.
5) New tables are not displayed.
Cause:
Custom read SQL is not copied when duplicating a database instance. Read SQL is part of the catalog object for that database instance which is not copied while copying the database instance object itself.
Action:
Ensure custom read SQL is re-entered for the new database instance within the Warehouse Catalog.
