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.
   

   

   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.
   

   

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

   

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

   

   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.
   

   

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

   

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

   

References

Json Basic Query
Json Data Types