GENERATE_SERIES
Learn how to use the GENERATE_SERIES table function in PlaidCloud Lakehouse. Generates a dataset starting from a specified point, ending at another...
Table Functions
This section provides reference information for the table-related functions in PlaidCloud Lakehouse.
INFER_SCHEMA
Learn how to use the INFER_SCHEMA table function in PlaidCloud Lakehouse. Automatically detects the file metadata schema and retrieves the column definitions.
INSPECT_PARQUET
Learn how to use the INSPECT_PARQUET table function in PlaidCloud Lakehouse. Retrieves a table of comprehensive metadata from a staged Parquet file,...
LIST_STAGE
Learn how to use the LIST_STAGE table function in PlaidCloud Lakehouse. Lists files in a stage. Includes detailed syntax, examples, and usage reference.
RESULT_SCAN
Learn how to use the RESULT_SCAN table function in PlaidCloud Lakehouse. Returns the result set of a previous command in same session as if the result was a...
SHOW_GRANTS
Learn how to use the SHOW_GRANTS table function in PlaidCloud Lakehouse. Lists privileges explicitly granted to a user, to a role, or on a specific object.
STREAM_STATUS
Learn how to use the STREAM_STATUS table function in PlaidCloud Lakehouse. Provides information about the status of a specified stream, yielding a...
TASK_HISTORY
Learn how to use the TASK_HISTORY table function in PlaidCloud Lakehouse. Displays task running history given variables. Includes syntax and examples.