Establish Snowflake connectivity — SnowPro® Core Certification

The official SNOWFLAKE documentation our Establish Snowflake connectivity practice questions are cited to. Review the primary sources, then practise.

practice 21 questions →

Official references for this objective

Snowflake — Configuring a client, driver, library, or third-party application to connect to Snowflake | Snowflake Documentation

Open the user menu by selecting your user name. From the user menu, select Connect a tool to Snowflake to display the Account Details dialog.
Snowflake — Connecting to Snowflake with the Python Connector | Snowflake Documentation

Versions of the Snowflake Connector for Python prior to 1.8.0 default to fail-close mode. Versions 1.8.0 and later default
Snowflake — Connecting through SnowSQL | Snowflake Documentation

The password is stored in plain text in the config file. You must explicitly secure the file to restrict access.
Snowflake — Managing Snowflake connections | Snowflake Documentation

Command-line parameters Environment variables overriding specific config.toml parameters, such as SNOWFLAKE_CONNECTIONS_MYCONNECTION_PASSWORD Connections defined in config.toml or connections.toml Generic environment variables, such as SNOWFLAKE_USER
Snowflake — Account identifiers | Snowflake Documentation

If the account is located in the AWS US East (Ohio) region, additional segments are required and the URL would be xy12345.us-east-2.aws.snowflakecomputing.com
Snowflake — Connecting to your accounts | Snowflake Documentation

Because Okta does not support underscores in URLs, the underscore in the account name must be converted to a hyphen.
Snowflake — Sign in to Snowflake | Snowflake Documentation

SSO: Users authenticate with a third-party identity provider (IdP) instead of authenticating with Snowflake directly. Examples of IdPs are Okta and Microsoft Entra ID.