Extract attribute from a JSON column with SQL

json_attribute.sql

--
-- NOTE: this will just give you the original data if the attribute is not present.
-- You might need to wrap it in an IF somehow if it's not always there.
--
SELECT
  substring_index(substring_index(TABLE.JSON_COLUMN, '"ATTRIBUTE_TO_EXTRACT": "', -1), '",', 1)
from TABLE.JSON_COLUMN

-- If the JSON data looks like this: {"key":"value"} instead of this: {"key": "value"} (no space after colon),
-- you'll need to use this slightly modified version:
SELECT
  substring_index(substring_index(TABLE.JSON_COLUMN, '"ATTRIBUTE_TO_EXTRACT":"', -1), '",', 1)
from TABLE.JSON_COLUMN