Comment on page
SQLite
Connect & Ingest data from / to a SQLite database
The following credentials keys are accepted:
instance
(required) -> The local file path, HTTP or S3 url of the database fileaccess_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
export SQLITE='sqlite:///path/to/file.db'
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