Excel/CSV
Last updated
Last updated
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>.
If you're providing an s3 file path, ensure that the Vexdata server IAMRole has permission to read from the s3 bucket. The file size limit for uploads is 50MB.
After selecting a file format and uploading the 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.
