SQLite
S
SQLite

target-sqlite (meltanolabs variant)

SQLite is a software library that provides a relational database management system.

SQLite is a popular choice for embedded database systems due to its small size, low memory footprint, and self-contained nature. It is a serverless, zero-configuration, transactional SQL database engine that can be used in a wide variety of applications. SQLite is widely used in mobile applications, web browsers, operating systems, and other software products that require a lightweight, fast, and reliable database system. It supports standard SQL syntax, ACID transactions, and a wide range of data types, including text, integer, real, and blob. SQLite is open-source software and is available under a permissive license, making it a popular choice for developers who want to build high-performance, low-cost applications.

Settings

Database Name

The name of the SQLite database to connect to.

Batch Size

The number of rows to retrieve or modify at a time.

Timestamp Column

The name of the column in the database that contains timestamps for the data.

Meltano Community Connector

SQLite connector is available on Meltano Community. It is built by our growing community of over 5000+ developers. Refer to the Install section below to verify the readiness of this connector.

Why Meltano?
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.