SQLite (meltanolabs
variant)
Table of Contents
The
target-sqlite
Singer target
sends data into
SQLite
after it was pulled from a source using a
Singer tap.
-
- Repository: https://github.com/MeltanoLabs/target-sqlite
-
-
-
-
-
-
-
- Maintainer: Meltano Community
- Meltano Stats:
-
-
Alternative variants #
Multiple
variants
of target-sqlite
are available. This document describes the
meltanolabs
variant.
Alternative variants are:
Standalone usage #
Install the package using pip:
pip install git+https://github.com/MeltanoLabs/target-sqlite.git
For additional instructions, refer to the README in the repository.
Usage with Meltano #
Install Meltano, create your Meltano project, and add the target to your project as a loader:
meltano add loader target-sqlite --variant meltanolabs
For additional instructions, refer to the
Meltano-specific documentation for target-sqlite
.
Capabilities #
Settings #
Database Name (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.
Batch Size (batch_size
)
#
- Default:
50
How many records are sent to SQLite at a time?
Timestamp Column (timestamp_column
)
#
- Default:
__loaded_at
Name of the column used for recording the timestamp when Data are loaded to SQLite.
Looking for help? #
If you're having trouble getting
target-sqlite
to work by itself or with
Meltano, look for an
existing issue in its repository, file a new issue,
or
join the Meltano Slack community
and ask for help in the #plugins-general
channel.
Found an issue on this page? #
This page is generated from a YAML file that you can contribute changes to! It is also validated against a JSON Schema used for taps and targets.