How to get key columns from JSON column types?

There are 2 ways to get key columns from JSON column type.

  1. Use Built in “Extract columns” option in the dropdown menu of the JSON column.
  2. Refer a key in json using [Column Name].key in the formula