Source
How to: Query Semi-Structured Data in Snowflake
ISSUE: This article details how to query semi - structured data in Snowflake. It also details accessing individual fields, type - casting and use of FLATTEN function.
FL_GET_CONTENT_TYPE
Returns the content type (also known as the MIME type) of a FILE.