Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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();