Download the latest version, 4.3.4 or higher comes automatically with the Snowflake JDBC driver.My go to SQL client is DBeaver, as it is open source and it supports most SQL database. Using a SQL ClientĪs Snowflake UI is not very friendly for auto-complete and field suggestion, as well as formatting, you can use a SQL client of your choice to connect to the database. Be aware of repeated executions as Snowflake caches result. This is also the place that tells you if in your specific query is better to use a temporary table or a CTE. This will allow you to optimise your query structure and write your query more efficiently.Įvery analyst should keep an eye on the execution plan. This is a really good feature of the web UI, as you can check the performance for every user / warehouse and see what are the most expensive nodes in the execution plan of your query. Snowflake is well aware of the limitations of the UI and recently acquired Numeracy, to improve it. I would use the UI for database exploration: you can search tables by name, preview data, and see catalogs, tables and columns in your database or if do some basic row count or select all of certain tables. I wouldn’t recommend writing complex scripts in here, because you don’t have autocomplete, and you can just place the SQL element (table, column, etc.) where your cursor is placed. Most notable feature of the Worksheets is that you can save, load and delete scripts and keep them saved in your area – without worrying of saving before logging-out as all the scripts are automatically saved. You can find all the details on how to use it here. The first and easiest option is to use the web UI that comes for free once your Snowflake administrator have set you up with a username and password and given you the link to access it. ![]() My company is in the process of moving from an Amazon Redshift to a Snowflake database, and without going into the consideration of pros and cons of each, let’s see how to query data from Snowflake. Menu Querying a Snowflake Database Snowflake
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |