Data Export
Bytebase users obtain Project Exporter
role to export data repeatedly or request a one-time export in Export Center.
Assign Project Exporter Role
Project level
Select Project and go to Manage > Members. Project Exporter
role can be assigned in Grant Access.
Select Users or Groups, assign Project Exporter
role. You can Manually select databases/shcema/tables and alter Max export rows. Choose Expiration and click Confirm.
Workspace level
Workspace Admin
can assign Project Exporter
role at the workspace level. This will grant export permission to all databases within all projects.
From the workspace page, go to IAM & Admin > Members, Grant Access to Select users/groups and assign Project Exporter
to them.
Request Project Exporter Role
Within SQL Editor
Data can be directly exported from result panel in SQL Editor. This requires Project Querier
besides Project Exporter
roles, for query permission is the precondition of data export.
Without export permission, you'll have to Request Export.
You will be redirected to an issue page. Create the issue. After approval, you'll be able to Export.
Project level
Request Exporter Role in Database > Databases of the project, where you can Manually select databases/shcema/tables and alter Max export rows.
One-time Export Request
Enter Export Center within a project, where you Request Export, select a database and click Next.
You'll be creating an issue. Enable Encrypt and set Password if needed, fill your query commands in SQL block. Create the issue. By configuring custom approval, it will match the corresponding approvers.
After approval, you can click Export to download the exported file.
The exported issue will be displayed in Export Center.