Release notesFabricateTonic.ai

Exporting data from a Data Agent database

Supported export formats

When you are ready to use the data, you can export the Data Agent database to one of several formats.

Each download is in the form of a .zip file, and includes a readme file that contains a summary of the export.

The following formats are available to all users:

  • CSV - Produces a .csv file for each table.

  • JSON array - Produces a JSON array for each table.

  • JSONL - Produces a .jsonl file for each table.

  • MySQL - Produces a .sql file to create and populate the database.

  • PostgreSQL - Produces a .sql file to create and populate the database.

  • SQLLite - Produces a .db file that contains the database.

These formats require an Enterprise license:

  • Avro - Produces an .avro file for each table.

  • Databricks - Produces a .sql file to create and populate the database.

  • Iceberg - Produces a folder structure that contains the data and metadata.

  • Microsoft SQL Server - Produces a .sql file to create and populate the database.

  • MongoDB - Produces a .bson file for each table, and a load.sh file.

  • Oracle - Produces a .sql file to create and populate the database.

  • Parquet - Produces a .parquet file for each table.

  • XML - Produces a folder for each table. Within each table, produces an .xml file for each record.

You can also choose the Push to database option, which uses the data to populate an existing database that you specify.

Exporting the full database

To export the full Data Agent database:

  1. In the database heading, click Export.

  2. In the Export menu, select the format to use.

Export format options for a Data Agent database

For options other than Push to database, Fabricate immediately creates and downloads the files.

For the Push to database option, Fabricate prompts to you configure and select a database connection. For information on how to set up and select the connections, go to Adding and selecting a database connection.

Prompting the Data Agent to export data

You can also prompt the Data Agent to export the data. For example: Export the database to CSV files.

With the Data Agent chat, you can customize the exported data. You might want to export only a subset of the database, or a specific table.

For example: Download to CSV files all of the records associated with the top 5 orders by value.

Last updated