Categories:

# EXTERNAL_TABLE_FILES¶

This table function can be used to query information about the staged data files included in the metadata for a specified external table.

## Syntax¶

EXTERNAL_TABLE_FILES(
TABLE_NAME => '<string>' )


## Arguments¶

Required:

TABLE_NAME => 'string'

A string specifying an external table name.

## Usage Notes¶

• The table function cannot retrieve metadata about staged data files until the external table is refreshed (i.e. synched) to include the data files in its metadata.

• When calling an Information Schema table function, the session must have an INFORMATION_SCHEMA schema in use or the function name must be fully-qualified. For more details, see Information Schema.

## Output¶

The function returns the following columns:

Column Name

Data Type

Description

FILE_NAME

TEXT

Name of source file and relative path to the staged file

REGISTERED_ON

TIMESTAMP_LTZ

Timestamp when the file metadata was added to an external table (i.e. when the external table metadata was refreshed with the file details)

FILE_SIZE

NUMBER

Size of the file (in bytes)

LAST_MODIFIED

TIMESTAMP_LTZ

Timestamp when the file was last updated in the stage

ETAG

HEX

MD5

HEX

MD5 checksum for the file

## Examples¶

Retrieve the metadata stored for all data files referenced by the mytable external table:

select *
from table(information_schema.external_table_files(TABLE_NAME=>'MYTABLE'));