Skip to main content

Connector - Snowflake

Wvlet supports connecting to Snowflake databases via JDBC.

Connecting to Snowflake​

To connect to Snowflake, create a profile in ~/.wvlet/profiles.json. The file is parsed as JSONC, so // line comments, /* block comments */, and trailing commas are allowed.

~/.wvlet/profiles.json
{
  "profiles": [
    {
      "name": "snowflake",
      "type": "snowflake",
      "user": "(your Snowflake user name)",
      "password": "(your password)",
      "host": "(your account identifier, e.g., myorg-myaccount)",
      "catalog": "(your database name)",
      "schema": "(your schema name, e.g., PUBLIC)",
      "properties": {
        "warehouse": "(your warehouse name)",
        "role": "(your role name, optional)"
      }
    }
  ]
}

Then connect using the profile:

$ wv --profile snowflake
wv>

Configuration Parameters​

  • host: Your Snowflake account identifier (e.g., myorg-myaccount). The connector will automatically append .snowflakecomputing.com.
  • user: Your Snowflake username
  • password: Your Snowflake password
  • catalog: The database name to connect to
  • schema: The schema name (default: PUBLIC)
  • properties.warehouse: (Optional) The virtual warehouse to use
  • properties.role: (Optional) The role to use for the session

Example Usage​

wv> from information_schema.tables
    where table_schema = 'PUBLIC'
    select table_name, table_type

Notes​

  • Snowflake uses ARRAY_CONSTRUCT() for array creation and OBJECT_CONSTRUCT() for object/map creation
  • Wvlet will automatically translate standard SQL constructs to Snowflake-compatible syntax
  • Ensure your Snowflake account has the appropriate permissions and network access configured