Snowflake

Connect to Snowflake in Team Edition, configure the driver, and manage your database.

To get started, click Connection in the toolbar, select New Connection, then pick the Snowflake driver. For details, see Creating a connection.

Note

The desktop version of Team Edition also supports advanced authentication methods, SSH/SSL/AWS SSM/Kubernetes/Proxy connections, and driver configuration. See Snowflake in Team Edition desktop.

Connection settings

The connection dialog is organized into tabs. Here's what each one covers:

Tab	Description
Main	Core connection settings: host, authentication, database list options, and expert settings.
Driver properties	Snowflake JDBC driver settings.
SSH tunnel	SSH tunnel configuration.
Access	User and team access control for this connection.
AI	AI assistant and MCP server settings.

Main

Connection

Field	Description
Driver	Auto-filled based on the selected driver type.
Host	If you are connecting via host, enter the host address of your Snowflake database here.
Port	Enter the port number for your Snowflake database. The default Snowflake port is 443.
Database	Enter the name of the Snowflake database you want to connect to.

Authentication

Field	Description
Authentication	Choose the authentication method for the connection: - Username/password - Private key - Snowflake OAuth - SSO (Deprecated)
Save credentials	Saves credentials so all users with access to this connection can use them without entering them manually. Learn more

Default connection view

Note

This section is available only for shared connections. For details, see Connection name and description.

Option	Description
Simple / Advanced	Sets the default view for this connection in the database navigator.
Show system objects	Shows system objects in the database navigator.

Info

For more details on connection view, see Simple and Advanced View

Secret parameters

Team Edition supports various cloud-based secret providers to retrieve database credentials.

Note

This tab is available if Enable Secret Management is enabled in Settings -> Administration -> Server Configuration. Learn more

Settings

Field	Description
Warehouse	Enter the name of the virtual warehouse to use for query execution.
Schema	Enter the name of the schema that contains your tables and views.

Expert settings

Field	Description
Keep-alive interval (seconds)	Interval (seconds) for sending a signal to maintain the connection open during user inactivity.
Auto-commit	Determines if each SQL statement is committed automatically upon execution.
Read-only connection	Prevents any write operations on this connection.
Default catalog	Specifies the default database to be selected once the connection is established.
Default schema	Indicates the default schema to be used within the selected database.

Connection name and description

Field	Description
Connection name	Assign a specific name to the connection for easier identification.
Project	Choose where to store the connection: - Private - only you can access it - Shared - available to other users
Description	Add descriptions for your connection for better understanding.

Driver properties

Adjust Snowflake JDBC driver settings that affect performance, compatibility, and connection behavior. Edit values directly in the table, or add custom ones with + Add property.

Info

For a full list of available properties, see the Snowflake JDBC documentation.

Secure connections

Team Edition supports SSH connections to Snowflake. For setup details, see SSH configuration.

Access

Control which users and teams can use this connection. Grant access by selecting the checkbox next to a user or team name.

Switch to the Shared project to enable the Access tab.

Info

For information on managing users and teams, see Users and Teams.

AI

Enable Transfer information to AI vendor to let the AI assistant use this connection's schema and data when generating SQL suggestions.

Note

This tab is only available if AI Integration is enabled in Settings -> Administration -> Server Configuration. For information on setting up AI integration, see AI assistant setup.

Tip

You can also expose this connection as an MCP server for external AI clients. For setup details, see MCP server.

Supported objects

Team Edition lets you view and manage a wide range of Snowflake objects:

• Databases
• Schemas
  • Tables
  • Columns
  • Unique Keys
  • Foreign Keys
  • References
  • Views
  • Materialized Views
  • Procedures
  • Sequences
  • Stages
  • Pipes
  • Streams
  • Tasks
• Data types

Note

Table elements like columns, indexes, and constraints appear in the Database Navigator tree only if this option is enabled in Database navigator settings

Additional features

Snowflake specific support

Category	Feature
Task management	Automate workflows with Tasks and Streams.
Access control	Role-based Access Control (RBAC).

Tools and integrations

Category	Feature
Data Transfer	Data Import.
	Data Export.
Data Visualization	ERD guide
Administration	Audit logging