There are some minor glitches here and there, but the Snowflake teams seems to work hard to get those removed. the products is quite new, so it is not as mature as some of its competitors.There’s a command-line interface though, for the die-hards among us. You can connect to Snowflake with the browser and there you have worksheets where you can run SQL statements. Aqua Data Studio or DBeaver are some examples. You need to use 3rd party tools which support Snowflake or ODBC connectors. There’s no SQL Server Management Studio (or Operations Studio) equivalent. there is no client made by Snowflake itself. The best performance is observed with ELT scenarios and OLAP-type queries. OLTP queries can be (much) slower compared with SQL Server or other relational databases. If you’re wondering, Snowflake is ACID compliant. On an XS warehouse, I’ve inserted 36 million rows into a table in about half a minute.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |