[FIXED] How to connect and read files from Azure FTP folder using Python in Azure Databricks?

Issue

I need to use Python in Azure Databricks to do the following:

1. Merge multiple text files stored in Azure FTP folder (\VMAZR1\ABCDFiles). Here, 'VMAZR1' is the server name and 'ABCDFiles' is the folder name
2. Store the merged file in the same location with new name

I can write the code to do the merging but I need assistance with connecting to Azure FTP folder and reading text file names only. Can someone please assist?

Solution

You can rely on this answer. Just change the method of storing to retrieving, e.g., retrbinary, or retrlines as well as mlsd to get a list of file names.

Answered By - Phuri Chalermkiatsakul

Answer Checked By - Willingham (PHPFixing Volunteer)