Once you've connected Atlan with Google Sheets, you can download impacted assets in Google Sheets. This can help you assess the downstream impact of any changes made to an upstream asset for impact analysis.
Download impacted assets in Google Sheets
To import lineage in Google Sheets:
- In the menu bar of your Google spreadsheet, click Extensions.
- From the dropdown menu, click Atlan.
- From the list of options in the Atlan add-on, click Import Lineage to open a list of your assets in a sidebar.
- (Optional) To filter your assets by a specific asset type, in the Atlan sidebar, select the asset type.
- In the Atlan sidebar on your spreadsheet, select the asset(s) you want to import.
- To select the type of impacted assets you'd like to download, in the Atlan sidebar, from the Direction dropdown:
- To download downstream assets for impact analysis, click Downstream.
- To download upstream assets for root cause analysis, click Upstream.
- To download all impacted assets, click Both.
- To download the impacted assets in Google Sheets:
- Click Import Lineage to download all the impacted assets in one sheet.Â
- Click the vertical three dots and then click Import to new sheet to download the assets in separate sheet tabs.
- (Optional) Once download is successful, click the asset links in your spreadsheet to view the assets in Atlan.
The impacted assets are now available in Google Sheets! 🎉
Update column metadata for impacted assets
Once you've imported your impacted assets from Atlan, you can edit the column metadata for impacted assets in Google Sheets. You can make changes to the column metadata once all the columns have been imported successfully.
You can only make changes to the metadata in the following columns:
- Description
- Owner Users
- Owner Groups
- Certification Status
- Certification Message
- Announcement Type
- Announcement Title
- Announcement Message
- Tags
You cannot make the following changes:
- Edit headers for any of the columns
- Edit the metadata in the following columns:
- Source Asset
- Source Asset Connector
- Source Asset Type
- Impacted Asset
- Impacted Asset Connector
- Impacted Asset Type
- Direction
- Terms
- Propagated Tags
- Source URL
- Qualified Name
- Source Asset GUID
- Impacted Asset GUID
- Immediate Upstream and Immediate Downstream
- Delete any columns or rows
Any of these changes will not be pushed to Atlan and you'll receive an error message.
Push changes to Atlan
Once you've made changes to the column metadata, to push your changes:
- In the menu bar of your Google spreadsheet, click Extensions.
- From the dropdown menu, click Atlan and then click Push to Atlan.
- A dialog box will appear once the changes have synced.