It is best you can create views from all data. In tableau you can hide all the data columns which were not used . so you can use it.
Thank you Tharashasank.
So are you saying that that querying one large data set once, is faster than querying 10 small sets 10 times?
And then, if I hide the columns Tableau will literally not pull them it? or will just hide them?
And is this hiding per sheet, or per the entire file? Obviously, columns can be unhidden as needed?
2 of 2 people found this helpful
Iam not saying that the querying on large data base is faster than small data set. The point that i want to highlight is when you connect with data sources tableau does not pull any data in to tableau. when you try to create a view then it queries the data source until then none of the operation is performed.
you can also create a table in your data source depending upon your view and you can query it.
when you are not using specific columns in the data base that means tableau is not fetching any data from that columns.
So obviously it increases your performance.