Snowflake Connectors, SDKs & Integrations

​

Build with (drivers, SDKs, programmatic APIs)

• JDBC Driver — type-4 JDBC for Java/BI apps; 64-bit, Java 8+; multiple JAR flavors.
  1. JDBC Driver - Snowflake Documentation
  2. Downloading/Integrating the JDBC Driver - Snowflake Documentation
• ODBC Driver — Windows/macOS/Linux installers; PUT/GET support by cloud.
  1. ODBC Driver - Snowflake Documentation
  2. Downloading the ODBC Driver - Snowflake Documentation
• Python Connector — PEP-249 driver; `pip install snowflake-connector-python
  1. Snowflake connector for Python - Snowflake Documentation
  2. Installing the Python connector - Snowflake Documentation
• Node.js Driver — async JS API; PUT/GET supported from specific versions.
  1. Node.js Driver - Snowflake Documentation
  2. Installing the Node.js Driver - Snowflake Documentation
• .NET / Go / PHP PDO — official drivers for C#, Go (database/sql), PHP PDO.
  JDBC Driver - Snowflake Documentation
• SQL API (REST) — submit/cancel SQL and fetch results over HTTPS; OAuth/key-pair.
  1. Snowflake SQL API - Snowflake Documentation
  2. Introduction to the SQL API - Snowflake Documentation
• Snowflake REST APIs (resource mgmt) — OpenAPI endpoints to manage Snowflake objects.
  1. Snowflake REST APIs - Snowflake Documentation
  2. Snowflake REST APIs reference - Snowflake Documentation

​

Connect from (ingest / stream / ELT)

• Snowpipe Streaming — programmatic, low-latency row ingest.

• Kafka Connector — Kafka Connect sink (Confluent/OSS) to Snowflake; supports Snowpipe/Streaming.

• Spark Connector — read/write Spark DataFrames with pushdown to Snowflake.

​

Orchestration & DevOps

• Airflow Provider — hooks/operators/sensors; default conn snowflake_default.

• Terraform Provider — IaC to manage warehouses, roles, grants, etc.; officially supported v2+.

• dbt on Snowflake — dbt projects managed via Snowflake CLI & “dbt Projects on Snowflake.”

​

BI & Analytics

• Power BI — native connector (GA); supports Microsoft Entra SSO and ADBC-based v2.0 impl.

• Tableau — native Snowflake connector; OAuth/PrivateLink options; proxy/warehouse guidance.

​

“Which should I use?” (quick decision flow)

1. Running SQL in an app/service → pick a language driver (Python/Node/.NET/Go/JDBC/ODBC). If you can’t install drivers or want a polyglot HTTP path, use the SQL API (REST).

2. Need sub-second streaming ingest → if you already have Kafka Connect, use the Kafka Connector; otherwise, go direct with Snowpipe Streaming.

3. On Spark/Databricks → Spark Connector for pushdown; consider Snowpark/dbt on Snowflake to move transforms into Snowflake.

7. Orchestrate & manage infra → Airflow for pipelines; Terraform for Snowflake objects; dbt Projects on Snowflake for governed transforms.

8. BI consumption → Power BI or Tableau native connectors with OAuth/SSO as needed.