📄️ INFER_SCHEMA
Automatically detects the file metadata schema and retrieves the column definitions.
📄️ LIST_STAGE
Lists files in a stage. This allows you to filter files in a stage based on their extensions and obtain comprehensive details about each file. The function is similar to the DDL command LIST STAGE FILES, but but provides you the flexibility to retrieve specific file information with the SELECT statement, such as file name, size, MD5 hash, last modified timestamp, and creator, rather than all file information.
📄️ RESULT_SCAN
Returns the result set of a previous command in same session as if the result was a table.