2 Replies Latest reply on Mar 19, 2012 12:42 PM by mikekoh1

    Dynamic Data Connection

      Is there a way for Tableau to use URL parameters to make a data source dynamic? We've broken up result sets in our database into partitions, and we would like to be able to query from a particular partition with Tableau based on a key.

       

      For example, if I have a URL such as http://mysite.com?partition_id=2, is there a way to access the value of partition_id when I create a Custom SQL connection like so:

       

      SELECT

      ...

      FROM "schema"."partition_".[partition_id]

       

      If there is, what is the correct syntax? Thank you.