Comma Separated Values (CSV)

The target-csv loader loads extracted data into Comma Separated Values (CSV) files.

• Repository: https://github.com/singer-io/target-csv
• Maintainer: Stitch
• Maintenance status: Nonresponsive to community issues and contributions
  • A more active fork may be available that you can use instead.
  • This plugin is up for adoption!

Getting Started

Prerequisites

If you haven't already, follow the initial steps of the Getting Started guide:

1. Install Meltano
2. Create your Meltano project
3. Add an extractor to pull data from a source

Installation and configuration

Using the Command Line Interface

1. Add the target-csv loader to your project using meltano add:

   meltano add loader target-csv
   

2. Configure the settings below using meltano config.

Using Meltano UI

1. Start Meltano UI using meltano ui:

   meltano ui
   

2. Open the Loaders interface at http://localhost:5000/loaders.

3. Click the "Add to project" button for "Comma Separated Values (CSV)".

4. Configure the settings below in the "Configuration" interface that opens automatically.

Next steps

Follow the remaining step of the Getting Started guide:

1. Run a data integration (EL) pipeline

If you run into any issues, learn how to get help.

Settings

target-csv requires the configuration of the following settings:

• Destination Path

These and other supported settings are documented below. To quickly find the setting you're looking for, use the Table of Contents in the sidebar.

Minimal configuration

A minimal configuration of target-csv in your meltano.yml project file will look like this:

plugins:
  loaders:
  - name: target-csv
    variant: singer-io
    config:
      destination_path: my_csv_files

Destination Path

• Name: destination_path
• Environment variable: TARGET_CSV_DESTINATION_PATH
• Default: output

Sets the destination path the CSV files are written to, relative to the project root.

The directory needs to exist already, it will not be created automatically.

To write CSV files to the project root, set an empty string ("").

How to use

Manage this setting using Meltano UI, meltano config, or an environment variable:

meltano config target-csv set destination_path <path>

export TARGET_CSV_DESTINATION_PATH=<path>

Delimiter

• Name: delimiter
• Environment variable: TARGET_CSV_DELIMITER
• Options: Comma (,), Tab (\t), Semi-colon (;), Pipe (|)
• Default: ,

A one-character string used to separate fields.

How to use

Manage this setting using Meltano UI, meltano config, or an environment variable:

meltano config target-csv set delimiter ";"

export TARGET_CSV_DELIMITER=";"

QuoteChar

• Name: quotechar
• Environment variable: TARGET_CSV_QUOTECHAR
• Options: Single Quote ('), Double Quote (")
• Default: '

A one-character string used to quote fields containing special characters, such as the delimiter or quotechar, or which contain new-line characters.

How to use

Manage this setting using Meltano UI, meltano config, or an environment variable:

meltano config target-csv set quotechar '"'

export TARGET_CSV_QUOTECHAR='"'