Step 1- Go to Data Tab, and simply just click on the add button on the top right side corner.

Step 2- Just Simply click on the upload data tab and upload your CSV file.

Step 3- In Data hive_metastore >>Default >> your will found ur file.

Step 4- Now go to Details Tab to copy your file location and copy the path of file.

Step 5- Firstly just replace the file path with your file path.

# Assuming you have uploaded the CSV file to DBFS

file_path = “dbfs:/user/hive/warehouse/tl_targets”

Step 6 –Again put file path after the .load.

# Read the Delta table into a DataFrame

df = spark.read.format(“delta”).load(“dbfs:/user/hive/warehouse/tl_targets”)

# Display the contents of the DataFrame

df.show()

Leave a Reply

Your email address will not be published. Required fields are marked *