We just raised a $30M Series A: Read our story

How to achieve sub-second query performance with JSON data (~1B rows) in Snowflake?



I am using Snowflake for JSON data and we have almost 700 million JSON rows. 

Is it possible to achieve a sub-second performance in Snowflake? I am OK to cluster and flatten the JSON data into structured tables if necessary. 

Thank you.

ITCS user
11 Answer

author avatar
Community Manager

Hi @Anoop Anoop SLK , @Subhrajit Mitra ​and @Yash Mittal

Can you possibly assist @NitinKumar with this question?

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
554,676 professionals have used our research since 2012.