Search results

Accessing nested key-values in Snowflake data source

  1. Drag and drop the table which has the Object data type field in Bold BI as shown in the below image.

    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 to create dashboard in Bold BI.

    Save Datasource

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

    Create Expression

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

    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 below image.

    Widget Value

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

    Render Widget

References:

Json Basic Query

Json Data Types