SqliteSource

SqliteSources hold the connection information to SQLite data sources.

Example

SimpleAdditional Attached

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: #/$defs/Attachment, array	None	List of other local SQLite database sources to attach in the connection that will be available in the base SQL query.