cloud_files_state table-valued function
Returns the file-level state of an autoloader
Returns a table with the following schema:
path STRING NOT NULL PRIMARY KEY
The path of a file.
size BIGINT NOT NULL
The size of a file in bytes.
create_time TIMESTAMP NOT NULL
The time that a file was created.
discovery_time TIMESTAMP NOT NULL
The time that a file was discovered by CLOUD_FILES
The time that a file was committed to the checkpoint after processing.
NULLif the file is not yet processed.
The time that a file was archived.
NULLif the file has not been archived.