What are you using the initial SQL for in this scenario?
Hey Ken, thanks for popping in here to help!
I'm doing a few things:
1. I'm using a a group-by clause and lag function to find the state of a new column I'm creating for each row based on the previous row in that group.
2. What I would like to start doing is create a number of data sources greater than one against the same Redshift database, using the initial sql to filter out non-relevant data that my users shouldn't see in their dashboards.
I do realize that the lag function might cause issues with iterative updates, and that I'll be possibly caching redundant data by creating multiple data sources from the same Redshift table.
So it sounds like you are doing Custom SQL, not Initial SQL (see the following for details about Initial SQL: Run Initial SQL). If that's the case, then you can do the following:
1) Connect to RedShift.
2) Build your data model using custom SQL and other Tableau features.
3) Create an extract.
4) Publish the data source to Tableau Server. When doing this, you need to be sure to embed the data source password and put it on a refresh schedule.
Then, when people need to use that data source, they can just connect to the published Tableau Server data source.
If you need to do incremental refreshes then see this: Refresh Extracts
Okay, yeah, I'm definitely using the wrong terminology - thanks for the correction.
And thank you for the direction, I'll try this method and report back