SnowPro Advanced Data Engineer

Snowpipe loading is most efficient with compressed files of roughly 100–250 MB or larger. For JSON and other semi-structured data, Snowflake recommends extracting elements that contain null values into relational columns before loading and keeping each unique element’s values to a single native type, such as string or number.