Learn & Share

Hi,I would like to know if it’s possible to run python program from Ataccama one → Transformation plans feature? If yes, how do we do it, which steps/components from desktop could be used? Really appreciate your suggestions here! ​@Lisa Kovalskaia ​@anna.spakova Thanks! 

Hi there!!I am looking for some documentation related to capabilities of Ataccama v15.4 or v16.4 in terms of DQ of semi structured (json/parquet) or unstructured data altogether, if it’s supported what are the pre-requisites we need to set up.Please do share.Thanks in advance!

Hello everyone,I’m trying to export specific details from my monitoring projects and would appreciate some guidance.For each monitoring project, I want to retrieve only the most recent run, including: Monitoring project name Monitoring project ID Stewardship information Result name Result status Result count -(Passed Count/ Failed Count ) Date the run was executed.                                                                                                                                                                                                I’m currently using a metadata reader to retrieve the monitoring project name, ID, and stewardship, which works as expected. However, when I add fields from the embedded Processing entity and join in the relevant columns, the export returns multiple rows per monitoring project, as it includes historical runs instead of only the latest one.Has anyone encountered this before? What is the recommended approach to: Filter or ident

hi Team, I just worked on a project with Purview and the way we set up DQ there was different. Creating data products and then creating DQ connection separately than the one used to scan the physical metadata.  But here in Ataccama its different like here we can ceate DQ rules directly on to the Terms, and here I saw we create the source directly. Want to understand similarities and differences between Atacama and Purview from any experts who has spent time in both tools :)  Thanks in advance. Regards,Vikas

What is the exam fee for  Ataccama ONE v13 Data Quality & Governance Foundation Level certification for attendees who exchange a minimum of 12 months hands-on experience for the must have training? How can we apply for the certification exam? Is the application process online or offline? Is the exam proctored? 

what is the graphql mutation for creating a monitoring project in Ataccama Unable to open playground so need help with a direct graphql mutation query for creating Monitoring project

Hello Ataccama Community, I have a question regarding the possibility of using nested /consecutive backreferencing into an AQL filter . The actual question would be whether if we can create a filter on the ‘term’ entity to show only the terms which have 0 termInstances on rules . This was the initial issue because we have used this AQL Filter into a Term Report Page : @termInstance(target).count( )==0 . However, this was not enough because it did not filter only the term instances from the rules, but also the ones from the catalog item , attributes , etc. I have initially tried to place something like this : @rule.inputGroups.inputs.termInstance(target).count() = 0 , but I got an error and I am not sure if nested backreferencing is possible .After that, we changed the approach and we decided to add another entity ‘termsUsedOnRules’ and I configured it exactly the same as ‘termInstances' .Then I have added this entity as a property on the rule as an Embedded Object Array and filtering b

I am trying to create a transformation plan in DQ One Web that merges existing data in a One Data table to the most recent run from a Monitoring Project.The situation is difficult and I will try to be as concise as possible: We have a One Data table that is created from a Monitoring Project Data Remediation plan.  We input notes on the One Data table that explains what needs to be done to that invalid record Every time the monitoring project is ran, the notes in that One Data table are deleted.The fix in my mind is that we could union what is currently in the One Data table (with notes) with the new remediation export in order to retain the notes on the “older” version of the One Data table, while allowing any new invalid records to be written into the One Data table.Essentially, I need to somehow create (within the transformation plans on One Web) a left outer join where everything with the current run coming in, but joining with those on the right (the older run) that has notes.  Any

Hello,How to write the following condition in Ataccama Desktop (Join step):left join anl.productsjur p on (asd.creditpurpose = p.cp or coalesce(asd.creditpurpose, p.cp) is null)                        and (asd.creditpurpose2 = p.cp2 or coalesce(asd.creditpurpose2, p.cp2) is null)                        and (asd.creditobject = p.co or coalesce(asd.creditobject, p.co) is null)The difficulty is that in the join step only one field for left key and right key is available for selection..

Happy to share a quick update with the community on the progress we’ve made with our on-premise AI agent integration into Ataccama ONE. We’ve now developed and tested four distinct use cases that support users across various data governance tasks. All of these are accessible through a lightweight chat-based interface that runs alongside the Ataccama UI, without modifying the core product.Here’s a brief overview of what’s working today:Data Quality InsightsThe agent detects data quality issues and provides root cause analysis with natural-language explanations. When needed, it also offers recommendations for resolving common problems, making DQ monitoring faster and more intuitive.AI-Assisted Data Catalog NavigationUsers can search and explore the Ataccama catalog using natural language. The agent retrieves relevant metadata and provides contextual recommendations, helping non-technical users find and understand data without needing to know the structure.Compliance & Sensitive Data

Hi everyone! Welcome to the third (and the last) part of our introduction series! The continuing posts will be focused on diving deep into the functionalities of DQ. If you have missed the first two posts you can check them out here:In this post, we'll explore the best practices for monitoring data quality in Ataccama ONE. Monitoring your data quality allows you to track important metrics in real-time and identify potential issues. Creating a Monitoring ProjectTo create a new monitoring project, navigate to "Data Quality" and select "Monitoring Project." Click on "Create" and provide a name and description for your project. On the "Configuration & Results" tab, choose the catalog items you want to monitor. You can monitor multiple catalog items within a single project as long as it makes sense for your organization's data quality requirements. Customizing DQ DimensionsIn each monitoring project, you can customize the DQ dimensions that contribute to the overall data quality. Look f

Hi,I would like to know if it’s possible to automate rule creation in Ataccama without actually using UI maybe by running scripts or API calls from backend.

Hello All,I need your help on Ataccama One DQ issue.I created an accuracy rule for Zipcode using lkp table.In the lkp table, Zipcode is stored as an integer, but in the Catalog,src attribute as nvarchar(20).When building the rule, Ataccama forces me to choose integer as the data type because the lkp table uses integers.But since the Catalog attribute is nvarchar, the rule is not working. and tried with lkp as string and i/p attribute in lkp also as string which thrown an error while evaluation.I also cannot change the src attribute datatype from nvarchar(20) to integer because:If I convert it to integer using cast, NULL values will move to completeness checks,And I will not get the incorrect rows under accuracy.So I need a solution that allows the accuracy rule to work even though the lookup table uses an integer Zipcode and the Catalog column uses nvarchar.Thanks in advance.Deepali 

This is my result in REST API call.I need to consume my entire REST API using the next record URL until done is set as true.How do I achieve this in Ataccama.

Hi All,   We have a few SQL Catalog Items that represent data in a way that the users find intuitive (compared to the awkward way the data is stored in the source system). However, whenever I update the SQL in anyway, like to add or remove a column/attribute, all field definitions, terms, etc are removed. They can be seen in the previous version of the Catalog Item, but I have to either restore the old Catalog Item or re-enter all the definitions. Is there a way to update the SQL behind SQL Catalog Items and not impact the unchanged attributes?Thanks for any help you can provide. RegardsStu

Hello Ataccama Community,I’ve been exploring the Data Slicing feature in Ataccama 16.2 and it looks like a great tool for profiling large datasets. However, I noticed that Hive and Sybase are not listed as supported databases for slicing.Since we rely on Hive Data Lakes and Sybase in our environment, I wanted to ask if there are any plans to support these databases in future releases, or if anyone has found effective workarounds for slicing data from these sources before profiling.Looking forward to your insights! Create a Data Slice :: Ataccama ONE

Hi,We have implemented Pushdown in our application and have noticed that when we have a few DQ Rules that are not supported by Pushdown, are forced to run the whole Monitoring project in regular (non-Pushdown) mode. Even when the catalog items running pushdown un-supported rules are excluded from pushdown processing using Advanced settings on Monitoring project, still leads to those DQ Rules failing.Is there a hybrid approach to run Monitoring projects implementing a mixture of pushdown supported and unsupported DQ Rules ? Atacama should have the ability to selectively run pushdown supported DQ rules in Pushdown and non-supported in regular mode without forcing users to choose one. This should be done automatically. Please let us know if there are any suggestions.

Hello Ataccamer,I have a question regarding the "onPublishHandler.plan" file. This file contains components and steps for on-publish synchronization for all the RDM tables, which results in numerous components corresponding to each RDM table. As the project progresses, the number of RDM tables keeps increasing, causing this file to continuously grow in complexity.I'd like to inquire whether it's possible to segregate these components based on projects example diff file for domain or any other way. Is there a way to create separate "onPublishHandler.plan" files for different project domains? This could help reduce confusion, especially when multiple developers are working simultaneously. Just a thought. Thanks and regards,Ojaswini

How do I build a report to show data stewards the completeness of their respective business terms? For example, 57% of terms in the Customer domain have a Domain Owner assigned.

Hello,I need to make an API POST call where the endpoint expects multipart/form-data. The API accepts normal JSON fields as part of the multipart request, and it also requires a .csv file upload as a mandatory input.Right now, I am using a JSON call step, but that only lets me send application/json. Since the API requires multipart with both JSON and file, I’m not sure how to proceed.My Questions:1. How do I send JSON + a CSV file in a single multipart request?2. Do I need to switch from the JSON call step to a multipart/form-data step?3. If using Ataccama, which step/component should be used to construct multipart requests?

Exploring options for implementing a data pipeline from Ataccama ONE to a Power BI dashboard. Which approach is better: using the GraphQL API or leveraging the ONE Metadata Reader and DQ Monitoring Project Check Results?

I have to write DQ rules on a table that should execute through monitoring projects.Only data with max date should be evaluated or evaluation should happen for date that use adds dynamically. How to achieve this?

Hello everyone,I am wondering if it is possible to using the catalog item reader step with the runtime server. I have a workflow that reads from two catalog items, joins them on a row and then emails the results. However, when I attempt to execute the workflow from the runtime server I receive this error: 2025-11-18 20:11:17 INFO: Validating model...2025-11-18 20:11:18 ERROR: Step is restricted to run on Environments with Launch Type: 'ONE Platform', but selected Environment has Launch Type: 'Local'. [Catalog Item Reader (Catalog Item Reader)]2025-11-18 20:11:18 ERROR: Step is restricted to run on Environments with Launch Type: 'ONE Platform', but selected Environment has Launch Type: 'Local'. [Catalog Item Reader 2 (Catalog Item Reader)]Is there a way to change my launch type on the runtime server environment or a different method I can use to read from the catalog items. Here are how my work flow and plan currently function: 

i have installed ataccama one desktop but it is asking for license to execute anything. Can someone please help in providing free trial license.