Bulk Impact Report

The bulk impact report package allows to export the lineage impact report to different locations based on filter criteria applied by the user.

Configuration

Credentials

On this screen the output (where the assets are extracted) is selected.

EmailS3 BucketGoogle SheetCSV DownloadGCSADLS

• Atlan API Token: this is required to generate the dynamic dropdowns (see the Filters and Custom Metadata Filters screens)
• Email Addresses: list of email addresses (comma separated) that will receive the assets export as csv attachment.

Warning

The max size for sending attachments is 25 MB. Please consider to use another output method if the generated file is bigger than 25 MB.

• Atlan API Token: this is required to generate the dynamic dropdowns (see the Filters and Custom Metadata Filters screens)

IAM UserIAM Role

• AWS Access Key
• AWS Secret Key
• S3 Bucket Name
• S3 Folder Path: folder path with trailing slash - atlan/export/
• Region: s3 bucket region

The following policy needs to be attached to the IAM User in order to allow Atlan to write into the S3 bucket:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": [
                "s3:PutObject"
            ],
            "Resource": "arn:aws:s3:::<bucket-name>/*"
        }
    ]
}

• S3 Bucket Name
• S3 Folder Path: folder path with trailing slash - atlan/export/
• Region: s3 bucket region

Warning

Reach out to your Customer Success representative to create a cross-account bucket policy.

• Atlan API Token: this is required to generate the dynamic dropdowns (see the Filters and Custom Metadata Filters screens)
• Google Sheet Key: How do I find my Google Sheet Key?
• Worksheet Name (a.k.a. Sheet TAB)
• Service Account JSON (share the spreadsheet with your service user)

• Atlan API Token: this is required to generate the dynamic dropdowns (see the Filters and Custom Metadata Filters screens)

Warning

The CSV file can be downloaded from the Argo UI.

• Atlan API Token: this is required to generate the dynamic dropdowns (see the Filters and Custom Metadata Filters screens)
• Project id: Google Cloud project id that contains the buckets.
• Service Account JSON key: follow this article to create a service account JSON key. The following permissions have to be granted to the role assinged to the Service Account: storage.buckets.get, storage.objects.get and storage.objects.create.
• Bucket name: name of the bucket where to upload the file.
• GCS Folder Path: path where to upload the file.

• Atlan API Token: this is required to generate the dynamic dropdowns (see the Filters and Custom Metadata Filters screens)
• Azure Client ID: unique application (client) ID assigned to your app by Azure AD when the app was registered.
• Azure Client Secret: client secret.
• Azure Tenant ID: unique identifier of the Azure Active Directory instance.
• Storage Account Name: name of the Azure storage account.
• Container name: name of the ADLS container where to upload the file.
• ADLS Folder Path: path where to upload the file.

Filters

This screen allows to apply filters on the asset population. Each filterable attribute has an operator and a value. The operator is always a dropdown menu while the value can be either a dropdown or a free text field. The package considers the filter only if both the operator and the value are filled. The only exceptions are the operators “Is Empty” and “Is Not Empty” where the value is not required (and ignored if filled). Another exception is in Has Lineage filter where the default value is "Any" which is used to pick both types of asset(assets with lineage and assets without lineage). The available filters are:

• Connector
• Connection
• Asset Type
• Name
• Certificate
• Qualified Name
• Tag
• Description
• Has Lineage
• Announcement
• Owner User
• Owner Group

Custom Metadata Filters

This screen allows to apply filters on the asset population using custom metadata. Each filter has a custom metadata selector (dropdown menu), an operator and a value. The package considers the filter only if both the operator and the value are filled. The only exceptions are the operators “Is Empty” and “Is Not Empty” where the value is not required (and ignored if filled).

Mulitple values

If the custom metadata allows multiple values, use comma separated strings in combination with the "Is one of" or "Is not one of" operator to filter multiple values at the same time.

Output

This screen allows the selection of the attributes to export.

• Lineage Direction: whether to export either Downstream or Upstream lineage impact report, default: Downstream

• Custom Metadata Output

  FixedDynamic

  The following predefined columns are exported:

  • Asset Name
  • Asset Type
  • Asset Qualified Name
  • Asset Guid
  • Lineage Position
  • Direct Dependencies
  • Impacted Asset Name
  • Impacted Asset Alias
  • Impacted Asset Type
  • Impacted Asset Qualified Name
  • Impacted Asset Guid
  • Impacted Asset Description
  • Impacted Asset Group Owners
  • Impacted Asset User Owners
  • Impacted Asset Tags
  • All custom metadata

  The following predefined columns are exported:

  • Asset Name
  • Asset Type
  • Asset Qualified Name
  • Asset Guid
  • Lineage Position
  • Direct Dependencies
  • Impacted Asset Name
  • Impacted Asset Alias
  • Impacted Asset Type
  • Impacted Asset Qualified Name
  • Impacted Asset Guid
  • Impacted Asset Description
  • Impacted Asset Group Owners
  • Impacted Asset User Owners
  • Impacted Asset Tags
  • The list of custom metadata can be selected from a dropdown menu.

• Direct impact assets: Whether to add the list of assets directly linked to the impacted asset.

• Zipped: whether to zip the output file. The option is ignored if Google Sheet is selected as destination.

• Lineage depth: lineage depth extracted. If empty the full lineage is extracted.

Impacted Asset Filters

This screen allows to apply filters on the upstream/downstream assets. Assets that are upstream/dowstream to the assets selcted in the above Filter section and that match the filters defined in this section are included as Impacted Assets at each depth level. Leave it empty to include all upstream/dowstream assets in the Impacted Asset Columns.

Each filterable attribute has an operator and a value. The operator is always a dropdown menu while the value can be either a dropdown or a free text field. The package considers the filter only if both the operator and the value are filled. The only exceptions are the operators “Is Empty” and “Is Not Empty” where the value is not required (and ignored if filled). Another exception is in Has Terms filter, where the default value is "Any" which is used to pick both types of asset(assets with terms and assets without terms). The available filters are:

• Connector
• Connection
• Asset Type
• Name
• Certificate
• Qualified Name
• Tag
• Description
• Announcement
• Owner User
• Owner Group
• Has Terms

What it does

The package performs the following steps:

• Translate the UI input into an ElasticSearch query.
• Retrieve from Atlan downstream/upstream assets of the selected assets.
• Generate a csv file.
• Send the generated csv file to the selected output.

---