SQLite
Connect a SQLite database file for federated analysis. The file's tables are mounted into the query engine and can be joined with datasets from other connectors.
When to use
- A self-contained SQLite database exported from an application.
- A lightweight analytical dataset distributed as a single
.sqlite/.dbfile.
How the file is provided
SQLite is a single-file database, so Datyo needs access to that file. Two modes are available depending on where you run Datyo:
- Object storage (managed service): the file lives in an S3-compatible bucket, and Datyo reads it using the storage credentials you provide. This is the mode used on datyo.ai.
- Local file path (desktop / self-hosted): the connector reads the file directly from a filesystem path. This mode is not available on the managed service — see Managed vs. self-hosted.
For a one-off file, the file upload flow is often simpler than configuring object storage.
Connection settings
Object-storage mode
Provide the object-storage access credentials — vendor preset, endpoint, region, access keys, URL style, SSL — plus:
| Field | Required | Description |
|---|---|---|
| Bucket | Yes | The bucket that holds the database file. |
| Object path | Yes | The key of the file within the bucket, e.g. data/app.sqlite. |
Local file path (desktop / self-hosted)
| Field | Required | Description |
|---|---|---|
| File path | Yes | Absolute path to the .sqlite / .db file in the environment where Datyo runs. |
Capabilities
- Execution model: Federated. SQLite tables can be joined with datasets from other connectors.
- Access: Read-only. The file is opened without modification.
- Views: Both tables and views defined in the file are available for import.
- Environment: Object-storage mode works everywhere; local file path is desktop / self-hosted only.
Troubleshooting
- File not found or empty — verify the bucket and object path (or the local file path) and that the credentials grant read access to that object.
- A view is missing — re-sync; both tables and views are listed once the file is read.