Multi-Factor Authentication (MFA) token caching is typically supported for clients that maintain a

persistent connection or session with Snowflake, such as the ODBC driver and Python connector, to

reduce the need for repeated MFA challenges.

Based on general security practices in

cloud services as of 2021.

Masking policies in Snowflake are designed to protect sensitive information by dynamically hiding or

obfuscating data based on the role of the user executing the query. This helps enforce data privacy

and security by allowing only authorized users to see sensitive information. Masking policies do not

encrypt data but apply rules to limit data visibility, ensuring sensitive data is protected during query

execution without altering the underlying data.

If any compute resources for a virtual warehouse fail to provision during startup, Snowflake will

attempt to restart those failed resources. The system is designed to automatically handle transient

issues that might occur during the provisioning of compute resources. By restarting the failed

resources, Snowflake aims to ensure that the virtual warehouse has the necessary compute capacity

to handle the user's workloads without manual intervention.

Snowflake Documentation on Virtual Warehouses

Fail-safe is a non-configurable feature in Snowflake that provides an additional layer of data

protection beyond Time Travel. Time Travel allows users to access historical data within a

configurable period (up to 90 days), while Fail-safe provides an additional 7-day period during which

Snowflake retains historical data to recover from significant data loss or corruption incidents. This

period is not accessible by users but can be used by Snowflake support to assist in data recovery

efforts.

Snowflake Documentation on Fail-safe and Time Travel

The command to list all the file formats for which a user has access privileges in Snowflake is SHOW

FILE FORMATS. This command provides a list of all file formats defined in the user's current session

or specified database/schema, along with details such as the name, type, and creation time of each

file format. It is a valuable tool for users to understand and manage the file formats available for data

loading and unloading operations.

Snowflake Documentation: SHOW FILE FORMATS

In owner’s rights stored procedures, certain commands are restricted to maintain security and

integrity. The SHOW and DESCRIBE commands are limited because they can reveal metadata and

structure information that may not be intended for all roles.

A Stream object in Snowflake is used for change data capture (CDC), which records data manipulation

language (DML) changes made to tables, including inserts, updates, and deletes3.

To get the most detailed information about individual table storage details in Snowflake, the TABLE

STORAGE METRICS view should be used. This Information Schema view provides granular storage

metrics for tables within Snowflake, including data related to the size of the table, the amount of

data stored, and storage usage over time. It's an essential tool for administrators and users looking to

monitor and optimize storage consumption and costs.

Snowflake Documentation: Information Schema - TABLE STORAGE METRICS View

The Virtual Private Snowflake (VPS) edition offers the highest level of security for organizations with

the strictest security requirements. This edition provides a dedicated and isolated instance of

Snowflake, including enhanced security features and compliance certifications to meet the needs of

highly regulated industries or any organization requiring the utmost in data protection and privacy.

Snowflake Documentation: Snowflake Editions

In Snowflake, overloading refers to the creation of multiple User-Defined Functions (UDFs) with the

same name but differing in the number or types of their arguments. This feature allows for more

flexible function usage, as Snowflake can differentiate between functions based on the context of

their invocation, such as the types or the number of arguments passed. Overloading helps to create

more adaptable and readable code, as the same function name can be used for similar operations on

different types of data.

Snowflake Documentation: User-Defined Functions