# SQLite
The target-sqlite
loader loads extracted data into a SQLite database.
- Repository: https://gitlab.com/meltano/target-sqlite
- Maintainer: Meltano community
- Maintenance status: Active
# 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-sqlite
loader to your project usingmeltano add
:meltano add loader target-sqlite
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 "SQLite".
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-sqlite
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-sqlite
in your meltano.yml
project file will look like this:
plugins:
loaders:
- name: target-sqlite
variant: meltano
config:
database: my_database.db
# Database
- Name:
database
- Environment variable:
TARGET_SQLITE_DATABASE
, alias:SQLITE_DATABASE
- Default:
warehouse
Name of the SQLite database file to be used or created, relative to the project root.
The .db
extension is optional and will be added automatically when omitted.
# How to use
Manage this setting using Meltano UI, meltano config
, or an environment variable:
meltano config target-sqlite set database <database>
export TARGET_SQLITE_DATABASE=<database>
# Batch Size
- Name:
batch_size
- Environment variable:
TARGET_SQLITE_BATCH_SIZE
- Default:
50
How many records are sent to SQLite at a time?
# How to use
Manage this setting using Meltano UI, meltano config
, or an environment variable:
meltano config target-sqlite set batch_size 100
export TARGET_SQLITE_BATCH_SIZE=100
# Timestamp Column
- Name:
timestamp_column
- Environment variable:
TARGET_SQLITE_TIMESTAMP_COLUMN
- Default:
__loaded_at
Name of the column used for recording the timestamp when Data are loaded to SQLite.
# How to use
Manage this setting using Meltano UI, meltano config
, or an environment variable:
meltano config target-sqlite set timestamp_column <column>
export TARGET_SQLITE_TIMESTAMP_COLUMN=<column>