Importing static data into a Data Agent database

You can import a file into a Data Agent database. You use the data to either:

• Create a new table

• Replace the records in the current table

• Add to the records in the current table

Requirements for imported files

The imported file:

• Can be a CSV, JSON, or JSONL file.

• Cannot be larger than 100 MB.

• If the data will replace or update records in an existing table, then the file must have the same structure as that table.

Completing the import

To import a file into a Data Agent database:

1. If you plan to use the imported data to replace or add to the records in a table, then in the table list for the database, select the table.

2. In the database heading, click Import.

3. On the Import Data panel, either:

   • Drag and drop the file on the panel.

   • Click Choose File, then search for and select the file.

   Fabricate displays the first few records in the file, to allow you to verify the file structure.

4. From the Action column, select the action to perform with the data.

5. If you selected Create new table as the action, then in the New Table Name field, provide the name of the new table. By default, the name is set to the file name.

6. Click Import Data.