Options
Confussion where objects have the same name
Niall
Posts: 36 Bronze 1
We have a large Data Warehouse where there are stages to bringing the data in and we used schemas to designate the layer.
So for instance there is a Staging table in the schema Staging_something, as well as a view of the current data in Current_something, as well as another view that shows the history in the schema History_something. To keep life simple(ish) the tables and view have the same name, ie.
Staging_something.Account
Current_something.Account
History_something.Account
As it is a data warehosue with lots of feed systems we have a moderate amount of tables, views, etc, circa 3k objects.
SQL Prompt does not seem very happy with this and will when working on a query for History_something.Account 'pop up' with columns from Current_something.Account.
This appears to have been introduced recently as a bug and does greatly devalue the use of the tool for us.
So for instance there is a Staging table in the schema Staging_something, as well as a view of the current data in Current_something, as well as another view that shows the history in the schema History_something. To keep life simple(ish) the tables and view have the same name, ie.
Staging_something.Account
Current_something.Account
History_something.Account
As it is a data warehosue with lots of feed systems we have a moderate amount of tables, views, etc, circa 3k objects.
SQL Prompt does not seem very happy with this and will when working on a query for History_something.Account 'pop up' with columns from Current_something.Account.
This appears to have been introduced recently as a bug and does greatly devalue the use of the tool for us.
Comments
Red Gate Technical Support Engineer