Skip to main content

Snowflake

To create a connection with Snowflake, enter the following parameters:

ParameterDescription
Connection NameName to to identify your connection
AccountURL of your Snowflake account, typically in the format
https://<orgname>-<account_name>.snowflakecomputing.com
DatabaseDefault database for reading and writing data
SchemaDefault schema for reading and writing data
WarehouseName of the SQL warehouse to use for the connection
RoleSnowflake role of the user to connect
Authentication methodHow you want to authenticate your Snowflake account

Authentication methods

You can configure your Snowflake connection with one of the following authentication methods:

  • Snowflake OAuth. Prophecy prompts you to sign in with Snowflake.
  • Password. Enter your Snowflake username and use a secret to enter your password.