Snowflake Tabular (Preview)

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