Exporting data from a database
You can export the most recently generated database data to files or to a database.
Note that views are exported as tables. They do not create or replace the views in the target database.
Starting the export
To start an export, in the database header, click Export Data.
Selecting the output format
On the Export Database panel, from the Export As dropdown list, select the format for the exported data:
SQL - Exports the data to a .zip file called <database name>.zip. The file contains a SQL file to load the exported data, and a readme file that summarizes the export.
CSV - Exports the data to a .zip file called <database name>.zip. The file contains a .csv file for each table and view, and a readme file that summarizes the export.
JSONL - Exports the data to a .zip file called <database name>.zip. The file contains a .jsonl file for each table and view, and a readme file that summarizes the export.
Push to Database - Uses the data to populate a database that you specify.
Adding and selecting a database connection
When you push the exported data to database, you are prompted for the target database. The database must already exist.
Also note that for Fabricate to connect to your database, you must allowlist access from the following IP addresses:
5.161.104.100
If you previously created a target databases for export, then from the Target Database dropdown list, select the database to use.
To configure a connection to a target database:
From the Target Database dropdown list, select create new target.
On the New Target Database Connection panel:
In the Name field, provide the name of the database.
In the Host field, provide the host where the database is located.
In the Port field, specify the host to use to connect to the database.
In the Username field, provide the username to use to connect to the database.
In the Password field, provide the password to use for authentication.
In the Database field, set the Fabricate database that can populate the target database.
The field is pre-populated with the current database.
To test the connection, click Test Connection.
To save the target database, click Create Target.
The target database is then available to use whenever you export the database.
Selecting the scope of the data to export
If you are currently viewing a specific table or a view, then on the Export Database panel:
To export the entire database, click All Tables.
To only export the current table or view, click Only <table or view name>.
Completing the export and downloading exported files
After you configure the export, to complete the export, click Export Database.
When you export to files, after Fabricate generates the file, it prompts you to download the file.
If you do not download the file immediately, it is also available on the downloads list.
To display the list of available downloads, in the Fabricate header, click the download icon.
Last updated
