In our previous blog SNOWSQL – I, we introduced you to SnowSQL – a new modern command-line tool. Today we are going to talk about how SnowSQL helps to query data interactively.
SnowSQL works well after its installation, we can make customizations to get full advantage of SnowSQL.
For example, by defining connections in the config file, we can preset my environment (account, warehouse, database, etc…) and don’t have to worry about connection strings or exposed passwords.
To keep track of which environment we are in, we can customize the prompt to show only the information we need.
SnowSQL also includes very powerful line editing commands to simplify the manipulation of queries. All the usual shortcuts are there: CTRL-R to search the history and Arrow keys to navigate up/down in history. By using the
!edit command, we can modify large queries.
Queries taking a long time to run can be executed concurrently to avoid disrupting workflow. To run a query in the background, just add
> after the semicolon.
We can then check all the queries that are running or finished by using the
!QUERIES command. With variable_substitution turned on, the
!queries command will bind a variable to each query ID.
We can abort any running query by writing
!abort &. To get the result of a query, I use
!result &. If the query is running, it will wait until the result comes back. If the query is finished, it will just fetch the result, so we can always go back to previous queries.