This page was last updated on 11/6/2019

Since then, there have been some significant changes to our strategy, direction, and focus, so statements and recommendations may be outdated and not all examples may work.

The most up to date information can be found on the homepage, as well as any pages that don't show this warning.

If you encounter any inaccuracies, we welcome you to help us improve this page or submit an issue.

SQLite Database

target-sqlite is a loader that works with other extractors in order to move data into a SQLite database.


Installing from the Meltano UI

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


Once the loader has installed, a modal will appear that'll allow you to configure your SQLite database connection.

Installing from the Meltano CLI

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

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

CLI Configuration

  1. Open your project's .env file in a text editor
  2. Add the following variables to your file: