Table Functions This page provides reference information for the table functions in TiDB Cloud Lake. Table functions return a set of rows (similar to a table) and can be used in the FROM clause of a query.
Data Schema & File Inspection Function Description Example INFER_SCHEMA Detects file metadata schema and retrieves column definitions SELECT * FROM INFER_SCHEMA(LOCATION => '@mystage/data/')INSPECT_PARQUET Inspects the structure of Parquet files SELECT * FROM INSPECT_PARQUET(LOCATION => '@mystage/data.parquet')
Stage & Query Management Function Description Example LIST_STAGE Lists files in a stage SELECT * FROM LIST_STAGE(LOCATION => '@mystage/data/')RESULT_SCAN Retrieves the result set of a previous query SELECT * FROM RESULT_SCAN(LAST_QUERY_ID())
Data Generation Function Description Example GENERATE_SERIES Generates a sequence of values SELECT * FROM GENERATE_SERIES(1, 10, 2)
Function Description Example FLATTEN Transforms nested JSON or array data into tabular format SELECT * FROM FLATTEN(INPUT => parse_json('[1,2,3]'))
Function Description Example SHOW_GRANTS Shows granted privileges SELECT * FROM SHOW_GRANTS()SHOW_VARIABLES Shows system variables SELECT * FROM SHOW_VARIABLES()STREAM_STATUS Shows stream status information SELECT * FROM STREAM_STATUS('mystream')TASK_HISTROY Shows task execution history SELECT * FROM TASK_HISTROY('mytask')POLICY_REFERENCES Returns associations between security policies and tables/views SELECT * FROM POLICY_REFERENCES(POLICY_NAME => 'mypolicy')TAG_REFERENCES Returns tags assigned to a database object SELECT * FROM TAG_REFERENCES('mydb.mytable', 'TABLE')
Storage Engine Functions Iceberg Integration Function Description Example ICEBERG_MANIFEST Shows Iceberg table manifest information SELECT * FROM ICEBERG_MANIFEST('mytable')ICEBERG_SNAPSHOT Shows Iceberg table snapshot information SELECT * FROM ICEBERG_SNAPSHOT('mytable')
Anonymization Function Description Example OBFUSCATE dataset anonymization SELECT * FROM OBFUSCATE(users)