I would like to know more about Extract connection in Tableau Desktop
Let's say the data source that I connect from Tableau desktop is SQL Server. Assume that I selected Extract connection.
I would like to know what happens in background if I select extract connection?
Where is it exactly the extracted dataset gets stored?
Is it stored in RAM memory of the machine in which the Tableau desktop is installed? If yes, then what happens if the extracted dataset size is more than RAM memory size?
Or
Does it get stored in some cache memory of Tableau desktop software itself?