Comma Separated Values (CSV)

Comma Separated Values, better known as spreadsheets, are the swiss army knife of data analysis. Loading data into this format will create .CSV files that can be used with many other tools that are able to import/export this file type.

Info

Installing from the Meltano UI

From the Meltano UI, you can select this Loader in Step 3 of your pipeline configuration.

Configuration

Once the loader has installed, a modal will appear with options for selecting the Delimiter and Quotechar you would like Meltano to use when loads your data into CSV format. The most commonly used options are selected by default.

Installing from the Meltano CLI

  1. Navigate to your Meltano project in the terminal
  2. Run the following command:
meltano add loader target-csv

If you are successful, you should see Added and installed loaders 'target-csv' in your terminal.

CLI Configuration

If you want to customize your delimited or quote character, open meltano.yml for your desired project and update the configuration there.

 
 
 



- config:
    delimiter": "\t"
    quotechar": "'"
  name: target-csv
  pip_url: git+https://gitlab.com/meltano/target-csv.git
Last Updated: 11/6/2019, 4:55:18 PM