About this question
What is the major point of distinction between live and extract connections?
What is the major point of distinction between live and extract connections?
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Tableau Expert
Answered on Aug 8, 2023
Live connections are the data source having direct link to the actual data and they can be utilized where the data is practical which when upgraded, also upgrades our visualization automatically. Moreover, live connections are slower for intricate visualizations. They are deployed in less intricate visualizations with less data sets, and filters. They get refreshed whenever there is an alteration in the real data source. Live connections depend on the database for the queries and a live connection in Tableau implies that Tableau is querying and reading from the database directly.
Extract files refer to the regional copy of the data source that can be used to create the view. They are deployed where the visualization can be produced by a subset such as maintaining the track of the monthly record of the hospital. As compared to live connections, extracts are faster for visualization purposes and used for intricate visualization involving huge datasets. Extracts refer to the data snapshot hence they must be refreshed to get updates from the real data source.
The Tableau Training & Certification at JanBask Training offers experience like offline classes, saving students from the hassle of traveling to the physical location. The training provides a total Tableau discipline preparation by teaching the core concept and techniques that the job role demands. The training also gives extensive training to impart fundamental and advanced concepts through interesting e-tools and expert-led Tableau classes. Furthermore, JanBask Training helps you get job-ready and face the tough competitive market with confidence.
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Most-read guides across JanBask
Common Tableau interview questions, answered
Guides, tips and career advice on Tableau from JanBask experts.
Tableau Tableau Career Opportunities: What You Need to Know About Tableau in 2025
Master Tableau and land your dream data visualization job. This blog explores Tableau careers, why Tableau is in-demand, and the…
Tableau Tableau Developer Salary for Beginners & Professionals: 2025 Updated Figures
Looking for average Tableau Developer salary? Know how much salary of Tableau Developer to expect based on experience, top…
Tableau Tableau Career Path: Roles, Skills & Certifications
Learn about the different job roles and skills required for a successful Tableau career. Discover how to advance your career with…
Tableau Learn Tableau: Master the Most In Demand Course & Certification
Learn Tableau and harness the power of data visualization. Discover the benefits of Tableau certification and Tableau career…