JSON

JSON is a lightweight text format used to store and exchange data. It is widely used in web APIs and applications because it is simple and structured. It is easy for humans to read and write, and easy for machines to parse and generate.

Example Configuration

version: 1.0.1
encrypt_credentials: false
union_all_tables: true
add_dbname_column: false
use_snake_casing: true
plugins:
  extractors:
  - name: FileSystem
      connectorname: FileSystem
      schemaname:
      config:
      properties:
        storage: local
        type: json
        filePath: C:\BoldServices\app_data\elt\connectors\mockdata.json
      metadata:
      select:

Configure the Bold Data Hub to connect JSON

1. Click the Data Hub icon on the Navigation Pane.

2. Click Add Pipeline and provide the new pipeline’s name.

3. Select the newly created pipeline and add the JSON template.

4. Click the “Upload File” button to upload your JSON file.

5. Copy the filepath and replace in filePath property.

6. Click Save and choose the desired destination to save the pipeline.

7. Creating a Pipeline in Bold Data Hub automatically creates a Data Source in Bold BI. The Bold BI Data Source is a live data source to the destination database used in Bold Data Hub. For more information on the relationship between Bold Data Hub Pipeline and the associated Data Sources in Bold BI , please refer to Relationship between Bold Data Hub Pipeline and Associated Data Sources in Bold BI

Schedule Bold Data Hub Job

1. To configure interval-based scheduling, click on the schedules tab and select the created pipeline and click on the schedule icon and configure it.

2. For on-demand refresh, click Run Now button.

3. The Schedule history can be checked using the history option as well as logs.

4. Click on Logs to see if the run is completed and data source is created in Bold BI.

5. Click Edit DataSource Option to view the created tables.