Connecting to Snowflake

.

Related Topics

• Client Versions & Support Policy

• Client Changes by Version

• Logging into Snowflake

• Quick Tour of the Web Interface

• Web Interface

These topics provide an overview of the Snowflake-provided and 3rd-party tools and technologies that form the ecosystem for connecting to Snowflake. They also provide detailed installation and usage instructions for using the Snowflake-provided clients, connectors, and drivers.

• Overview of the Ecosystem

  • All Partners & Technologies (Alphabetical)

  • Data Integration

  • Business Intelligence (BI)

  • Advanced Analytics

  • SQL Editing / Querying Tools

  • Programmatic Interfaces

• Snowflake Partner Connect

  Instructions for initiating trial connections from your Snowflake account to participating technology partners.

• SnowSQL (CLI Client)

  • Installing SnowSQL

  • Configuring SnowSQL

  • Connecting Through SnowSQL

  • Using SnowSQL

• Snowflake Connector for Python

  • Installing the Python Connector

  • Using the Python Connector

  • Python Connector API

• Snowflake Connector for Spark

  • Overview of the Spark Connector

  • Installing and Configuring the Spark Connector

  • Configuring Snowflake for Spark in Databricks

  • Configuring Snowflake for Spark in Qubole

  • Using the Spark Connector

• Snowflake Connector for Kafka

  Concepts and instructions for the Snowflake Kafka Connector, which allows users to read Kafka messages and insert them as rows into Snowflake tables.

• Node.js Driver

  Instructions for installing, configuring, and using the Node.js driver for Snowflake.

• Go Snowflake Driver

  Introduction to the Go driver for Snowflake, with links to the driver code and documentation on GitHub.

• .NET Driver

  Introduction to the Snowflake .NET driver, with links to the driver code and documentation on GitHub.

• JDBC Driver

  • Java Requirements for the JDBC Driver

  • Downloading / Integrating the JDBC Driver

  • Configuring and Using the JDBC Driver

  • JDBC Driver Diagnostic Service

• ODBC Driver

  • Downloading the ODBC Driver

  • Installing and Configuring the ODBC Driver for Windows

  • Installing and Configuring the ODBC Driver for macOS

  • Installing and Configuring the ODBC Driver for Linux

  • ODBC Configuration and Connection Parameters

  • ODBC Driver API Support

  • ODBC Driver Diagnostic Service

• Client Considerations

  Usage information that applies to all Snowflake-provided clients.

• Diagnosing Common Connectivity Issues

  Instructions for testing issues related to the OCSP checks performed by Snowflake clients and using the Snowflake Connectivity Diagnostic Tool (i.e. SnowCD).

• OCSP Client & Driver Configuration

  Overview of the fail-open and fail-close behavior for all clients, including configuration instructions and settings.

• Obsoleted — sfsql (use SnowSQL instead)

  • Configuring sfsql

  • Starting and Stopping sfsql

  • Using sfsql

  • sfsql Tips and Hints

  • Differences Between sfsql & SnowSQL