Cassandra Consistency and Failover – Part 2

Published on
In Part 1 of this article, we saw how to configure Apache Cassandra across multiple Datacenters (DCs) as well as the clients for Cassandra solution availability. This ensures that if sufficient nodes in one DC were unavailable (or the entire DC went down), clients would seamlessly failover to the other DC. When the failed DC…
Categories: Blog

Snowflake – Loading JSON to table in 3 steps

Published on
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…
Categories: Blog

Time Travel on Snowflake: UNDROP to the Rescue

Published on
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 *…
Categories: Blog

Cassandra Failover and Consistency

Published on
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…
Categories: Blog

Snowflake Database Recovery

Published on
If you google the word 'snowflake' for the first time, you will likely get references to the 'it insult' word,  Taiwanese dessert, a crystal of snow, etc.  Once you find that Snowflake is the hot new data warehouse in the cloud, your subsequent searches are likely to be more productive in terms of digging up…
Categories: Blog