Complete list of Table Functions in snowflake

The complete list of Table Functions in Snowflake are as follows. Table functions are functions that produce a collection of rows (either a nested table or a varray) that can be queried like a physical database table.

General
Data Loading
VALIDATE

Data Generation
GENERATOR

Object Modeling
GET_OBJECT_REFERENCES

Semi-structured Queries
FLATTEN

Query Results
RESULT_SCAN

Historical & Usage Information (Information Schema)
Queries
QUERY_HISTORY , QUERY_HISTORY_BY_* ( SESSION | USER | WAREHOUSE ) , EXTERNAL_FUNCTIONS_HISTORY

Warehouse & Storage Usage
DATABASE_STORAGE_USAGE_HISTORY , STAGE_STORAGE_USAGE_HISTORY , WAREHOUSE_METERING_HISTORY

Column-level Security
POLICY_REFERENCES

Data Loading & Transfer
COPY_HISTORY , DATA_TRANSFER_HISTORY , PIPE_USAGE_HISTORY

SCIM
REST_EVENT_HISTORY

User Login
LOGIN_HISTORY , LOGIN_HISTORY_BY_USER

Search Optimization Maintenance
SEARCH_OPTIMIZATION_HISTORY

Author: user

Leave a Reply

Your email address will not be published. Required fields are marked *