Read more #7 Fast CloneĮven cooler than UNDROP is the fast clone feature. ![]() Now that is a huge time (and life) saver. No need to wait while all that data is pulled back in. No need to reload last night’s backup to do the restore. ![]() With UNDROP in Snowflake you can recover a table instantaneously with a single command: So why is this cool? It means that whatever BI or ETL tool you use today, if it can talk over JDBC, you can connect it to Snowflake. After getting my favorite data modeling tool, Oracle SQL Developer Data Modeler (SDDM), installed on my new Mac, I was able to configure it to connect to my Snowflake demo schema using JDBC and reverse engineer the design. I had no real clear concept of how I would connect to a data warehouse in the cloud so this was good news. Read more #9 Ability to connect with JDBCĪgain seems like a no brainer but very important. It may seem minor to some, but it sure is convenient to be able to pull up the results from a previous query without having to execute the query a second time. Once you execute a query, the result set will persist for 24 hours (so you can go back and check your work). #10 Persistent results sets available via History So for this post I am going to do a quick rundown of some of the coolest features I have learned about so far. ![]() I have learned a ton about the product and what it means to be an Elastic Data Warehouse in the Cloud. In that time, I have run the demo, spoken at several trade shows, and written a few blogs posts. I have now been with Snowflake Computing for a little over two months (my how time flies).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |