`input_file_name` function

Applies to: check marked yes Databricks SQL Databricks Runtime

Returns the name of the file being read, or empty string if not available.

Syntax

input_file_name()

Arguments

This function takes no arguments.

Returns

A STRING.

If the information is not available an empty string is returned.

The function is non-deterministic.

Examples

> SELECT input_file_name();