Source
SnowConvert AI - General Functional Differences
This message is reported when a Correlated Subquery (subquery that refers to a column from the outer query) is located. This type of subqueries can, in some cases, present some functional differences in Snowflake (Working with Subqueries).
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.