Skip to main content

Hello,

I have two questions I would love to inquire about:

1. Exporting Lookup Items in Ataccama
I would like to know if it's possible to configure exports for lookup items in Ataccama.
When I try to export my lookup items, the export option is greyed out. When I hover over it, I see a message saying: "No export plan exists for the selected lookup items."

Under Global Settings > Import and Export, I see an option to create a new export plan. I tried using this, but got to a stage where I need to input a code for the export plan. I found the following JSON online and was wondering if this would work as-is or if it needs any tweaks:

{
  "name": "Export_All_Lookup_Items",
  "description": "Exports all lookup items for backup or migration",
  "type": "LOOKUP_ITEM",
  "format": "JSON",
  "filters": {
    "lookupTypes": ["ALL"],
    "tags": [],
    "projects": []
  },
  "output": {
    "combineIntoSingleFile": true,
    "fileName": "lookup_export.json",
    "includeMetadata": true
  }
}

Would this JSON-based export plan enable the export feature for lookup items? If not, what modifications would be required? Also, is there any official documentation or reference material available for creating export plans in Ataccama?

2. Visibility of DQ Rules
We have some Data Quality rules that are not visible to all users.
Is there a way to configure DQ rules so they are visible across the platform for all users ? do i have to manually share each rule before its visible to all users ? Any guidance on rule sharing, visibility settings, or permission configuration would be greatly appreciated.

Thank you in advance!

Hello ​@Susan24us,

For your point 2, we have a solution using GraphQL. We created a group in Ataccama Web and set up in graphQL an automated process which shares the DQ rules with this group on a regular basis so that all users can see all DQ rules.

Example of the end result:

Every DQ rule created will be shared with a group and all users in that group can view the DQ checks (select the share button in top right hand corner and the sharing with the group will automatically be completed with the below solution).

 

First set up a Group in Ataccama Web

Set up a new group in “Global Settings” of Ataccama ONE Web. Then in the Group roles, assign the Keyclock role profiles in the “Identity provide role” column. For example for us, all the Ataccama users have the Keyclock role “MMM_read-only” assigned to their user access accounts so assigning this role to the group means everyone will be able to see the DQ rules.

For the next steps I recommend you reach out to Ataccama to help you set up the below as it is a bit complex. They helped us set it all up previously. Manhar Seewooth was the superstar who helped us with this <manhar.seewooth@ataccama.com>.

You will need to set up a GraphQL query and a component in Ataccama ONE Desktop which utilises a JSON call and when run, it will share the DQ rules with the group you created. Ataccama can provide you all the code/details required as they did with us.

Then finally you will need to set up a workflow to automatically run the Ataccama ONE Desktop component on a regular basis. For example, we set it up to run every few hours, so any rules created in the previous few hours will then be automatically be shared with the group you created when this workflow runs.

Reply


Community Terms of Use & ConditionsCookie settings