SQLite Database

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

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 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:
export SQLITE_DATABASE=""
Last Updated: 10/7/2019, 5:23:46 AM