This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
input_file_name functionApplies to: 
Databricks SQL Databricks Runtime
Returns the name of the file being read, or empty string if not available.
This function is not available on Unity Catalog.
In Databricks SQL and Databricks Runtime 13.3 LTS and above this function is deprecated. Please use _metadata.file_name.
input_file_name()
This function takes no arguments.
A STRING.
If the information is not available an empty string is returned.
The function is non-deterministic.
> SELECT input_file_name();
Documentation
Read CSV files - Azure Databricks
Learn how to read CSV files using Azure Databricks.
View frequent queries and users of a table - Azure Databricks
Use Catalog Explorer to view frequent queries and users of a table to help gain insight into how to use table data in Azure Databricks.
Learn how to read data from text files using Azure Databricks.