Links
Comment on page

SQLite

Connect & Ingest data from / to a SQLite database

Sling CLI Setup

The following credentials keys are accepted:
  • instance (required) -> The local file path, HTTP or S3 url of the database file
  • access_key_id (optional) -> The Access Key ID to access the bucket (if providing a S3 url)
  • secret_access_key (optional) -> The Secret Key to access the bucket (if providing a S3 url)
  • endpoint (optional) -> The S3 endpoint hostname for non-AWS providers (if providing a S3 url). Examples: nyc3.digitaloceanspaces.com, a345678c73f3e8bddd084cb125876543.r2.cloudflarestorage.com, etc.
Here are examples of setting a connection named SQLITE. We must provide the type=sqlite property:
# for local files
$ sling conns set SQLITE type=sqlite instance=/path/to/file.db
# for HTTP
$ sling conns set SQLITE_HTTP type=sqlite instance=https://<url>
# for S3
$ sling conns set SQLITE_S3 type=sqlite instance=s3://<bucket>/<key> access_key_id=<access_key_id> secret_access_key=<secret_access_key>
# Or use url (only for local files)
$ sling conns set SQLITE url=sqlite:///path/to/file.db

Environment Variable

export SQLITE='sqlite:///path/to/file.db'

Sling Env File YAML

See here to learn more about the sling env.yaml file.
connections:
SQLITE:
type: sqlite
instance: <instance>
If you are facing issues connecting, please reach out to us at [email protected] or open a Github Issue here.
Last modified 28d ago