Forum Discussion
Connection Only or Load as Table and queries
That's correct. Once you are all loaded and the editor is closed, it's only the Connection Queries that cannot be refreshed.
--Nate
It's does refresh, but only when you refresh the table that loads from the connection file, and only for what is needed for that file. If you have a connection file with no filters, and then three files that reference the connection file but then filter by region, when your files are loaded, and then you refresh only the West Region, the connection file (assuming query folding) query plan will filter to the West Region, and never bother with bringing in the other regions. Or if your West query only needs two columns, the connection query will select only those two columns.
Try adding an unfiltered connection only file, then add some reference files that remove columns, filter dates, etc, and if they fold, look at the native SQL. You'll see what I mean.
--Nate
That's correct. Once you are all loaded and the editor is closed, it's only the Connection Queries that cannot be refreshed.
--Nate
Hi Nate, understood. One last question. If the Connection is connected to the same file then I think it does refresh. I mean that if the source data and the connection is in the same file I think a Connection refreshes if not mistaken.
It's does refresh, but only when you refresh the table that loads from the connection file, and only for what is needed for that file. If you have a connection file with no filters, and then three files that reference the connection file but then filter by region, when your files are loaded, and then you refresh only the West Region, the connection file (assuming query folding) query plan will filter to the West Region, and never bother with bringing in the other regions. Or if your West query only needs two columns, the connection query will select only those two columns.
Try adding an unfiltered connection only file, then add some reference files that remove columns, filter dates, etc, and if they fold, look at the native SQL. You'll see what I mean.
--Nate
Thank you Nate!
