FILES table function

Purpose

FILES(...) is used to map external file locations into queryable rowsets, allowing external data to be read directly in SELECT ... FROM statements.

Syntax

FILES(location_expr, format_expr [, pattern_expr])

The common writing method is as follows:

SELECT * FROM
FILES(
  location = '/data/',
  format (TYPE = 'csv', field_delimiter = ',', parse_header = true),
  pattern = 'datafiles$'
);

Parameters

• location_expr: the location of external data.
• format_expr: The file format, typically CSV, PARQUET, or ORC.
• pattern_expr: Optional. Filters files by file name pattern.

Usage instructions

• FILES(...) can be used directly in the FROM clause of a SELECT statement.
• In LOAD DATA scenarios, you can also specify the data source using FROM FILES(...).

References

• SELECT Statement (Oracle-compatible mode)
• LOAD DATA Statement (Oracle-compatible mode)
• Overview of TABLE FUNCTIONS (Oracle-compatible mode)