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.
XML - Exports the data to a .zip file called <database name>.zip. The file contains an XML file for each table and view.
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:
34.224.174.7
If you previously created a target databases for export, then from the Target Database dropdown list, select the database to use.
To create a new target:
From the Target Database dropdown list, select create new target.
On the New Target Database Connection panel, provide the connection information.
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.
Connection information for databases other than Databricks
On the New Target Database Connection panel, for database types other than Databricks:
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.
Connection information for Databricks
On the New Target Database Connection panel, for a Databricks database:
In the Name field, provide the name of the database.
In the Host field, provide the host where the database is located.
In the Warehouse ID field, provide the data warehouse for the data.
In the Access Token field, provide the access token to authenticate to the database.
In the Catalog field, provide the data catalog for the data.
In the Schema field, provide the schema for the data.
When Fabricate exports data to Databricks, it:
Creates a volume called
/Volumes///fabricate.Creates a directory in that volume that is named with a UUID.
Uploads a CSV file for each table into that directory.
Copies the data from each CSV file into the destination tables in the schema.
The catalog, schema, and tables must already exist. Fabricate creates the volume automatically.
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