> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sonarx.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake Connectors, SDKs & Integrations

> Snowflake offers a universe of Out-Of-The-Box tools to access data.

## Build with (drivers, SDKs, programmatic APIs)

* **JDBC Driver** — type-4 JDBC for Java/BI apps; 64-bit, Java 8+; multiple JAR flavors.

  <Tip>
    [1. JDBC Driver - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/jdbc/jdbc)

    \
    [2. Downloading/Integrating the JDBC Driver - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-download)
  </Tip>
* **ODBC Driver** — Windows/macOS/Linux installers; PUT/GET support by cloud.

  <Tip>
    [1. ODBC Driver - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/odbc)

    \
    [2. Downloading the ODBC Driver - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/odbc/odbc-download)
  </Tip>
* **Python Connector** — PEP-249 driver; \`pip install snowflake-connector-python

  <Tip>
    [1. Snowflake connector for Python - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/python-connector/python-connector)

    \
    [2. Installing the Python connector - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/python-connector-install)
  </Tip>
* **Node.js Driver** — async JS API; PUT/GET supported from specific versions.

  <Tip>
    [1. Node.js Driver - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/node-js/nodejs-driver)

    \
    [2. Installing the Node.js Driver - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/node-js/nodejs-driver-install)
  </Tip>
* **.NET / Go / PHP PDO** — official drivers for C#, Go (`database/sql`), PHP PDO.

  <Tip>
    [JDBC Driver - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/jdbc/jdbc)
  </Tip>
* **SQL API (REST)** — submit/cancel SQL and fetch results over HTTPS; OAuth/key-pair.

  <Tip>
    [1. Snowflake SQL API - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/sql-api/index)

    \
    [2. Introduction to the SQL API - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/sql-api/intro)
  </Tip>
* **Snowflake REST APIs (resource mgmt)** — OpenAPI endpoints to manage Snowflake objects.

  <Tip>
    [1. Snowflake REST APIs - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api)

    \
    [2. Snowflake REST APIs reference - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference)
  </Tip>

## Connect from (ingest / stream / ELT)

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

<Tip>
  [Snowpipe Streaming Overview - Snowflake Documentation](https://docs.snowflake.cn/en/user-guide/snowpipe-streaming/data-load-snowpipe-streaming-overview)
</Tip>

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

<Tip>
  [Kafka Connector Overview - Snowflake Documentation](https://docs.snowflake.cn/en/user-guide/kafka-connector-overview)
</Tip>

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

<Tip>
  [apache-airflow-providers-snowflake](https://docs.snowflake.cn/en/user-guide/spark-connector-overview)
</Tip>

## Orchestration & DevOps

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

<Tip>
  [1. Apache Airflow Providers Snowflake](https://airflow.apache.org/docs/apache-airflow-providers-snowflake/stable/index.html)

  \
  [2 Apache Airflow Snowflake Connection](https://airflow.apache.org/docs/apache-airflow-providers-snowflake/stable/connections/snowflake.htm)
</Tip>

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

<Tip>
  [Snowflake Terraform Provider - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/terraform)
</Tip>

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

<Tip>
  [1. Managing dbt Projects on Snowflake using Snowflake CLI - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/snowflake-cli/data-pipelines/dbt-projects)

  \
  [2. dbt Projects on Snowflake - Snowflake Documentation](https://docs.snowflake.com/user-guide/data-engineering/dbt-projects-on-snowflake)
</Tip>

## BI & Analytics

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

<Tip>
  [1. Connect to Snowflake in the Power BI service - Microsoft Learn](https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake)

  \
  [2. Snowflake - Microsoft Learn](https://learn.microsoft.com/en-us/power-query/connectors/snowflake)
</Tip>

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

<Tip>
  [Configure OAuth for Snowflake Connections - Tableau Help](https://help.tableau.com/current/server/en-us/config_oauth_snowflake.htm)
</Tip>

***

## “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)**.

<Tip>
  [1. Snowflake connector for Python - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/python-connector/python-connector)

  \
  [2. Node.js Driver - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/node-js/nodejs-driver)

  \
  [3. Snowflake SQL API - Snowflake Documentation](https://docs.snowflake.com/en/developer-guide/sql-api/index)
</Tip>

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

<Tip>
  [1. Kafka Connector Overview - Snowflake Documentation](https://docs.snowflake.cn/en/user-guide/kafka-connector-overview)

  \
  [2. Snowpipe Streaming Overview - Snowflake Documentation](https://docs.snowflake.cn/en/user-guide/snowpipe-streaming/data-load-snowpipe-streaming-overview)
</Tip>

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

<Tip>
  [1. apache-airflow-providers-snowflake](https://docs.snowflake.cn/en/user-guide/spark-connector-overview)

  \
  [2. dbt Projects on Snowflake - Snowflake Documentation](https://docs.snowflake.com/user-guide/data-engineering/dbt-projects-on-snowflake)
</Tip>

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

<Tip>
  [1. Apache Airflow Providers Snowflake](https://airflow.apache.org/docs/apache-airflow-providers-snowflake/stable/index.html)

  \
  [2. Snowflake Terraform Provider - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/terraform)

  \
  [3. dbt Projects on Snowflake - Snowflake Documentation](https://docs.snowflake.com/user-guide/data-engineering/dbt-projects-on-snowflake)
</Tip>

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

<Tip>
  [1. Connect to Snowflake in the Power BI service - Microsoft Learn](https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake)

  \
  [2. Configure OAuth for Snowflake Connections - Tableau Help](https://help.tableau.com/current/server/en-us/config_oauth_snowflake.htm)
</Tip>