Export/Import Overview

Learn more about the Export/Import functionality to quickly update metadata across the platform.

The CSV Export/Import feature in Decube allows users to efficiently manage large volumes of metadata by enabling bulk download, update, and creation of metadata items using standardized CSV templates. Whether you're migrating systems, cleaning up data, or onboarding new content, this feature empowers data teams to handle these operations in a streamlined, self-serve manner.

With this workflow, you can save time, reduce manual errors, and empower your data team to manage metadata at scale—quickly and confidently.

Walkthrough of the Export/Import module.

What is CSV Export/Import?

CSV Export/Import enables users to:

  • Export existing metadata into structured CSV files for bulk review and edits.

  • Export empty templates for adding new entries.

  • Import metadata back into Decube by uploading completed CSV files to apply updates or create new records.

This is especially useful for:

  • Mass editing descriptions, tags, owners, classifications, and other attributes.

  • Creating multiple glossary or policy entries at once.

  • Reducing manual work through structured, repeatable workflows.

Who Can Use This?

Only users who are part of the Owner group within Decube can access and perform Export or Import operations. This ensures data governance and control over bulk metadata operations.

When Should You Use Export vs Import?

Action

Use Export

Use Import

Download existing metadata for edits

Update metadata in bulk

✅ (after exporting and editing CSV)

Create new glossary or policy items

✅ for downloading the template

✅ (using provided template)

  • Start with Export if you need a snapshot of current metadata for edits.

  • Use Import to apply your changes or upload new metadata via Decube’s supported CSV templates.

Supported Metadata Objects

Object Type

Supported Objects

Catalog (Datasets)

Schemas, Tables, Columns

Catalog (Non-Datasets)

Dashboards, Charts, Data Jobs

Glossary

Glossaries, Categories, Terms

Policies

Classification Policies

Each object type has its own CSV format and set of editable attributes.

Key Considerations Before Using

  • Permissions: Only Owners can perform Export/Import operations. If you need access, contact your Decube administrator.

  • Data Accuracy: All changes made via Import are final and cannot be reversed. Double-check your data before uploading.

  • Backups: Always keep a backup of your CSV files before importing, so you can restore or audit changes if needed.

  • Template Usage: Download the correct template from the Export tab before starting.

    • Use "Edit existing items" for a pre-filled file.

    • Use "Add new items" for a blank template.

  • Single Source Limitation: For Catalog export, you can select and export metadata from only one data source at a time.

  • Validation Checks: Decube performs smart validations on Import to flag incorrect data. If validation fails, you’ll receive an error report and can re-upload after corrections.

  • Audit Logging: All Export/Import operations are logged in the History tab, including statuses, error reports, and download options, for full traceability and compliance.

Frequently Asked Questions (FAQ)

What file formats are supported for import? Currently, only CSV files that follow the provided template structure are supported.

How do I know if my import was successful? After uploading your CSV, you’ll receive a confirmation message. You can also review the History tab for a detailed log of all actions and outcomes.

Can I import new and update existing records in the same file? No, you must use separate files for adding new records and updating existing ones. Use the appropriate template for each operation.

Who can access the Export/Import feature? Only users in the Owner group have permission to perform export and import operations.

What should I do if I encounter a validation error? Review the error report provided after your import attempt, correct the highlighted issues in your CSV, and re-upload the file.

Is there a limit to the number of records I can import at once? While there is no strict limit, very large files may take longer to process. For best performance, consider splitting extremely large imports into smaller batches.

Where can I get help or support? If you have questions or need assistance, visit the Decube documentation or reach out to our support team at [email protected].

Ready to get started? Head to the Export/Import tab in your Decube workspace to begin your first bulk metadata operation.

Last updated