Snowflake

Overview

Snowflake is a cloud-native data platform that provides a fully managed data warehouse, data lake, and data sharing service. It runs on AWS, Azure, and Google Cloud with automatic scaling, near-zero maintenance, and support for semi-structured data formats like JSON, Avro, and Parquet. Snowflake separates compute (virtual warehouses) from storage, allowing independent scaling of each.

Driver

Crate: reqwest
Version: 0.13

Connection fields

Field	Description
Account	Snowflake account identifier, e.g. `xy12345.us-east-1` or `myorg-myaccount`.
Warehouse	Virtual warehouse to use for queries. Stored in the `options` field as `warehouse=NAME`.
Database	Name of the database to connect to.
Schema	Default schema. Stored in `options` as `schema=NAME`.
Role	Snowflake role to assume. Stored in `options` as `role=NAME`.
User	Snowflake username.
Password	Authentication password. Stored in the macOS Keychain.

All connections also support an optional SSH tunnel. Configure the bastion host, port, user, and private key file under the SSH section of the connection form. See SSH tunnels for details.

URI format

Instead of filling in each field individually, you can paste a connection URI into the Paste URI field. Arris parses the URI and populates all fields automatically.

text Connection URI

snowflake://user:password@account/database?warehouse=COMPUTE_WH&role=SYSADMIN&schema=PUBLIC

Cloud provider connection strings from the Snowflake web UI can be pasted directly — Arris extracts the account identifier, database, and other parameters automatically.

Schema browser

Once connected, Arris queries INFORMATION_SCHEMA in the connected database and organizes the schema tree into groups.

The schema tree displays the following object types, grouped by category:

Tables — regular tables and external tables
Views — views and materialized views
Routines — functions and stored procedures
Sequences — sequences
Indexes — indexes

Double-click any table or view to open it in a new tab with browse mode.

Supported SQL commands

Command	Notes
`SELECT`	Query data with `WHERE` filters, `JOIN`s, aggregates, and window functions.
`INSERT`	Insert single or multiple rows.
`UPDATE`	Update existing rows.
`DELETE`	Delete rows.
`CREATE` / `DROP`	Create and drop tables, views, and other schema objects.