SQLite

The SQLite Connection allows for creating and interacting with local DB files or in memory storage. The connection can be used to manage local state in the Intelligence Hub.

Below are details on the connection, input, and output settings and supported features.

Connection Settings

Database

The name of the database file. For example mydatabase.db creates a file in the runtime directory named mydatabase.db. Database can include a path (ex. C:\mydatabase.db). In memory databases, which are not persisted between runs, are also supported by using :memory:.

Input/Output Settings

See JDBC Driver Settings for input and output settings.