Share via

Snowflake Tabular (Preview)

  • Reference

The Snowflake Connector provides the ability to surface Snowflake data in Virtual Tables. This connector is in private preview. For enquiries, contact snowflake.connector@service.microsoft.com

This connector is available in the following products and regions:

Service Class Regions
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Connector Metadata
Publisher Microsoft

Authentication

  • Setup instructions can be found here
  • The document linked above contains instructions for both client credential or on-behalf-of flow OAuth flows. The connector only supports the client credential flow.

Known Issues and Limitations

  • Canvas applications are partially supported
    • Supported: When the connector is used to create virtual table, the table can be added to a canvas app.
    • Not Supported: Directly calling the connector from a canvas app is not supported.
  • Power Automate is not supported

Virtual Tables

This connector has full support for virtual tables

General Limits

Name Value
Maximum number of requests being processed by the connector concurrently 50

Creating a connection

The connector supports the following authentication types:
Service principal (Microsoft Entra ID application) Use Microsoft Entra ID application to access your Snowflake database. All regions Shareable
Default [DEPRECATED] This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility. All regions Not shareable

Service principal (Microsoft Entra ID application)

Auth ID: oauthSP

Applicable: All regions

Use Microsoft Entra ID application to access your Snowflake database.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
Tenant string True
Client ID string True
Client Secret securestring True
Resource URL string Snowflake OAuth Audience URL (Resource URL) True
Snowflake SaaS URL string Snowflake URL not including HTTPS prefix (e.g., fnpuupu-in12345.snowflakecomputing.com) True
Snowflake database string Specify the database to connect to True
Warehouse name string Snowflake warehouse to connect to
Role string Snowflake role to connect as
Schema string Snowflake schema to connect to

Default [DEPRECATED]

Applicable: All regions

This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Throttling Limits

Name Calls Renewal Period
API calls per connection 900 60 seconds

Actions

Get object types

This operation lists the available Snowflake object types.

Get object types

Operation ID:
GetTables

This operation lists the available Snowflake object types.

Parameters

Name Key Required Type Description
Server name
 server True string

Name of SQL server
Database name
 database True string

Database name

Returns

Represents a list of tables.

Body
TablesList

Definitions

Table

Represents a table.

Name Path Type Description
Name
 Name string

The name of the table. The name is used at runtime.
DisplayName
 DisplayName string

The display name of the table.
DynamicProperties
 DynamicProperties object

Additional table properties provided by the connector to the clients.

TablesList

Represents a list of tables.

Name Path Type Description
value
 value array of Table

List of Tables