snowpipe-backed external tables should contain metadata$file_last_modified, whicn returns the last modified timestamp of the staged file the current row belongs to.
This metadata is useful for a use case where we'd like to filter staged files (from an S3 bucket) after a certain cutoff date, and we can't easily infer such date from the file name.
Describe the feature
snowpipe-backed external tables should contain
metadata$file_last_modified, whicn returns the last modified timestamp of the staged file the current row belongs to.This metadata is useful for a use case where we'd like to filter staged files (from an S3 bucket) after a certain cutoff date, and we can't easily infer such date from the file name.