While configuring a connection to a PostgreSQL database in Tableau Desktop, you choose the Live option rather than Extract. How will Tableau handle query execution and data storage for visualizations in this workbook?
Tableau submits a fresh query to PostgreSQL whenever the view is refreshed and stores no local data file.
Tableau copies the data into a compressed .hyper extract and queries that file instead of the database.
Tableau automatically creates and schedules background refreshes on Tableau Server to keep the workbook updated.
Tableau runs a single query once, caches the result permanently, and never reconnects to PostgreSQL.
Selecting the Live option keeps Tableau connected directly to the source database. Each time a worksheet, dashboard, or filter needs data, Tableau submits a new query to PostgreSQL and retrieves the current results; no .hyper file or other local copy is created. Choosing Extract would instead copy the data into a compressed .hyper file on the local machine and direct all subsequent queries to that file. A live connection does not rely on a permanent cache, nor does it create or schedule refreshes automatically-those behaviors are specific to extracts that are published to Tableau Server or Cloud.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are the key differences between Live and Extract connections in Tableau?
Open an interactive chat with Bash
Why would you choose a Live connection over an Extract in Tableau?
Open an interactive chat with Bash
How does Tableau handle query optimization when using a Live connection?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .