How To Use SQL Temp Tables In Tableau

In this training we discus how to use temporary sql tables in tableau to perform advanced SQL joins. Natively you cannot create these temporary tables in Tableau using the Custom SQL connector.
Learn More: beginwithdata.com
Instead you will need to use the Initial SQL connection to create the table in memory and then reference the queries using the temp tables in the Custom SQL query.
I would love to see if this also works for CTE's (common table expressions) in Tableau. These in memory tables allow you to perform complex transformations and then join them back to your data.

[@sathishij5660]

Great and much needed information for me. Thank you so much 🙏

[@MrBasu-iq6md]

Thank you.

[@srrinathnaramshetty5240]

Does biguery connector supports initial sql ? If yes kindly please help & guide

[@jacobmillard9413]

This is exactly what I need except I prefer to use CTEs is there a way to do this in Tableau using CTEs?

[@breadandcheese1880]

Hi there- For this approach, we need more than just read only access to the database correct? It does seem that we are creating a temp space in the database booked for the temp data. Any idea?

[@sconnell194]

👍

[@alpeshkumar8773]

Initial SQL runs only in starting of the session, what should I do to refresh it to update temp table during the session in Tableau

[@PremShah_Realtor]

Hi
Question: I am trying to build a custom SQl query based on parameters for DB Name and Table Name. Basically I have a dashboard where I am trying to fetch Table Metadata by selecting DB/Schema name and Table Name. So Basically I want to build SELECT * FROM . Is it possible?
.Any help or lead will be much appreciated

[@stuckcamping]

Users have access to creating temp tables but what if your users don't have access to the table where max region IPA is coming from?

[@pavanj4080]

Hi , Good morning .
I need one help . i am working in tableau developer . i got one requirement like .
classification column & DISTINCT ICTO column pulled hence data seems like below
MAS -- 120
MAS,SOX -- 305
MAS,LOX --138
SOX--- 56
LOX--- 26
MAS,SOX,LOX--405
I need to show the above data in venn diagram kind of the chart .could you please make it for me .
whether it's possible to show in Venn diagram chart if not .please suggest alternative solution . i am waiting for your response . thanks a lot :)

[@himinshu]

Can I create a calculated filed using custom sql in Tableau

[@swehavenkateshwari7454]

Is possible to have multiple CTE in single query?

[@pratheep88]

yes possible

[@michaelsmith1076]

Do you have an email I can send a sorting problem to?