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

Snowflake is a cloud-based data warehousing solution for storing and processing data, generating reports and dashboards, and as a BI reporting source. It is used for optimizing costs and using financial data, as well as for migrating data from on-premises to the cloud. The solution is often used as a centralized data warehouse, combining data from multiple sources. Snowflake has helped organizations improve query performance, store and process JSON and XML, consolidate multiple databases...