FILES

Reads data directly from cloud storage files.

Analyze Syntax

func.files(<path_or_properties>)

Analyze Examples

# FILES is a table function used in FROM clauses
# select(func.files(...))

┌─────────┐
 (table)  
└─────────┘

SQL Syntax

FILES(<path_or_properties>)

SQL Examples

SELECT * FROM FILES('path' = 's3://bucket/data.parquet', 'format' = 'parquet') LIMIT 5;

┌─────────────────┐
 (query results)  
└─────────────────┘