Connecting to Snowflake

.

Related Topics

• Client Versions & Support Policy

• Client Changes by Version

• Logging into Snowflake

• Quick Tour of the Web Interface

• Classic Web Interface

• Redirecting Client Connections

These topics provide general information about the 3rd-party tools and technologies that form the extended ecosystem for connecting to Snowflake.

They also provide detailed installation, configuration, and usage information for the Snowflake-provided clients (CLI, connectors, and drivers) that form the core of the Snowflake ecosystem.

• Snowflake Ecosystem — Overview of the 3rd-party tools and technologies, as well as the Snowflake-provided clients, in the Snowflake ecosystem:

  • All Partners & Technologies (Alphabetical)

  • Data Integration

  • Business Intelligence (BI)

  • Machine Learning & Data Science

  • Security, Governance & Observability

  • SQL Development & Management

  • Native Programmatic Interfaces

• Snowflake Partner Connect — List of Snowflake partners who offer free trials for connecting to and using Snowflake; includes instructions for starting a trial through Snowsight and the classic web interface. More detailed instructions and trial terms are provided by the individual partners.

  
  

• Downloading Snowflake Clients, Connectors, Drivers, and Libraries — Instructions for downloading the installation packages for clients, connectors, drivers, and libraries.

  
  

• General Configuration (All Clients) — General configuration instructions that apply to all Snowflake-provided clients (CLI, connectors, and drivers):

  • Viewing Snowflake Client Versions

  • SnowCD (Connectivity Diagnostic Tool)

  • Allowing Hostnames

  • Limits on Query Text Size

  • OCSP Configuration

  • SQL Statements Supported for Preparation

• SnowSQL (CLI Client) — Detailed instructions for installing, configuring, and using the Snowflake command-line client:

  • Installing SnowSQL

  • Configuring SnowSQL

  • Connecting Through SnowSQL

  • Using SnowSQL

• Snowflake Extension for Visual Studio Code - Detailed instructions for installing, configuring and using the Snowflake SQL Extension for Visual Studio Code.

  
  

• Drivers - Detailed instructions for installing, configuring, and using the Snowflake-provided drivers Python, JDBC, ODBC, and other clients:

  • Go Snowflake Driver

  • JDBC Driver

  • .NET Driver

  • Node.js Driver

  • ODBC Driver

  • PHP PDO Driver for Snowflake

  • Snowflake Connector for Python

• Using Snowflake with Kafka and Spark - Detailed instructions for installing, configuring, and using the Snowflake-provided connectors for Spark and Kafka:

  • Snowflake Connector for Kafka

  • Snowflake Connector for Spark