FILES table function

Description

FILES(...) maps external file locations to queryable rowsets, allowing direct reading of external data in SELECT ... FROM statements.

Syntax

FILES(location_expr, format_expr [, pattern_expr])

A common approach 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 a LOAD DATA scenario, you can also specify the data source using FROM FILES(...).

References

• SELECT statement (MySQL-compatible mode)
• LOAD DATA statement (MySQL-compatible mode)
• Overview of TABLE FUNCTIONS (MySQL-compatible mode)