SQLite
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
default meltanolabs
variant, which is recommended for new
users.
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
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.