Snowflake.Databases

Snowflake.Databases is a Power Query M function that imports data from a Snowflake Computing warehouse, returning a table listing the tables in the warehouse. It allows for additional control options such as Role name for connection, whether to generate navigation properties, and specifying connection and command timeouts.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Snowflake.Databases(
   server as text,
   warehouse as text,
   optional options as nullable record,
) as table

Description

Returns a table listing the tables in the Snowflake Computing warehouse located at server. An optional record parameter, options, may be specified to control the following options:

• Role: A text value to use as the Role name for the connection.
• CreateNavigationProperties: A logical (true/false) value that sets whether to generate navigation properties on the returned values (default is true).
• ConnectionTimeout: The number of seconds to wait for network responses from Snowflake.
• CommandTimeout: The number of seconds to wait for a query to execute.

Examples

List the tables in a Snowflake warehouse.

Snowflake.Databases( "contoso.snowflakecomputing.com", "CONTOSO_WH" )

Related articles

Learn more about Snowflake.Databases in the following articles:

• Query Folding on Native Queries
  This article delves into using Query Folding for Native Queries. It also provides a list of connectors that currently supports this. » Read more
• Snowflake Connector
  This article provides information on the Snowflake connector. » Read more

Contribute » | Contributors: Rick de Groot