A Data Engineer must load JSON output from software into Snowflake by using Snowpipe.
Which recommendations apply to this scenario?
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.
null
Community Discussion