0

I know this is basic. How do I run a query using snowsql cli client?

I ran the connection line: snowsql -a my_account_name -u my_user_name

i now see my_name#my_role@DatabaseName.(no schema)>

i'm trying to run a query after that. But after I hit return (mac), it just goes to new line and nothing happens.

i keep going through the documentation i see that you can run a stored query by id via the !result command

But how do I add a query to get a queryId?

Can I just run something like, select '1' and see the result?

vbp13
  • 1,040
  • 1
  • 10
  • 20

2 Answers2

2

Sounds like you might just be missing the semi-colon to indicate the end of the query. Try to type select 1; and enter to see if you get results. Running a query is similar to how you would type SQL in the Worksheets tab in the Snowflake Web UI, except you are pressing Enter instead of Run.

To query tables, you can use the fully qualified name like this:

select * from <database.schema.table>;

Alternatively, you can run "use database database_name;" and "use schema schema_name;" to get to the database and schema you want to navigate to and run commands against the tables there.

Here is a quick tutorial that involves SnowSQL if you just want to get more comfortable with the tool: https://docs.snowflake.net/manuals/user-guide/getting-started-tutorial.html

Hope it helps.

Suzy Lockwood
  • 1,050
  • 4
  • 6
1

Make sure you are ending the query with a ';' before hitting return.

To get query id you can run the following query; select * from "SNOWFLAKE"."ACCOUNT_USAGE"."QUERY_HISTORY"; Of course, you can filter results.

Kay
  • 21
  • 1
  • Yes, the semicolon is required. NO, don't try this query. It only works if you have the ability to use the accountadmin role. – Beege Mar 03 '20 at 19:16