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
