Metadata Fields in Snowflake¶
The data contained in metadata fields may be processed outside of your Snowflake Region. It is a customer responsibility to ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data is entered into any metadata field when using the Snowflake Service.
The most common metadata fields are:
Object definitions, such as a policy, an external function, or a view definition.
Object properties, such as an object name or an object comment.
Attention
Within the Snowflake Service, metadata fields are usually populated by CREATE <object> and ALTER <object> statements for a given object. When using these commands, ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data populates any metadata fields.
The following table sets forth the list of potential metadata fields in the Snowflake Service. Metadata is “Usage Data” as defined in our Terms of Service or other agreement between you and Snowflake covering use of the Snowflake Service.
Snowflake updates this table regularly as new features and services are added. If you have questions about how Snowflake tracks data or about sensitive information in the actual query text please contact Snowflake Support.
Category |
Metadata Fields |
Further Reading |
---|---|---|
Object Definitions |
External functions |
|
Policies |
Masking Policies . Network Policies . Row Access Policies . Session Policies |
|
User-defined functions |
||
Object Properties |
Column name |
|
Comment |
See the specific CREATE and ALTER commands for a given object (e.g. CREATE TABLE, ALTER VIEW). |
|
Tag value |
||
Object Types |
Account, including managed account |
|
Alert |
||
Connection |
||
Database |
||
Event table |
||
External function |
||
External table |
||
Failover group |
||
File names in internal stages |
||
Integrations (all types) |
API: Introduction to External Functions Notification: See the current feature list. Security: API Authentication Federated Authentication, Snowflake OAuth, External OAuth, and SCIM. Storage: Loading data , Snowpipe , and Unloading data |
|
Organization |
||
Pipe |
||
Policies |
Masking Policies . Network Policies . Row Access Policies . Session Policies |
|
Procedure |
||
Replication group |
||
Resource monitor |
||
Role |
||
Schema |
||
Secrets |
||
Shares |
||
Stages, internal and external |
||
Stream |
||
Table, including external table |
Understanding Snowflake Table Structures . Working with Temporary and Transient Tables . Working with External Tables |
|
Tag |
||
Task |
||
User |
||
User-defined functions |
||
View, including materialized view |
||
Warehouse |
||
Other Metadata |
Query literals |
|
Schema of files in internal stages |