CSV Connections

A CSV connection reads from and writes to CSV files managed within the connection. Each CSV file appears as a table, which you can use as a source or target in a migration.

For the initial connection setup, see Creating Connections. This article covers managing the files and table metadata once the connection exists.

Managing CSV Files

Open the connection and select the Files tab to manage its CSV files.

• Upload files with the Upload CSV Files button, or drag and drop .csv files anywhere onto the Files area.
• The file list shows each file's Name and Size.
• To remove a file, press the delete button. A confirmation dialog appears before the file is deleted.

Each .csv file in the connection becomes a table named after the file.

Table Metadata

Select the Metadata tab to view and edit table and field metadata. Choose a table from the list to edit its metadata, including:

• Field data types
• Field labels
• The primary key
• Text encoding

Press the Edit button next to a field to open its metadata editing dialog - here you can the following properties:

• Required on create and Required on update
• Readable
• Writeable on record create and Writeable on record update
• Queryable
• Max length

Editing metadata does not change the underlying CSV files. Keep any field-name edits consistent with the headers in the data, so that records continue to map correctly.

For CSV connections, metadata caching is always on: your edits are saved and restored automatically. The metadata-cache toggle and cache-status panel shown for remote-schema connections are therefore not displayed. See Table Metadata and Caching for how metadata caching works across connection types.

The Advanced tab is not shown for CSV connections, as its SSL and timeout settings apply only to server-based connections.

See Also

• Creating Connections
• Table Metadata and Caching
• Connection Explorer