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