top of page

Blogs

Snowflake – Loading JSON to table in 3 steps

We frequently come across situations where we get a data source in JSON that we need to load into Snowflake. While Snowflake supports JSON data sources, there are some nuances of how the load process works that can take a while to understand and work around. The result is that we ended up spending more time than we initially planned for the tasks. Hopefully this post helps you get there faster! Recently, I was tasked with loading some JSON from the Open FDA API (https://open.

Time Travel on Snowflake: UNDROP to the Rescue

I really like the Time Travel feature in Snowflake. It is very handy and absurdly simple. If you have incorrectly updated one of your Snowflake tables and if you know that your table was in the correct state at 9 am on Sun, Oct 13, 2019, then you can simply run the query: SELECT * FROM TABLE_NAME AT(TIMESTAMP => 'Sun, 13 Oct 2019 09:00:00 -0800'::TIMESTAMP); where -0800 refers to your time zone in relation to UTC. However, this query will not work if you dropped or replaced t

Cassandra Failover and consistency

Apache Cassandra is the always-on NoSQL database that is highly scalable and available. That sounds magical and is in fact true – IF you understand how to configure it correctly ! This article describes an issue we ran into when setting up a multi-DC configuration for Cassandra failover and how it was resolved. Cassandra Configuration Single Region, Dual AZ The diagram below shows the initial system configuration for a cluster deployed across two availability zones (AZ) in t

© 2027 by Data Aces.

Contact

77 Sugar Creek Center Blvd, Suite 600

Sugar Land, Texas 77478

info@data-aces.com

© 2026 by Data Aces.

Be in the Know

Stay ahead with expert insights, industry trends, and practical perspectives on data, AI, and digital transformation—designed to help enterprises make informed, future-ready decisions.

bottom of page