How can I list the contents of a CSV file from Azure Gen2 storage in Azure Databricks notebook?

Question

How can I look at the contents (first few lines at least) of a CSV file stored in Data Lake from Azure Databricks notebook using the %fs commands.

Answer 1

To list the contents of a CSV file from Azure Gen2 storage in Azure Databricks notebook, you can use "dbutils.fs.head" command.

Example: dbutils.fs.head("dbfs:/mnt/mountname/filename.csv")

dbutils.fs.head("dbfs:/mnt/chepra/drivers.csv")