Excel/CSV

There are two ways to provide an Excel or CSV file as the input files:

  • Upload files (supports both CSV and ZIP files).

  • Provide an s3 location : s3a://<file_path>.

Excel File

After selecting a file format and uploading the file:

EXCEL File

After selecting a file format and uploading the file:

  • Provide a Delimiter option if the CSV file format is selected.

  • Select a Header from the drop down menu.

  • Select if schema should be inferred.

    • Note : If the input file size is large > 20MB, it is recommended not to select InferSchema as true.

  • Click on Validate. At this point, the CSV file is validated and, if successful, sample records are fetched. Check the Sample Data tab to ensure the file parsing is successful and that the data is as expected.

SFTP File Path

Last updated