Forum Discussion
Add more tables from same datasource
you can do the following:
1) duplicate one of existing tables (right click on the query, press Duplicate)
2) in the View ribbon enable Query Settings
3) it will open a pane on the left - you can then go through the steps displayed there and navigate to a different table
In general with databases I would recommend to have a single connection query (basically just the Source step), that's not loaded to the model (1), and all the other queries reference that connection query and navigate to specific tables (2)
this way when you have to e.g. switch from Prod to QA you just need to change the 1 connection query, rather than all of them
you can do the following:
1) duplicate one of existing tables (right click on the query, press Duplicate)
2) in the View ribbon enable Query Settings
3) it will open a pane on the left - you can then go through the steps displayed there and navigate to a different table
In general with databases I would recommend to have a single connection query (basically just the Source step), that's not loaded to the model (1), and all the other queries reference that connection query and navigate to specific tables (2)
this way when you have to e.g. switch from Prod to QA you just need to change the 1 connection query, rather than all of them