2 of 2 people found this helpful
it's a really good question, and perhaps there's a really good explanation. Let me know if this makes sense.
From a workbook perspective, anytime that the extract is EMBEDDED within the workbook, Tableau Server will be able to discern this and tell you it's an extract. And anytime that the workbook has a data pointer to a shared location (independent of whether it be a database or published datasource), it will show LIVE.
Example 1: The extracted data is integral to the specific workbook as it is EMBEDDED.
Example 2: My Admin_Capacity_Mgmt workbook has 5 datasources, they all show LIVE because none of the data exists within the workbook, rather the workbook has pointers to where the data lives. In this case, 3 of them are published datasources, and 2 of them are postgres databases.
And when I click on the first datasource, it shows that the datasource connects to SQL Server and the data was last extracted at 3:03 today.
1 of 1 people found this helpful
The datasource published to the Tableau Server is an extract of a database. The connection in the workbook is a live connection to that published datasource. The labeling can be confusing sometimes.