Live Connection vs Data Extract (.hyper)0%
Live Connection vs Data Extract (.hyper)
Beginner12 min read•Updated: Jul 11, 2026
Live Connection vs Data Extract (.hyper)
Reading Time: 8 Mins | Level: Beginner to Advanced
1. Live vs Extract: The Strategic Decision
1. Live Connection
- Sends real-time queries directly to the underlying data source.
- Pros: Real-time data freshness (second-by-second updates).
- Cons: Constrained by the speed of the underlying database network.
2. Data Extract (.hyper)
- Ingests and compresses data into Tableau's proprietary high-performance in-memory columnar database: Hyper.
- Pros: Extremely fast query execution, offline capability, isolates operational databases from heavy analytics queries.
- Cons: Data is only as fresh as the last extract refresh.
Interactive Quiz
Multiple Choice Questions
Question 1
What is the underlying high-performance columnar in-memory database engine used by Tableau for data extracts?
Question 2
When is a 'Live Connection' strictly required instead of an Extract?
Question 3
What file extension denotes a Tableau Data Extract?
Question 4
Can you configure an Extract to refresh incrementally (loading only new rows) rather than rebuilding the full extract?
Question 5
What happens to a Tableau workbook with an Extract connection if the user disconnects from the company network?
Next Lesson
Dimensions vs Measures & Discrete (Blue) vs Continuous (Green) Pills
Continue learning with hands-on practice, examples, and exercises in the upcoming topic.
Related Lessons
Practice Quiz
Test your understanding of this lesson with 5 questions. Each question has one correct answer.