# 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:
# Installation and configuration
# Using the Command Line Interface
Add the
target-csv
loader to your project usingmeltano add
:meltano add loader target-csv
Configure the settings below using
meltano config
.
# Using Meltano UI
Start Meltano UI using
meltano ui
:meltano ui
Open the Loaders interface at http://localhost:5000/loaders.
Click the "Add to project" button for "Comma Separated Values (CSV)".
Configure the settings below in the "Configuration" interface that opens automatically.
# Next steps
Follow the remaining step of the Getting Started guide:
If you run into any issues, learn how to get help.
# Settings
target-csv
requires the configuration of the following settings:
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='"'