SQLite
Ingest data from a SQLite database file with a SQL query.
The SQLite connector ingests data from a SQLite database file. You
upload the .sqlite file and give it a query; the rows it returns become
a table in Gaur.
No secret needed
SQLite is configless, like file upload. The data comes from the file you upload, so there are no credentials to store as a secret.
Ingest a table
Choose the SQLite connector
In the Ingestion area, pick SQLite and upload your .sqlite database
file.
Write the query
Provide a SELECT query to run against the uploaded database. Its result
set becomes the table, so pick columns, join, and filter in the query.
Name the table and declare its primary key
Name the resulting table and declare its primary key.
Gaur runs the ingestion as a background job, infers the schema, and creates the table.
Refreshing
Because SQLite is a file rather than a live connection, refreshing means uploading a new database file. SQLite tables support full and append refreshes:
- Full: re-upload the file; Gaur re-runs the query and replaces the table.
- Append: re-upload a file and provide a query whose rows are added to the table.
Incremental refresh isn't available for SQLite (there's no live cursor to track between uploads). See Refreshes.