Connect SQLite with Bold Data Hub

The Bold Data Hub SQLite connector loads data from a SQLite database file into Bold Reports^®. SQLite is a lightweight, file-based database for storing and managing data locally. SQLite is easy to use and suits small to medium datasets, which makes it ideal for quick setup and offline analysis.

How do I connect to a SQLite database file?

You connect a SQLite database file to Bold Reports^® by choosing the SQLite connector in Bold Data Hub and selecting your file.

Make sure your .db or .sqlite file is ready and accessible.
In Bold Reports^®, go to the Bold Data Hub section.
Choose SQLite from the available connectors.
Browse and select your SQLite database file.
Test the connection and proceed to import your data.

Connection Properties

The SQLite connector in Bold Data Hub reads the following properties from the config section of a YAML file:

filePath: Path to your SQLite database file (e.g., `.db` or `.sqlite`)

Example Configuration

The following Bold Data Hub YAML template shows a complete SQLite extractor configuration:

version: 1.0.1
encrypt_credentials: false
union_all_tables: true
add_dbname_column: false
plugins:
  extractors:
    - name: SQLite
      connectorname: SQLite
      schemaname:
      config:
        filePath: <Path-to-your-SQLite-file>
      properties:
      metadata:
      select:
        - tablename

How do I connect SQLite in Bold Data Hub?

You connect SQLite by creating a pipeline in Bold Data Hub, adding the SQLite connector template, and uploading your file.

Click the Bold Data Hub icon on the Navigation Pane.
Click Add Pipeline and enter a name for the new pipeline.
Select the newly created pipeline and choose the SQLite connector. Double-click it, or click the Add Template option, to add the template.
Click the Upload File button to upload your credentials JSON file.
Copy the file path and paste it into the credentials_path property, if it’s a JSON file.
Click Save and choose the destination to save the pipeline.

Creating a pipeline in Bold Data Hub automatically creates a data source in Bold Reports^®. The Bold Reports^® data source is a live data source to the destination database used in Bold Data Hub.

SQLite - BoldBI

Configuration Parameters

The SQLite template in Bold Data Hub uses these parameters:

Parameters	Description
File Path:	Provide the full local path to your SQLite database file (e.g., .db, .sqlite).
Select:	Tablename(s): Provide one or more table names from which to load data in the BigQuery dataset.

How do I schedule the SQLite pipeline?

You schedule the SQLite pipeline in Bold Data Hub from the schedules tab, or you run it on demand.

To configure interval-based scheduling, click the schedules tab, select the created pipeline, click the schedule icon, and configure the schedule.
For an on-demand refresh, click the Run Now button.
Check the schedule history with the history option and the logs.
Click Logs to see whether the run is completed and the data source is created in Bold Reports^®.
Click the Edit DataSource option to view the created tables.