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. SeeSSH tunnels for details.
URI format
Instead of filling in each field individually, you can paste a connection URI into thePaste URI field. Arris parses the URI and populates all fields automatically.
snowflake://user:password@account/database?warehouse=COMPUTE_WH&role=SYSADMIN&schema=PUBLICCloud 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, JOINs, 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. |