You can search for assets and export the results of a search to your local folder.
In Data Governance and Catalog, you can export search results of business and technical assets. The exported file format for asset types is similar to the bulk import template file for those asset types. While exporting assets, you can include the corresponding child assets, asset details, and relationships in the exported file.
You can use the exported file to share the list of available assets with your team and create awareness about the assets available in the organization. The exported file with updated recommendations and enrichments can be sent for review to Data Governance users or Data Scientists before re-importing it into the catalog.
After exporting the search results, you can perform any of the following activities:
•Bulk enrich the technical assets with business context. You can only update technical assets but cannot delete.
•Bulk curate classifications and glossary associations, and then re-import the exported file.
For more information about bulk importing, see the Bulk Import Assets help.
Prerequisites
Before you export the results of a search, verify the following prerequisites.
You can export assets from the catalog only if your organization administrator grants you the following privileges and permissions:
•The Export privilege for your user role in Administrator.
•The Read permission on the assets that you export granted to you through access policies in Metadata Command Center
You can import assets into the catalog only if your organization administrator grants you the following privileges and permissions:
•The Import privilege in Administrator.
•The Create permission on the assets that you import granted to you through access policies in Metadata Command Center
For more information about the privileges and permissions, see the Asset Management help.
Exporting assets from search results
You can search for assets and export the results of a search as a Microsoft Excel file in .xlsx or .xls file format.
To export assets from search results, perform the following steps:
1Enter a search query in the search bar and apply necessary filters to fetch the required search results.
2On the Search Results page, click Action > Export.
3On the Export Assets dialog box, enter a new file name or retain the system-generated file name.
4Optionally, select the following options:
- Include Child Assets. For the parent assets, the exported file includes all the associated child assets. For example, while exporting 500 parent assets, the exported file includes 500 assets along with their associated child assets.
- Include Asset Details. The exported file includes the custom attributes and additional details of all the technical assets that are present in the search results.
- Include Relationships. The exported file includes the relationships between business assets that are present in your search results.
The Export Assets dialog box displays the Include Relationships check box only if the search results contain business assets.
If the search results are a combination of both business and technical assets, the exported file will contain only the relationships between business assets. If the search results contain only technical assets, the Export Assets dialog box doesn't display the Include Relationships check.
5Click Start Export to export the results of your search.
This triggers an export job that you can monitor on the Job Status panel. The panel displays the job summary, status, details, and download link to export results of a search file. The Job Summary section displays the list of asset types, number of sheets, and number of exported assets that are available in the downloaded Microsoft Excel file.
6After the export job is complete, click Download Export File.
7Alternatively, you can also check the status of your export job on the Job Monitoring page.
8After the export job is complete, click Action > Download Export File next to the corresponding job on the Job Monitoring page to download the exported file. Click Action > Download Log if you want to download the logs file to know the job activities.
Note: The predefined batch size of the exported file is 10,000. If the search results have more than 10,000 assets, the system compresses the export file as a .zip file. For example, if the search results have 90,000 assets, these assets are exported as a .zip file containing nine Microsoft Excel files, with each file containing 10,000 assets.
9Alternatively, click the Notification icon on the Home page to monitor the job status. Click the URL to open the corresponding job page to know the job status.
Once the export job is complete, you will receive notifications with a link to the corresponding job page in Data Governance and Catalog.
You can perform various operations on the exported file and bulk re-import the technical and business assets with your updates into Data Governance and Catalog. For more information, see the Bulk Import help.
Note: If the exported assets are in the In Review lifecycle status, you cannot update or delete the assets. You can only update assets that are in the Published and Draft lifecycle status.
Exporting assets from catalog source
You can export the assets that are within a catalog source.
To export assets from catalog source, perform the following steps:
1Open a catalog source and click the Export all or specific assets icon at the top right corner.
The Export All Assets and Export Specific Assets options appear.
2To export all assets in the catalog source, select Export All Assets.
3If you select Export Specific Assets option, you'll see a dialog box with Select Assets and Export tabs.
4Select at least one asset type or an asset, or both, and click Next.
5Enter a new file name or retain the system-generated file name.
6Optionally, select the following filters:
- Assets With Pending Recommendation Only. Export assets only with pending glossary and classification recommendations that need your review.
- Stakeholders. Select one or more stakeholders who are responsible or interested in this asset. If you want to export assets without any stakeholders, select No Stakeholders.
- Include Hierarchy. Select if you want to export all assets in the hierarchy of the catalog source. You'll see this option only when you export specific assets from a catalog source.
- Include Asset Details. Export the custom attributes and additional details of the technical assets.
7Click Start Export to export all assets from the catalog source.
This triggers an export job that you can monitor on the Job Status panel.
8After the export job is complete, click Download Export File on the Job Status panel to download the exported file.
The Job Status panel displays the job summary, details, and download link to export assets from the catalog source. The Job Summary section displays the list of asset types, number of sheets, and number of exported assets that are available in the downloaded Microsoft Excel file.
Note: The predefined batch size of the exported file is 10,000. If the results have more than 10,000 assets, the system compresses the export file as a .zip file. For example, if the search results have 90,000 assets, these assets are exported as a .zip file containing nine Microsoft Excel files, with each file containing 10,000 assets.
9Alternatively, you can also check the status of your export job on the Job Monitoring page.
10After the export job is complete, click Action > Download Export File next to the corresponding job on the Job Monitoring page to download the exported file. Click Action > Download Log if you want to download the logs file to know the job activities.
11You can also click the Notification icon on the Home page to monitor the job status. Click the URL to open the corresponding job page to know the job status.
Once the export job is complete, you'll receive notifications with a link to the corresponding job page in Data Governance and Catalog.
