You can export the Explore document list to a CSV file. All pages of the document list are included.
Note: In Data Hub 5.6, object and array datatype properties cannot be exported. If the selected dataset includes objects and arrays, a preview of the CSV is shown before the export is completed.
If you do not have the required privileges to view, filter, or export a specific document, you will not be able to perform that action on that document. For example, if you are permitted to view the document but not export it, it is included in the displayed document list but it is excluded from the exported list.
Before you begin
You need:
- Security role(s):
- To view PII data: pii-reader
- To view all other data: any Hub Central role
- To save and run queries: Hub Central Explorer or Hub Central Operator
- To export data: Hub Central Explorer or Hub Central Operator
Or any role that inherits the required role. See Users and Roles.
Procedure
- Go to the Explore area of Hub Central.
Learn how.
- Go to your Hub Central endpoint.
- In the icon bar, click the Explore icon (h).
- At the Explore portal, choose the data you see and how you view it, or run a predefined query.
- Click Explore to view your data.
- (Optional) Choose what to export.
Only the items in the document list are exported. To define what is included in the document list, you can perform any combination of the following:
- Click the Export icon ().
Note: The icon does not appear if All Entities is selected.
- (Optional) In the Export dialog, specify the number of rows (documents or records) to export or choose All.
The documents are exported in the selected sort order. If you specify n as the number of rows to export, the first n documents, according to the sort order, are exported.