Using Regex to extract decimal numbers from arrays on Snowflake

The column (‘DATA’) I want to extract the decimal from is in the following format:

{
"unit": "Miles",
"value": 59290.6
}

I’ve tried the following code by I get a null…

regexp_substr(DATA, '\{\d+.\d+\}') AS RECORDED_DISTANCE

>Solution :

Do you just mean to access the value element?

select
    data:value as record_distance