Skip to content

SqliteSource

SqliteSources hold the connection information to SQLite data sources.

Example

sources:
  - name: sqlite_source
    database: local/file/local.db
    type: sqlite

Attaching other SQLite databases allows you to join models between databases.

sources:
  - name: sqlite_source
    database: local/file/local.db
    type: sqlite
    attach:
      - schema_name: static
        name: static_source
        database: local/static/file/local.db
        type: sqlite

The above source can be then used in a model and the sql for that model might look similar to: SELECT * FROM local AS l JOIN static.data AS sd ON l.static_id=sd.id

Note

Recommended environment variable use is covered in the sources overview.

Attributes

Field Type Default Description
path string None A unique path to this object
name string None The unique name of the object across the entire project.
host string None The host url of the database.
port integer None The port of the database.
database string None The database that the Visivo project will use in queries.
username string None Username for the database.
password string None Password corresponding to the username.
db_schema string None The schema that the Visivo project will use in queries.
type string None
attach Any of: Attachment, array None List of other local SQLite database sources to attach in the connection that will be available in the base SQL query.