Live vs extract connections in Tableau - Quick Revision & Key Differences

Recall & Review

beginner

What is a live connection in Tableau?

A live connection in Tableau means the data is connected directly to the source and updates in real-time or near real-time whenever you interact with the dashboard.

beginner

What is an extract connection in Tableau?

An extract connection uses a snapshot of the data saved locally or on Tableau Server. It does not update automatically unless you refresh the extract manually or on a schedule.

beginner

Name one advantage of using a live connection.

Live connections provide up-to-date data, which is useful when you need the latest information for decision-making.

beginner

Name one advantage of using an extract connection.

Extracts improve performance because Tableau works with a smaller, optimized copy of the data instead of querying the full source every time.

intermediate

When might you prefer an extract connection over a live connection?

You might prefer an extract when the data source is slow, unreliable, or when you want faster dashboard performance without constant querying.

What happens when you use a live connection in Tableau?

A Data is stored in a local Excel file

B Data is saved as a snapshot and does not update

C Data updates automatically with every interaction

D Data is only refreshed when you restart Tableau

Live connections query the data source directly, so data updates with every interaction.

Which connection type generally offers better dashboard performance?

A Extract connection

B Live connection

C Both perform the same

D Neither affects performance

Extract connections use optimized snapshots, which usually improve performance.

When using an extract connection, how do you get updated data?

A Data updates automatically in real-time

B You refresh the extract manually or schedule refreshes

C Data never updates once extracted

D You must recreate the workbook

Extracts require manual or scheduled refreshes to update data.

Which connection is better if your data source is slow or unreliable?

A Live connection

B Neither should be used

C Both are equally good

D Extract connection

Extracts reduce load on slow or unreliable sources by using a local snapshot.

What is a key downside of live connections?

A Dashboard performance depends on data source speed

B You cannot filter data

C Data is outdated

D Extracts are required

Live connections depend on the speed and availability of the data source, which can slow dashboards.

Explain the main differences between live and extract connections in Tableau.

Think about how data updates and how fast dashboards respond.

Describe scenarios when you would choose a live connection versus an extract connection.

Consider data speed and update frequency needs.