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 tableDescription
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" )