The Snowflake database supports standard SQL, including a subset of ANSI SQL-99 and the ANSI SQL-2003 analytic extensions. Snowflake also supports common variants for a number of commands where those variants do not conflict with each other.
Using the Snowflake Web Interface
The Snowflake web interface includes a graphical SQL client, accessible from the Worksheet tab.
Using the Snowflake Command-Line Client
Snowflake provides a command-line client, SnowSQL, downloadable from the Snowflake web interface.
Using Other SQL Clients
Snowflake has not done extensive testing with other SQL clients, but most clients that can use a standard ODBC or JDBC driver should work with Snowflake.