input_file_name function

Applies to: Databricks SQL Databricks Runtime

Warning

This function is not available on Unity Catalog.

In Databricks Runtime 13.3 LTS and above this function is deprecated. Use _metadata.file_name.

In Databricks SQL and Databricks Runtime 17.3 LTS and above this function is no longer supported.

Use _metadata.file_name instead.

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 and may return inaccurate results. Use _metadata.file_name instead for reliable results.

Examples

> SELECT input_file_name();

Related functions

• _metadata