We just raised a $30M Series A: Read our story
2021-09-03T04:37:00Z

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

28

Hello, 

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
Guest
11 Answer

author avatar
Community Manager

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


Can you possibly assist @NitinKumar with this question?

2021-09-07T05:32:26Z
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.