transform flattened json into date object in snowfalke

Question

I know how to flatten the below object, but wondering how I can pass the values in as I flatten them to create a date

What I have:

 "dateRange": {
            "start": {
                "month": 9,
                "day": 2,
                "year": 2020
            }

What I want

2020-09-02

user_43992 · Answer

DATE_FROM_PART

DATE_FROM_PART(year,month,day)

or for you object

DATE_FROM_PART(f.value:dateRange:start:year, f.value:dateRange:start:month, f.value:dateRange:start:year)

if the flatten looked like table(flatten(input=> ) f