top of page

Blogs
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

niket.b
Nov 12, 20192 min read
Â
Â
Â
Cqlsh with SSL: Securing Cassandra Cqlsh
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. This means, cqlsh with SSL is also a requirement. The default config file (Cassandra.yaml) is configured for normal, unencrypted communication between clients a

Naren Gokul
May 13, 20192 min read
Â
Â
Â
bottom of page
