Load local files with the Bold Data Hub FileSystem connector

The Bold Data Hub FileSystem connector streams files from the local filesystem into Bold Reports^® by using the reader source.

Which file types does the FileSystem connector support?

The Bold Data Hub FileSystem reader source supports these file types:

Csv files
Excel files
Json files
yaml files

Example Configuration

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

version: 1
encrypt_credentials: false
plugins:
  extractors:
    - name: FileSystem
      connectorname: FileSystem
      config:
      properties:
        type: <csv/excel/jsonl>
        filepath: <Paste the copied file path>
        # sheetname is required for excel type
        sheetname:

How do I connect FileSystem, CSV, Excel, JSON, or YAML files in Bold Data Hub?

You connect local files by creating a pipeline in Bold Data Hub, adding a file connector template, and pointing the filePath property to your uploaded 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 Filesystem / CSV / Excel / JSON / YAML connector. Double-click it, or click the Add Template option, to add the template.
Click the Upload File button to upload your Excel or CSV file.
Copy the file path and paste it into the filePath property. If it’s an Excel file, add the sheet name. Otherwise, remove the sheet name if you use the Filesystem connector.
Click Save and choose the destination to save the pipeline.
The pipeline is saved and starts automatically. Click Logs to see whether the run is completed and the data source is created in Bold Reports^®.

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.

FileSystem - DataHub

How do I schedule the FileSystem pipeline?

You schedule the FileSystem 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.