Tableau never changes the data source in any way, including creating or changing tables, views, stored procedures, etc. All access is read-only. The "temporary table" created due to a context filter is kept in local workstation memory or the extract, not in the original data source.
So, no, it will not give you an error for that reason.
Tableau documentation says that
"Context filters are particularly useful for relational data sources because a temporary table is created. This table is automatically generated by Tableau when you set the context, and acts as a separate (smaller) data source that results in increased performance when you build data views.
For SQL Server, MySQL, and Oracle data sources, you must have permission to create a temporary table on the server."
is it means if we don't have permission to create table in Oracle schema we cant use context filter?
If you do not have permissions to create temporary tables, Tableau will fall back to other methods to get the same functionality using different query structures. There should be no functionality lost if you do not have permissions to create temporary tables.
Thanks, Dan. I learned something here: I didn't know the "temporary table" Tableau produces could actually be on the server side. It is good to know that Tableau automatically detects and adapts to the situation. Very nice indeed.
I think the bottom line is: if you aren't sure if it will work, try it! If it works, no harm was done: Tableau will never harm your original data source. Even if it creates a temporary table somewhere, the original data source remains unchanged. If you want to know exactly what Tableau did, you can examine the log files.
Thanks for turning my rambling into intelligible sentences . I am always a big fan of the "just try it" approach. Pretty much how I learned Tableau.
I am always a big fan of the "just try it" approach. Pretty much how I learned Tableau.
Isn't that how everyone learns Tableau? Certainly the 'just try it' approach is how I answer most forum questions. The only difference between me and a newbie is that I know what to try.