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 Cloud Connector

SQLite connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Why Meltano?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
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.