Discuss, learn, ask, suggest, share all things DQ&C 🔍
Recently active
Hello,I am trying to export the information displayed in the “History” tab of Glossary / Business Terms in Ataccama ONE using the ONE Metadata Reader component.On the Business Term page in the UI, the History tab displays details such as:Version number Published on date/time Published by userIt also shows when a term was newly created or updated, including the timestamp and the name of the user who made the change, similar to an audit/history log.I would like to export this information together with my glossary/business term metadata.However, in the ONE Metadata Reader, I can only see the standard business term attributes, and I cannot find any entities or columns related to:history version history revisions published by published on audit informationI am therefore trying to understand where this information is stored and how it can be exported.Could you please clarify:Which entity/table/object stores the data displayed in the History tab? Is this history/version information accessible
Hi,Can some help me with creating a post processing transformation plan that shows a different row for each DQ rule that has passed/failed on a particular field in the transformation plan in One Web UI. For Eg: I have 2 rules, a uniqueness check and a format check on the ID field. In the post processing output file, what’s the best way to see how I can split this for each rule and see the pass/fail metrics for each rule.Thanks
Hi,We are using Ataccama one 12.6 version. We have a project containing 40+ models with 90 + rules. I am looking for an options to get the detailed invalid/failed records for each model. Like all the attributes from the model along with invalid rule instance names.The idea is to get the whole failed dataset to automate the remediation process. We already have automated process to remediate the data using other technologies.I don’t want to use the download results in csv option, because we are transitioning to latest version of Ataccama.I am looking for couple of optionsExtract the detailed failed records from backend tables using sqls (where Ataccama stores the results) or would like to understand how those csv files are generated in backend and use the same way to get the data and store in db. Reading data through Ataccama inbuilt API’s and loading into a db. I am going through the GraphQL options. Could you please let me know, If there is way to get the similar data through GraphQL
Hello,I’m trying to build some ONE Desktop plans and workflows to integrate RDM with an application which only accepts SOAP calls.I managed to do a 2 step approach - a SOAP call to get a token using username/pwd, then another SOAP call to do the actual thing using the token (insert some data into that system).I was hoping to have instead, the pwd encrypted in the runtime config file, so I tried setting up a connection like so:I tried to set up the connection in server connection:Where the SecurityProvider endpoint is where I get the token, and ComponentExecutor endpoint is where I connect to do the thing I actually want to do. But when I try to use this connection in the SOAP call step, it tells me: So it only accepts Basic auth. Do I have any other options?
We’re on v16.3. Is it possible to have an MMM role which has: read metadata access run profiling jobs run lkp builder jobs run monitoring project jobs But without the ability for example to edit the contents? e.g. just run a lkp builder job but not be able to amend the configurations of the lkp, or run the monitoring project without ability to change anything.I tried looking at documentation, seems like for Monitoring Project, the levels of view metadata access and view data access doesn’t allow running the project, while full access can. However full access also gives editing rights to monitoring projects which we don’t want to allow.Has anyone else run into the same scenario? How have you solved it?
Hi everyone,I’ve seen several posts about extracting data‑quality metadata from Ataccama ONE for Monitoring projects, using approaches like GraphQL or Metadata Reader steps. I wanted to ask if anyone has been successfully able to extract this metadata using either method.We’re running into significant challenges with both approaches:GraphQL: When drilling down to the table or data‑element level, the underlying query structure becomes extremely complex and difficult to interpret. It’s very time-consuming, and we haven’t been able to construct workable queries. Metadata Reader steps: This option requires joining multiple metadata streams, and the resulting plan becomes overly complicated.I’m trying to understand whether anyone has successfully built Data Quality dashboards by extracting metadata from Ataccama ONE, loading it into a database(Databricks), and connecting it to Power BI.If you’ve done this or have guidance, I would really appreciate connecting with you to discuss your approa
I am trying another way to deal with my strange timeliness issue. Does anyone know how to reference a parameter in an advanced expression setting a variable? As you can see it does not like me just using the name of the parameter, although it lets me use the name of an attribute just fine.Any ideas?
Hello,We have a use case to integrate Ataccama ONE DQ&C with STONEBRANCH scheduler tool. The STONEBRANCH scheduler job should be able to trigger a monitoring project in DQ&C to perform DQ Evaluation on a Catalog item and generate a success/failure flag upon completion. Looking for documentation/details on how this can be achieved.Thanks in advance,Arjundev
Hi!We need to see the same filters from Main Rule page to subpages such as “Detection” and “DQ Evaluation”. How to do that?
We are working to migrate a long running set of data quality rules into Ataccama. Most have been easily implemented and are running smoothly.However, the last set of about 10 deals with overlapping date ranges related to effective dates. We want to validate that one Processor (for instance) only has one “active” record for a date (as defined by the start effective date and end effective dates on those records).For instance, let’s say Processor ABC has the following records, there is a problem with records 2 and 3.ABC, Start: 1/1/2024, End: 12/31/2024 ABC, Start: 1/1/2025, End: 12/31/2025 ABC, Start: 10/1/2025, End: 12/31/2026Ideally, we would like to pass an identifier (in this case ABC), and then the start effective date, and then the end effective date, as we have to do this on about ten + tables. So, we’d like a universal rule that we can use across the board.I’m reaching out to see if anyone else has implemented a similar rule and can share with us their logic and process.
Hi,I need to dynamically union all sheets in an Excel file used as input for a plan. Since the number and names of sheets may change, I’m exploring whether this can be handled within Ataccama—potentially by using a Python script in a Run Shell Script step within a separate workflow, and then using the output as the plan input.I would appreciate your help.
Hi everyone,I’m working with Ataccama ONE version 15.4.1 and would like to track user activity for reporting purposes (e.g., number of users logging in or using the platform on a weekly ,monthly and quarterly basis).Is it possible to capture this kind of user activity and export it into a SQL database for reporting?If yes, could you please outline:What needs to be configured to enable user activity tracking How to capture login/usage data How to export or make this data available in a SQL database Any recommended approach for building weekly/monthly user metrics Secondly : I want to create an export plan using a post-processing plan in the IDE. Is it possible to make the export rule-based, instead of exporting the entire set of invalid samples?For example: If a rule checks for missing values, can the export return only the invalid samples for that specific rule? Or Is it possible to export invalid samples by attribute, so that if the attribute is Last Name, the export includes only
Hello everyone!!! I have a classic use case to create data slicing on Catalog Item available in One web through One desktop plan. Can anybody help me with step-by-step process to do so and publish the slicing in One web.
Hi Team,I am using one desktop and trying to fetch the catalogitems along with the associated attributes from one metadata reader. However i am getting an null pointer error, would really appreciate if there are any fix or solutions around the same“Internal error occurred during run of the plan: Cannot invoke "com.ataccama.one.client.impl.MdAncestor.getProperty()" because "this.ancestors[i]" is null”
Hi @anna.spakova We have MongoDb as source. For a particular column most of the data are present but some data are not present. Please help to fix.Thanks!
Hello @Lisa Kovalskaia I need to bulk update the description of the rules which include a hyperlink. When I used ONE Desktop Plan it displays as string rather than link. Can you please help?
Hi,I want to create data quality rules that calculate the Population Stability Index (PSI) on a categorical attribute to detect distribution shifts over time.My goal is to build a flow that:Uses a date column from the rule input to split the dataset into: a reference window (previous N days) a current window (most recent N days)Calculates category distributions (percentages) for both periods Computes the PSI between these two distributions.I would appreciate guidance on the best way to implement this and other kinds of drift metrics in Ataccama on both categorical and numerical columns.
Hi Is there any way to fetch the entities like catalog item or business terms which are not published(Draft and new assets) from one desktop?I tried the workflow state as draft, but its giving me the complete list of both published and unpublished assets. Is there any way to isolate them?
Hi Is it possible to fetch the last update timestamp from the history tab of an entity for example Business Term from one desktop?
Using v16.3.Here’s what I’m trying to achieve.I have some data:"id";"name"1;"apple"2;"orange" I need to generate some xml, eventually to have the data looking like: The ultimate purpose is to send a SOAP call and that xml will be used as the payload for the call.I tried using the Complex XML Assigner, and it tells me off for not referencing my data, but I can’t figure out the syntax.I’ve defined the top level to use the data stream “in”.And I’ve defined the “in” object with the id and name column. How am I supposed to use this?
Hi I want to fetch the relationship between a attribute and the corresponding term items in one desktop ( Not Business term, might be kpi or lobs) any idea how to fetch those relationships? I tried using termInstance entity in one desktop but its only fetching business term related information.I have tagged the KPIs like normal business terms and those can be visible in the glossary term section of attributes. Appreciate some help on this
Hi ,Is there any way to extract the lineage details in a plan in one desktop? Is there any particular entity which i can use to fetch the details?
A Catalog Item has weekly scheduled full profiling that also runs anomaly detection. However, it is a dynamic CI, meaning the logic can be edited depending on requirements. In short, it means that the ‘truth’ can vary depending on the requirement, meaning A, B, C was not an anomaly a year ago, but it is now. Currently, every profile ever run is stored, which makes anomaly detection less effective. Trends that were previously valid may no longer apply. Furthermore, retaining profiles from 7+ years ago is unnecessary and not allowed by law I suppose.A useful improvement would be an automatic limit on the number of stored profilings for a CI. When a new profiling run occurs, the oldest profiling would be removed once the limit is reached. A similar feature already exists in MP:Advanced settings → Results storage → Remove results after X runs.Applying this concept to Catalog Items would allow setting a limit (e.g., 25 runs), which should be sufficient for anomaly detection to set a trend a
Hi everyone,I’ve personally noticed quite a regression recently—after one of the newer Ataccama updates (even in our Cloud environments!), we lost access to the MinIO GUI admin console and several useful storage management features.I was wondering what caused this until I came across a report that explains everything: MinIO has officially killed off its free version (Community Edition). On February 12, 2026, their GitHub repository was updated with a final, definitive message: "THIS REPOSITORY IS NO LONGER MAINTAINED".What exactly happened: For the past 18 months, the creators of MinIO have been systematically stripping features from the free version (which explains the missing GUI we are now experiencing). Public Docker images and binaries have been completely removed, halting the ability to patch security vulnerabilities (CVEs). The only supported option left is their commercial product, AIStor, with a starting price of $96,000 a year. Since Ataccama uses MinIO under the hood as
Hi all,Some time ago I posted a question ('Published by' details via GraphQL) about how to make visisble who published for instance a glossary term.I noticed that like this you can't show who may have deleted the asset.Does anyone have a clue how to retrieve this details via graphQL (or in a different manner)?Kind regards,Albert
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.