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

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

The Distributed Systems Challenge : Part 1 – Dask

Published on
As part of our Analytics practice, we repeatedly encounter use cases where complex calculations over large datasets are required. In this series, we will compare two distributed computing systems – Dask and Spark – that have become very popular in recent times. To evaluate these, we will select a use case that comes up in…
Categories: Blog

Securing Cassandra CQLSH

Published on
At Data-Aces, we provide managed services running Cassandra for our customers. With more and more attention being given to data security these days, end-to-end encryption of ALL communication is becoming a mandatory requirement. This includes traffic between the Cassandra nodes or from client to the Cassandra cluster. The default config file (Cassandra.yaml) is configured for…
Categories: Blog