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.

project-exporter-grant

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.

assign-workspace

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.

sql-editor

Without export permission, you'll have to Request Export.

sql-editor-request-export

You will be redirected to an issue page. Create the issue. After approval, you'll be able to Export.

sql-editor-export

Project level

This feature is available in Enterprise Plan.

Request Exporter Role in Database > Databases of the project, where you can Manually select databases/shcema/tables and alter Max export rows.

request-exporter-role

One-time Export Request

Enter Export Center within a project, where you Request Export, select a database and click Next.

export-center

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.

export-preview

After approval, you can click Export to download the exported file.

export

The exported issue will be displayed in Export Center.

export-list

Edit this page on GitHub

Subscribe to Newsletter

By subscribing, you agree with Bytebase's Terms of Service and Privacy Policy.