Skip to main content

Snowflake.Databases

Import data from a Snowflake Computing warehouse.

Syntax​

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

Remarks​

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​

Example #1​

List the tables in a Snowflake warehouse.

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