Live vs Extract Connections
Understand the two major ways Tableau works with connected data. Learn how Live Connections access source data and how Extract Connections use stored snapshots for analysis. Explore their differences, refresh options, advantages, limitations, and practical use cases.
1. Introduction to Live and Extract Connections
Tableau provides different connection approaches for working with data sources. Two important approaches are Live Connections and Extract Connections.
A Live Connection sends queries to the underlying data source when Tableau needs data for a view. An Extract Connection works with a stored snapshot of data that Tableau has extracted from the original source.
What You Will Learn
- Understand Live Connections.
- Understand Tableau Extracts.
- Learn how both connection types work.
- Compare Live and Extract Connections.
- Understand extract refresh operations.
- Explore performance and data freshness considerations.
- Choose the appropriate connection for business scenarios.
2. What Is a Live Connection?
A Live Connection allows Tableau to query the underlying data source when a user interacts with a visualization or requests data.
Instead of relying on a stored extract as its primary data representation, Tableau sends queries to the connected source. The source processes those queries and returns the requested results.
How Live Connections Work
- Tableau connects to a supported database or data source.
- The user creates a worksheet or visualization.
- Tableau sends the required query to the source.
- The data source processes the query.
- The results are returned to Tableau.
- Tableau displays the updated visualization.
Advantages of Live Connections
- Can provide access to current source data when queries execute.
- A separate Tableau extract does not need to be maintained.
- Suitable for data sources that require centralized control.
- Can work well with databases optimized for analytical queries.
- Useful when source-side updates need to be reflected in analysis.
Limitations of Live Connections
- Performance depends on the source system and network.
- Complex queries may increase database workload.
- Network interruptions can affect access to data.
- Database permissions and availability are important.
- High user activity can increase query demand on the source.
3. Live Connection Architecture
In a Live Connection, Tableau communicates with the original data source to retrieve the results required for a view.
Figure 1: Conceptual architecture of a Tableau Live Connection.
4. What Is a Tableau Extract?
A Tableau Extract is a stored snapshot of data created from an original data source. Tableau extracts the selected data and stores it in its extract format so that analysis can use the stored data rather than querying the original source for every interaction.
Extracts are useful when users want to improve workbook responsiveness, work with data offline where supported, or reduce repeated queries against a source system.
How Extract Connections Work
- Connect Tableau to the original data source.
- Choose the Extract connection option.
- Configure the required extract settings.
- Run the extract creation process.
- Tableau stores the extracted data.
- Worksheets use the stored extract for analysis.
Advantages of Extract Connections
- Can improve performance for many analytical workloads.
- Can reduce repeated query traffic to the original source.
- Supports working with stored data when the original source is unavailable, subject to the product and workbook setup.
- Allows users to configure full or incremental refreshes where supported.
- Can be useful for large reporting environments with controlled refresh schedules.
Limitations of Extract Connections
- Extract data may become outdated until refreshed.
- Extract creation and refresh require processing resources.
- Stored extracts consume storage space.
- Large extracts may require additional memory and disk resources.
- Refresh configuration and permissions must be managed.
5. Extract Connection Architecture
With an Extract Connection, Tableau first retrieves data from the original source and creates a stored extract. The workbook then uses the extract for analysis.
Figure 2: Conceptual architecture of a Tableau Extract Connection.
6. Live vs Extract: Key Differences
Both connection types help users analyze data, but they differ in how data is accessed, stored, refreshed, and maintained.
| Comparison | Live Connection | Extract Connection |
|---|---|---|
| Data Access | Queries the original data source. | Uses stored extracted data. |
| Data Freshness | Can reflect current source data when queries execute. | Depends on the last successful extract refresh. |
| Storage | Does not require a separate extract for the connection. | Requires storage for the extract. |
| Performance | Depends on source performance, query complexity, and network. | Can improve responsiveness for suitable workloads. |
| Network Dependency | Generally requires access to the source when queries execute. | Can use stored data without continuous source access, subject to workbook configuration. |
| Refresh | Source data is queried as needed. | Requires full or incremental refresh as configured. |
| Database Workload | Queries are sent to the source. | Source is accessed during extract creation and refresh. |
| Typical Usage | Source-driven and frequently changing analysis. | Scheduled reporting and stored analytical datasets. |
7. Extract Refresh: Full and Incremental
Extract refresh is the process of updating stored extract data from the original source. Tableau provides different refresh approaches depending on the data source and configuration.
Full Refresh
A Full Refresh rebuilds the extract using the data returned by the configured source query. It replaces the previous extract contents with the refreshed data.
When to Use Full Refresh
- When existing records may have changed.
- When records may have been deleted.
- When a complete rebuild is required.
- When incremental refresh is not suitable for the source or requirement.
Incremental Refresh
Incremental Refresh adds new records to an existing extract based on a configured field and refresh strategy, where supported.
When to Use Incremental Refresh
- When new records are regularly added.
- When a suitable incrementing field is available.
- When rebuilding the entire extract is unnecessary.
- When the source and refresh configuration support incremental updates.
| Feature | Full Refresh | Incremental Refresh |
|---|---|---|
| Operation | Rebuilds the extract. | Adds qualifying new records. |
| Data Coverage | Re-reads the configured source data. | Focuses on records identified by the incremental configuration. |
| Processing | May require more processing for large datasets. | Can reduce processing for suitable append-only workloads. |
| Changed Records | Can capture changes when the refreshed source query returns them. | Does not automatically detect every modification to older records. |
8. Extract Refresh Workflow
Extracts must be refreshed according to business requirements so that stored data remains sufficiently current for reporting.
Figure 3: Typical Tableau Extract refresh workflow.
9. When Should You Use Live or Extract?
Choosing the correct connection depends on the business requirement, data freshness, source performance, network availability, and the amount of data being analyzed.
Choose Live Connection When
- Users need to query current source data frequently.
- The underlying database can handle the required queries.
- Source-side security and governance are important.
- Maintaining a separate extract is not desirable.
- The data source is reliably accessible.
Choose Extract Connection When
- Stored data can meet the reporting freshness requirement.
- Improved responsiveness is important for the workload.
- Repeated queries should be reduced against the source.
- Scheduled refreshes are acceptable.
- Users need to work with stored data in supported scenarios.
Real-World Business Scenarios
| Business Scenario | Possible Choice | Reason |
|---|---|---|
| Frequently updated operational reporting | Live | Queries the original source when views are accessed. |
| Daily management dashboard | Extract | A scheduled refresh may meet the reporting requirement. |
| Large reporting dataset with suitable source support | Extract | A stored extract may improve responsiveness. |
| Centralized database with controlled access | Live | Can keep queries within the source system's access model. |
| Analysis during periods without source access | Extract | Stored data may remain available, subject to workbook configuration. |
10. Performance Considerations
Tableau workbook performance is influenced by many factors. Connection type is important, but database performance, data volume, network quality, calculations, and workbook design also affect response times.
| Factor | Impact | Recommended Practice |
|---|---|---|
| Data Volume | Large datasets can increase processing time. | Use appropriate filters and data preparation. |
| Network Latency | Can affect Live Connection query response. | Use reliable network infrastructure. |
| Database Performance | Slow source queries can affect visualizations. | Optimize database queries and source design. |
| Extract Size | Large extracts can increase storage and refresh costs. | Extract only required data when appropriate. |
| Calculations | Complex calculations can increase query or processing work. | Review calculations and simplify where possible. |
| Filters | Filter design can affect query execution. | Use filters according to the analysis requirement. |
11. Common Problems and Troubleshooting
| Problem | Possible Cause | Suggested Solution |
|---|---|---|
| Live Connection is slow | Slow database queries or network latency. | Review source performance and optimize queries. |
| Database is unavailable | Server outage or connectivity issue. | Verify server availability and network access. |
| Extract is outdated | Refresh has not run successfully. | Check refresh status and execute the required refresh. |
| Extract refresh fails | Credentials, permissions, or source errors. | Check connection credentials and refresh logs. |
| Extract file is large | Too many rows or unnecessary fields. | Review the extract scope and data requirements. |
| Incremental refresh misses updates | Older records were modified outside the incremental strategy. | Review the refresh key and consider a full refresh. |
12. Practical Exercise
Task: Compare Live and Extract Connections
Use a sample Excel or database dataset to explore the two connection approaches in Tableau.
Exercise A: Live Connection
- Open Tableau Desktop.
- Connect to a supported data source.
- Select the Live connection option where available.
- Create a worksheet using Sales and Region fields.
- Review the visualization and source connectivity.
Exercise B: Extract Connection
- Connect to the same supported data source.
- Select the Extract connection option.
- Configure the extract settings.
- Create the extract.
- Create a similar worksheet.
- Compare the experience with the Live connection.
Exercise C: Refresh the Extract
- Review the available extract refresh options.
- Understand the difference between full and incremental refresh.
- Run an appropriate refresh where supported.
- Verify the refreshed data.
13. Practice Questions
Basic Questions
- What is a Live Connection in Tableau?
- What is a Tableau Extract?
- How does a Live Connection work?
- Why are Tableau Extracts created?
- What is the difference between Live and Extract Connections?
- What is an extract refresh?
- What is a full refresh?
- What is an incremental refresh?
Practical Questions
- Create a Live Connection to a supported data source.
- Create an Extract Connection.
- Compare the two connection approaches.
- Review the extract refresh options.
- Identify the factors affecting connection performance.
- Verify whether an extract has been refreshed successfully.
Interview Questions
- Explain Live and Extract Connections in Tableau.
- When would you choose a Live Connection?
- When would you choose an Extract Connection?
- What is the difference between full and incremental refresh?
- Does a Live Connection always show real-time data?
- How can you improve Tableau workbook performance?
- What happens if an extract refresh fails?
- What are the limitations of incremental refresh?
14. Summary
In this lesson, we learned about the two important Tableau connection approaches: Live Connections and Extract Connections. A Live Connection queries the original data source, while an Extract Connection works with a stored snapshot of data.
We explored their architectures, advantages, limitations, performance considerations, and business use cases. We also learned about Full Refresh and Incremental Refresh operations used to update Tableau Extracts.
Choosing the correct connection depends on data freshness, source performance, network availability, storage, and reporting requirements. In the next lesson, we will explore Data Fields and Data Types in Tableau.