Follow these steps to upload a flat file into Prophecy:
Method 1: Upload your file via the AI agent chat
-
From the Professional Edition home page, click on the “Attach Data” button to attach a data file. The recommended maximum file size is 100MB, and you can upload the following file formats:
-
CSV
-
Excel (XLS, XLSX)
-
JSON
-
Parquet
-
XML
-
-
Once attached, ask AI any question about your data, or select a common task prompt. Click “Get Started,” and it will start building your pipeline.
Method 2: Upload your file to an existing pipeline
-
If you already have a pipeline, drag and drop your flat file onto the canvas.
-
Verify the database, schema, and table name. You can change any property with a dropdown selection, and you can type in the schema or table boxes to create new names.
-
Click “next” and review the properties and make any adjustments needed.
-
Click “done” to finish uploading the file.

