Atlan enables you to export all your assets or a filtered subset of assets to spreadsheets. Atlan currently supports exporting assets to:
- Google Sheets
- Microsoft Excel online
Once your Atlan admin has integrated a supported tool, you will be able to export your assets and asset metadata to spreadsheets. Your existing permissions and access policies in Atlan will determine whether you can export assets, but at a minimum you'll require read permission on the assets you want to export.
For example, you can:
- Export a list of assets that need enrichment and share the spreadsheet widely to crowdsource documentation.
- Export your business glossary and bring everyone up to speed on commonly used terminology across the organization.
Supported assets for export
You can export assets from the following tabs:
- All assets
- Filtered subset of assets
- Child assets such as columns or fields from the parent asset profile
- Glossary profile — all categories and terms within a glossary
- Category profile — nested terms within a category
- Term profile — linked assets for terms from the Linked Assets tab
- Assets dashboard — total assets, archived assets, assets by certificates, SQL assets, assets without enrichment, assets with lineage, and assets with announcements
- Glossary dashboard — linked assets for terms
- Insights dashboard — query assets with certificate
- Usage & Cost dashboard — suggested assets for deprecation
Enable asset export
The export icon or button will only be visible if your Atlan admin has integrated a supported tool. If you cannot see the export icon or button, reach out to your Atlan admin to integrate Google Sheets or Microsoft Excel.
Atlan requires the following permissions for integrating supported tools:
- Google Sheets:
https://www.googleapis.com/auth/drive.file— allows the app to see, edit, create, and delete only specific Google Drive files used with the Google Sheets app. This enables Atlan to create and update spreadsheets with exported assets.
- Microsoft Excel:
User.Read— allows users to sign in to the app, and allows the app to read the profile of signed-in users. This enables Atlan to authenticate the user. Atlan only supports authenticating with an organizational account.
Files.ReadWrite— allows the app to read, create, update, and delete the signed-in user's OneDrive files. This enables Atlan to create and update spreadsheets with exported assets. Note that access is restricted to the signed-in user's files — Atlan does not access any shared files.
To integrate a supported tool for exporting assets:
- From the left menu of any screen, click Admin.
- Under the Workspace heading, click Integrations.
- To connect Atlan to a supported tool for exporting assets:
- In the Google Sheets tile, click the Connect button. A sign-in dialog will appear and you will be redirected to sign in with your Google account. From the corresponding screen, click Allow to integrate Atlan with Google Sheets.
- In the Microsoft Excel title, click the Connect button. A sign-in dialog will appear and you will be redirected to sign in with your Microsoft account to integrate Atlan with Microsoft Excel.
Your users can now export assets from Atlan! 🎉
Atlan allows you to export your assets to spreadsheets and view asset metadata in bulk.
At a tenant level, Atlan supports running five exports concurrently for each supported tool. If both Google Sheets and Microsoft Excel have been integrated, a total of 10 concurrent exports is supported. At an individual user level, only one export is allowed for each supported tool at a time, the rest will be auto-queued for execution.
To export your assets:
- From the left menu of any screen in Atlan, click Assets.
- To export assets, in the Assets page, you can either:
- Next to the search bar, click the 3-dot icon and then click Export to export all assets.
- Apply any filters, click the 3-dot icon, and then click Export to export a list of filtered assets.
- The Export dialog displays a total count of assets available for export:
- Click Google Sheets to export your assets to a Google Sheets spreadsheet.
- Click Microsoft Excel to export your assets to a Microsoft Excel spreadsheet.
- A sign-in dialog will appear and you will be redirected to sign in with your Google or Microsoft account. From the corresponding screen, click Allow to connect to Google Sheets or Microsoft Excel.
- To track the progress of the export, you can either:
- In the Export in progress popup, click Open Sheets or Open Excel to navigate to the spreadsheet. The Queued status will change to Success once assets have been exported.
- Click the 3-dot icon and then click Export to view asset export in progress, along with an estimated time of completion. (Optional) To cancel the export, hover over In queue and click the Stop button.
- On the spreadsheet, you will be able to view the following details and asset metadata:
- Status — export status and total count of assets exported
- Title — asset name and link
- Type — asset type
- Connector — name of supported source
- Created By and Created At — username for user who created the asset and when it was created, only applicable to glossary exports
- Description — asset description, if any
- Owner Users and Owner Groups — asset owners, if any
- Certification Status and Certification Message — certification status of asset, if any
- Announcement Type, Announcement Title, and Announcement Message — announcements on assets, if any
- Tags and Propagated Tags — tags directly attached or propagated to an asset, if any
- Terms — linked assets
- Qualified Name — fully qualified name of the asset
- GUID — globally unique identifier of the asset
- (Optional) To view your asset export history, click the 3-dot icon and then click Export. From the Export dialog, expand the History dropdown to view your last 10 exports. Note that only you can currently view your own export history.
That's it, you've successfully exported your assets from Atlan! 🎉