This is not currently possible but it is a common request and is a feature we would like to eventually support. I cannot comment on when this might happen.
This is REALLY unfortunate.
Tableau is unusable for our purpose without the ability to limit custom sql based on initial parameters.
Otherwise Tableau & Tableau Server would be our clear #1 solution.
Is there no ETA to add this feature?
I'm sorry that this is such a show-stopper for your needs. Perhaps there are alternate ways of meeting your requirements? While you cannot yet use Parameter controls from your worksheets and dashboards to influence the Custom SQL parameters, you certainly can supply hard-coded values in your Custom SQL connection. I understand that this does not provide a fully dynamic experience, so you may wish to consider formulating your Custom SQL as a database view, since Tableau can connect to the view as if it were a table. Because Tableau pushes computations (queries) to the database, you will be able to use filters and parameters within your visualizations and be assured that the queries to your database are properly constrained by filters and aggregation to maintain efficiency.
Regarding an ETA or roadmap, this is not something we can usually offer because we need the flexibility within the development team of reprioritizing features and reacting to shifts in the technical landscape, customer needs, etc. However I will reiterate that we recognize how important this feature is for many customers, and I sincerely hope (but cannot promise) that we can address your needs by 8.0.
Thanks for your feedback,
to the extent it helps - add me to the list of users interested in this functionality.
Yes this would be a huge help for me too - I work mostly with Custom SQL as our BI team doesn't give permissions to create views or tables.
This would a great feature for me as well - want to use it to filter down the data source based on start and end time parameters on the dashboard.
Consider this my signature on this petition!
We are looking to be able to confine our data source using parameters passed into the custom SQL itself, not just a filter within Tableau. This would greatly assist with run times of our source data--currently we have extracts running every couple hours, but our users are clamoring for live data. Due to the time it takes to run our extracts, live data is just not feasible until we can reduce the queries (using dynamically controlled SQL) to only the data they're after.
Any developments, changes or further developments from anyone at Tableau?
This would be really nice.
A bandaid solution is to pull in everything and then create the parameters in Tableau. Which is good when the data extract is small or medium, but unwieldy when it's really large.
+1 vote for us also. Not to gripe but this is a pretty useful feature and I'm very surprised the software doesn't already support it. Just about every other reporting/BI tool I've ever used has this capability and it would be a great addition to Tableau.
Both Crystal and Cognos support this feature. It makes it much easier to limit the data set to something reasonable before being available to the tool.
I cannot wait to have this feature available too.
Or maybe another option is allowing stored procedures as currently the choice is limited to tables/views only.
Inability to narrow down data set right away for many is definitely a show stopper!
Count me as well