First Data Connection

Connect Tableau to a CSV file and get oriented on the Data Source page -- including the choice between a Live connection and an Extract.

2 minutesVideo LessonPDF notes

🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Loading progress...

Key moments

Opening Workbook and File Selection — The instructor opens a new Tableau workbook and selects the Text File connection option.
Connection Options and Table Management — The instructor explains how to edit connection paths and contrasts text file tables with multi-tab Excel files.
Canvas Placement and Metadata Grid — The dataset is dragged onto the canvas, revealing field names, data types, and originating tables in the lower grid.
Live vs Extract and Global Filtering — The instructor contrasts Live connections with Data Extracts and explains how to add data source filters.
Navigating to Sheet 1 — The instructor clicks the orange Sheet 1 tab to leave data configuration and enter the visual workspace.

PDF notes

Bottom line: You will connect Tableau to flat files such as CSVs and Excel workbooks, configure table relations on the canvas, and inspect field metadata. You will also evaluate whether to use a Live connection or an Extract and apply data source filters before beginning sheet-level analysis.

This lesson on First Data Connection is hands-on and example-driven. You will connect Tableau to flat files such as CSVs and Excel workbooks, configure table relations on the canvas, and inspect field metadata. You will also evaluate whether to use a Live connection or an Extract and apply data source filters before beginning sheet-level analysis.

What You'll Be Able To Do

Initiate a new connection from the Tableau start screen using the text file connector.
Manage connections by editing file paths or renaming existing data source connections.
Drag and place individual tables or sheets onto the data source canvas.
Verify column data types and origin tables within the metadata grid preview.
Select between Live connections and Data Extracts based on refresh and performance requirements.
Apply data source filters to exclude irrelevant records before building visualizations.

Detailed Concept Walkthrough

1. Connecting to Flat Files

Tableau ingests structured data by binding specialized connectors to underlying files or servers. Choosing the correct file connector establishes a link to the raw data without altering the source file.

Mechanism: Launching a new workbook presents the Connect pane where file formats like Text File (.csv, .txt) or Microsoft Excel (.xlsx) are selected to open the file navigator.
Under the Hood: Tableau creates a workbook-level connection definition referencing the absolute or relative file path on disk without duplicating data until an extract is requested.
Best Practice: Use the downward arrow on the Connection menu in the Data Source page to edit the file path or rename the connection descriptor when data sources migrate.

# Example Tableau Data Source (.tds) connection configuration XML snippet
<connection class='textscan' directory='/data/flights' filename='wildlife_strikes.csv'>
  <relation name='wildlife_strikes.csv' table='[wildlife_strikes#csv]' type='table' />
</connection>

Key Takeaway: Connecting to a file creates a reference pointer in Tableau that leaves the raw source file intact.

2. Canvas Table Placement and Structure

The Data Source canvas defines the data model by pulling individual tables or spreadsheet tabs into Tableau's query pipeline.

Mechanism: Dragging a table from the left-hand Files list onto the upper canvas registers it as the primary data entity for the workbook.
Execution Flow: For flat text files, the single file represents one table, whereas multi-tab Excel workbooks expose every worksheet as an independent table in the left pane.
Nuance: Placing multiple tables on the canvas prepares the data model for combining or blending relationships across sources.

-- Logical representation of a single flat table dropped onto the canvas
SELECT *
FROM [wildlife_strikes#csv]
WHERE 1=1;

Key Takeaway: Single text files yield one table, while Excel files surface distinct sheets that can be individually dragged onto the canvas.

3. Metadata Grid and Field Inspection

The lower metadata pane displays field names, assigned data types, and originating tables for all columns loaded into the canvas.

Mechanism: The grid shows a sample preview of rows alongside icons indicating assigned types such as text, integer, date, or geographic role.
Under the Hood: Tableau scans the initial rows of each column to infer schema types automatically, tracking the lineage of every field back to its source table.
Best Practice: Inspect field data types and origin references in this grid before building views to ensure dimensions and measures parse correctly during blends.

# Conceptual field mapping generated in metadata pane
# [Column Name]    | [Inferred Type] | [Origin Source]
# Incident_Date    | Date            | wildlife_strikes.csv
# Aircraft_Model   | String          | wildlife_strikes.csv
# Damage_Cost_USD  | Integer         | wildlife_strikes.csv

Key Takeaway: Verify inferred data types and field origins in the lower preview pane prior to worksheet visualization.

4. Live Connections versus Data Extracts

The connection toggle determines whether Tableau executes real-time queries against the raw source or builds an optimized in-memory snapshot.

Mechanism: Selecting 'Live' sends direct queries to the source file on every view update, reflecting source modifications immediately upon refresh.
Under the Hood: Selecting 'Extract' snapshots the data into Tableau's high-performance columnar data engine, reducing query latency across large datasets.
Best Practice: Use Live connections during active data file editing, but switch to Data Extracts for dashboard responsiveness and production stability.

# CLI command using Tableau Data Extract utility to generate hyper file
tableau-extract create --source wildlife_strikes.csv --output wildlife_strikes.hyper

Key Takeaway: Live connections ensure instant updates from source modifications, while Extracts optimize query speed through columnar storage.

5. Data Source Filtering

Data source filters restrict the rows ingested into the workbook globally before any sheet calculations or aggregations occur.

Mechanism: Clicking the 'Add' button under Filters in the top right allows defining categorical, range, or conditional exclusion rules.
Execution Flow: Data source filters are appended to the WHERE clause of every query sent to the underlying file or extract.
Best Practice: Apply data source filters to permanently eliminate irrelevant historical partitions or invalid records from the entire workbook lifecycle.

-- SQL WHERE clause generated by a Data Source Filter
SELECT [Incident_Date], [Aircraft_Model], [Damage_Cost_USD]
FROM [wildlife_strikes#csv]
WHERE [Incident_Year] >= 2015;

Key Takeaway: Data source filters permanently exclude unwanted records at the ingestion stage across all workbook sheets.

Topics Covered in First Data Connection

Opening Workbook and File Selection (0:00 - 0:20) — The instructor opens a new Tableau workbook and selects the Text File connection option.
Connection Options and Table Management (0:21 - 0:45) — The instructor explains how to edit connection paths and contrasts text file tables with multi-tab Excel files.
Canvas Placement and Metadata Grid (0:46 - 1:05) — The dataset is dragged onto the canvas, revealing field names, data types, and originating tables in the lower grid.
Live vs Extract and Global Filtering (1:06 - 1:30) — The instructor contrasts Live connections with Data Extracts and explains how to add data source filters.
Navigating to Sheet 1 (1:31 - 1:45) — The instructor clicks the orange Sheet 1 tab to leave data configuration and enter the visual workspace.

Reference Cheat Sheet

Connect > Text file — Opens file dialog to import CSV or delimited text files
```
Connect -> Text file -> wildlife_strikes.csv
```
Connection > Edit Connection — Updates file path or reconnects to a renamed source
```
Data Source Tab -> Connections -> Edit Connection...
```
Canvas Drag-and-Drop — Adds a file or worksheet to active data model
```
Drag [wildlife_strikes.csv] to 'Drag tables here' canvas
```
Connection: Live — Directly queries raw file; updates reflect instantly on refresh
```
Radio selection: (o) Live
```
Connection: Extract — Saves snapshot into columnar format for faster processing
```
Radio selection: (o) Extract
```
Filters > Add — Applies global row-level filter across the entire workbook
```
Filters -> Add -> [Damage_Cost_USD] > 0
```
Sheet 1 (Navigation) — Exits Data Source screen to begin building visual worksheets
```
Click orange tab: Sheet 1
```

Comparison Table

Feature / Dimension	Live Connection	Data Extract
Query Target	Direct file on disk	In-memory snapshot (.hyper)
Source Updates	Reflected immediately on refresh	Requires extract refresh job
Query Speed	Dependent on source I/O	Optimized for fast rendering
Offline Availability	Requires source file access	Self-contained inside extract

Common Pitfalls

Mistake: Expecting multiple tables inside a plain CSV connector. Avoid: Remember text files contain only one table whereas Excel files contain multiple tabs.
Mistake: Leaving unwanted records in large files. Avoid: Apply Data Source Filters in the top right before building sheets.
Mistake: Assuming Live connections automatically cache data. Avoid: Switch connection type to Extract when query latency on disk files becomes slow.

FAQs

Why does a text file connection only show one table in the Files pane? A CSV or delimited text file represents a single flat dataset, unlike an Excel workbook which can hold multiple distinct worksheets.
When should I choose a Live connection over an Extract? Choose Live when underlying source data changes frequently and updates must appear immediately without triggering an extract refresh.
What happens when I apply a filter on the Data Source page? It applies globally to the connection, removing those records from all calculations, worksheets, and dashboard views.

Common pitfalls

Mistake: Expecting multiple tables inside a plain CSV connector. Avoid: Remember text files contain only one table whereas Excel files contain multiple tabs.
Mistake: Leaving unwanted records in large files. Avoid: Apply Data Source Filters in the top right before building sheets.
Mistake: Assuming Live connections automatically cache data. Avoid: Switch connection type to Extract when query latency on disk files becomes slow.

Hi folks. In today's uh Tableau in Two Minutes video, we are going to uh show you how to connect to a new data file. Um so obviously what you're going to do is you're going to open up the uh the File menu and just open a new Tableau workbook. Um it's going to give you a page like this with some connection options um or potentially some other uh workbooks that you've had open in the past. Uh to connect to a file, just select the file type from the left-hand side. So, we're going to select a text file. And this is some uh data on wildlife strikes on aircraft. So, we're going to connect to that and that's going to bring us to this uh data source page. So, on the left-hand side, we have our file. Um that's under the Connections tab here. You can change the file by clicking on the downward arrow here um and either edit the connection to connect to a different file or rename the connection. Uh underneath it right here where it says Files, these are the tables within that data source. So, this is a uh text file, so there's going to be one table within it. But if this was an Excel file, there might be several tabs. And you could see each tab listed underneath this uh this File menu. If you want to add one to the view, you just drag it uh over here uh and then drag it into this area and it will it will add it to the uh data source for you. Uh down here at the bottom, we have our list of fields along with the uh the data type and the field that it comes from. Um when we start getting into blending data and combining data within the uh top here, you'll see that this becomes a lot more helpful cuz we can see where some of our fields come from. Uh and then finally, up on the top right, we have the uh connection type, whether we are connecting live to the data source or whether we're using a data extract. Uh data extract is usually a bit faster, um but it doesn't make much difference and the uh live connection allows us to update the source data and then have that immediately reflected within Tableau. And then finally, we have our filters, um filters that you have added to the data source in order to uh filter out certain things that you know for sure you're never going to want in your uh workbook. Uh so, you can use that. Uh mostly you won't, but occasionally it comes in very handy. Uh and then finally, once we are comfortable with everything on this page, we can go ahead and click down here on the orange uh Sheet 1, and that will take us to the workbook. Thanks very much for joining us and uh we hope to see you again when we come back with uh the next Tableau in Two Minutes video. To see more, uh please visit blackandwhiteanalytics.com/tableauintwominutes.

Frequently asked questions

Why does a text file connection only show one table in the Files pane?

A CSV or delimited text file represents a single flat dataset, unlike an Excel workbook which can hold multiple distinct worksheets.

When should I choose a Live connection over an Extract?

Choose Live when underlying source data changes frequently and updates must appear immediately without triggering an extract refresh.

What happens when I apply a filter on the Data Source page?

It applies globally to the connection, removing those records from all calculations, worksheets, and dashboard views.

How was this lesson?

Your feedback helps us refine explanations and catch bugs.