合作伙伴身份验证支持

本主题介绍哪些合作伙伴应用程序支持 External OAuth、Snowflake OAuth 和密钥对身份验证。

交互式身份验证支持

适用于人类用户(即,TYPE 设置为 PERSONNULL 的用户)的交互式身份验证使用 授权代码流 (https://datatracker.ietf.org/doc/html/rfc6749#section-4.1)。

下表介绍哪些应用程序支持人类用户使用 External OAuth、Snowflake OAuth 和密钥对身份验证:

备注

人类和服务用户无法使用密钥对身份验证访问 Snowsight。

应用程序

External OAuth

Snowflake OAuth

密钥对身份验证

PowerBI Cloud (BI) (https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake)

**是**(仅支持 Microsoft Entra ID)

PowerBI Desktop (BI) (https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake)

**是**(仅支持 Microsoft Entra ID)

Tableau Cloud (BI) (https://help.tableau.com/current/pro/desktop/en-us/examples_snowflake.htm)

Tableau Server (BI) (https://help.tableau.com/current/pro/desktop/en-us/examples_snowflake.htm)

DBT Cloud (Transform) (https://docs.getdbt.com/docs/cloud/connect-data-platform/connect-snowflake)

DBT Core (Transform) (https://docs.getdbt.com/docs/core/connect-data-platform/snowflake-setup)

`Airflow(工作流程编程)<https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-connect>`_

不适用

不适用

Qlik Sense Cloud (BI) (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Snowflake/Create-Snowflake-connection.htm)

Qlik Sense Desktop (BI) (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Snowflake/Create-Snowflake-connection.htm)

Fivetran (EL) (https://fivetran.com/docs/destinations/snowflake/setup-guide#optionalkeypairauthentication)

Matillion (ELT) (https://docs.matillion.com/data-productivity-cloud/administration/docs/snowflake-key-pair-authentication/)

Informatica (ETL) (https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/snowflake-data-cloud-connector/part-1--getting-started-with-snowflake-data-cloud-connector/connections-for-snowflake-data-cloud/connect-to-snowflake/authentication-typesdwsnowflakev2conn-authentication.html)

`ThoughtSpot(BI – 交互式)<https://docs.thoughtspot.com/software/10.1.0.sw/connections-snowflake-add>`_

Strategy Cloud (BI)

Strategy Workstation/Developer (BI)

服务到服务身份验证支持

适用于服务用户(即,TYPE 设置为 SERVICE 的用户)的服务到服务身份验证使用 客户端凭据流 (https://oauth.net/2/grant-types/client-credentials/)。

下表介绍哪些应用程序支持服务用户使用 External OAuth 和密钥对身份验证:

备注

人类和服务用户无法使用密钥对身份验证访问 Snowsight。

应用程序

External OAuth

密钥对身份验证

PowerBI Cloud (BI) (https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake)

PowerBI Desktop (BI) (https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake)

Tableau Cloud (BI) (https://help.tableau.com/current/pro/desktop/en-us/examples_snowflake.htm)

Tableau Server (BI) (https://help.tableau.com/current/pro/desktop/en-us/examples_snowflake.htm)

DBT Cloud (Transform) (https://docs.getdbt.com/docs/cloud/connect-data-platform/connect-snowflake)

DBT Core (Transform) (https://docs.getdbt.com/docs/core/connect-data-platform/snowflake-setup)

`Airflow(工作流程编程)<https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-connect>`_

Qlik Sense Cloud (BI) (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Snowflake/Create-Snowflake-connection.htm)

Qlik Sense Desktop (BI) (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Snowflake/Create-Snowflake-connection.htm)

Fivetran (EL) (https://fivetran.com/docs/destinations/snowflake/setup-guide#optionalkeypairauthentication)

Matillion (ELT) (https://docs.matillion.com/data-productivity-cloud/administration/docs/snowflake-key-pair-authentication/)

Informatica (ETL) (https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/snowflake-data-cloud-connector/part-1--getting-started-with-snowflake-data-cloud-connector/connections-for-snowflake-data-cloud/connect-to-snowflake/authentication-typesdwsnowflakev2conn-authentication.html)

`ThoughtSpot(BI – 交互式)<https://docs.thoughtspot.com/software/10.1.0.sw/connections-snowflake-add>`_

Strategy Cloud (BI)

Strategy Workstation/Developer (BI)

语言: 中文