SQL Notebook (logo)

READ_FILE Function

Reads a file line-by-line and returns it in a table. This function is used in the FROM clause of a SELECT statement and can participate in JOINs as if it were a table.

Syntax

READ_FILE(file-path, [file-encoding])

Arguments

Return Value

A table with the following columns:
Column name Example value
number 0
line "First line of the file"

Examples