Is there a way to use temporary tables in custom sql dataset creation?

In Tableau, you can run ‘Initial SQL’ in lieu of temporary tables, but I do not see this option. When trying to use temp tables in the query editor I am getting an error that the table does not exist. Datasource is Redshift

Hi,

It’s not supported right now. You can use the With Clause to use the sql query.

But it is good to go with view in DB. :slight_smile:

regards
Naveed Ali

Flagging this as a feature-request

#feature-request

1 Like