Skip navigation

Switch data sources by changing a parameter in a workbook

score 19
You have not voted. Active

Hello,

 

it would be very useful for a scenario in which there are several identical data sources (e.g. SQL Server DB with the same data structures in different Databases) to have the possibility to change the Database to run a query against from a parameter, directly by the end user.

This is currently not possibile by using Custom SQL simply because the Tableau parameter has automatically enclosed with single quotes (because of the data type String).

 

It would be sufficient to add another data type (e.g. enum or something like that) with no quotes added to the paramter value at the beginning and at the end.

 

This would let me simply parametrize the full syntax of a SQL query, for instance the FROM clause: "SELECT ... FROM <my_parameter> WHERE ...."

 

Many thanks

Comments