Search results

Accessing nested key-values in Snowflake data source

  1. Drag and drop the table that contains the Object data type field in Bold BI, as shown in the image below.

    Object Field

    NOTE: The object datatype will be hidden on data preview but can be accessed by creating expressions in Bold BI.

  2. Save the data source and continue creating the dashboard in Bold BI.

    Save Datasource

  3. Drag and drop the grid widget, then click on the assign data section to begin creating expressions.

    Create Expression

  4. Press the expressions button and add the JSON path value as shown in the image below.

    Expression Button

    To remove double quotes from the parsed JSON values, you need to cast a data type along with the JSON path, as shown in the following image.

    JSON Path

  5. Assign values to the widget as shown in the image below.

    Widget Value

  6. The final rendered widget on the dashboard is as shown in the image below.

    Render Widget

References:

Json Basic Query

Json Data Types