SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ64

Performance, Cost, and Resource Optimization

Data is imported and stored as JSON in a VARIANT column. Query performance was satisfactory, but poor query performance has recently been reported.

What could be the cause?

Explanation

Snowflake does not extract a semi-structured element into columnar storage when that element contains even one JSON null. Queries against a non-extracted element must scan and traverse the complete JSON structure for each row, which degrades performance. Considerations for semi-structured data stored in VARIANT

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!