Data Quality & Catalog ⚙️

By using one url we imported multiple tables structure from workday into Ataccama. if we need to query any specific imported table in ataccama is ataccam will dynamically updates the API endpoints ?

Hi Community, The purpose of the follwing scenario is to update multiple term names and definitions. I have created a plan that writes the terms names, definitions and GID to a csv file. In that file I can make updates on the names and definitions. With another plan I read that file and write it back into Ataccama. That works well, except in the following case. The text in the Definition can be entered on multiple lines by using the Enter button. So OneWeb will show: Text on line 1.Text on line 2.Text on line 3. In the export (the csv file) the text will look like this: "[{""type"":""paragraph"",""children"":[{""text"":""Text on line 1.""}]},{""type"":""paragraph"",""children"":[{""text"":""Text on line 2}]},{""type"":""paragraph"",""children"":[{""text"":""Text on line 3}]}]" If you import the text like this, the content will not appear on 3 lines, but literally as above and on one line. How can I import the text so it is on 3 lines again? Thanks for any suggestion. Kind regards, Albe

For example, if there are multiple rules applied on an Attribute that is CDE then would it show filtered Data Quality Score based on the nested rule that is implemented. Can it be checked or configured in Ataccama One WebApp or it would need to be done in Ataccama One Desktop ?

In Monitoring Project Data quality rule suggestion works sometimes and it give rules already used or as per term assigned to catalog item but most of the time it doesn't work. At point of time, rule suggestions appear, and they disappear when you want to check again. How the rule suggestions work in Monitoring Project of Ataccama? Is there any pattern or do we have to do something so that we can rule suggestions?

Is there a way to identify usage stats, last login etc easily? or if someone has built a query to show this information? I would think the admin would have an easy where to manage users access / licenses etc

Is there a way to retrieve all the workflows deployed on the Ataccama runtime server? For instance, we can obtain all the monitoring projects and post-processing details from the Ataccama metadata model. Additionally, I would like to get the workflow names along with their associated plans and component files from the runtime server.

While importing the configuration in Monitoring Project from different monitoring Project, we can map catalog item but unable to it on column level. Here column names are getting changed in databrick layers (foundation, Enriched, curated). Is there any way to import configuration from one project to another project with column mapping as names gets changed?

Architectural Diagram for Data Quality and Governance

I am new to Ataccama and have some basics questions on how to start . is the ataccama one desktop and DQ analyzer are same tool or different ? i have installed ataccama one desktop but how to get trial license ?

How do we create a detection rule which either using both data and metadata option in same rule or ability to add multiple detection rules on business glossary with AND and OR conditions both working together and not just one option?

Can the API response generated from the Data Quality Firewall feature be edited?

Hi I have with great success been using your free desktop version of DQ Analyzer. But the license has run out. Last time I had this issue a new download and a re-installation solved it. I have tried to do the same, but it did not work. See issue “DQ analyzer windows version update” for further details. Any advice what to do?

The Business wants this date attribute validated. I don’t know why, it’s a key field and I assume managed by the DB. Nonetheless, I need to build a rule. But I think it’s strange that the Data Type is DATE while the date values are YYYY-MM-DD. I would expect to see DATE format data in the MM-DD-YYY HH:MM:SS AM format. I don’t know how to code it in the date functions since it doesn’t have the standard date format and it doesn’t work in any string functions. Any ideas?

I have created a plan for data quality checks using Data Quality Indicator, and it will produce an excel file which flags each records with error_messages corresponding to each checks, and a summary txt file. Now, I have created a workflow using Run DQC and Send Mail step. The requirement is to soft code the below values in the email template. Summary excel file Below is the email body: Dear Business Users, Please find the attached Error Result (Error_Report.csv), which details the records that failed validation and their respective error types. Summary: Total Processed Records(Total): Total Error Records(Success_Count): Error Types(Code): We recommend reviewing the attached file and taking the necessary corrective actions. If you need further clarification or assistance, please feel free to reach out. Best regards,

Is there a method to create a single rule for identifying duplicate records based on all columns in a table? This rule should be applicable to all tables, regardless of the number of columns they contain. Current situation we need to add the column to use aggregated rule. It is very difficult if the columns are more than 10 or 15 in table.

I am making a DQ evaluation rule in ataccama one ui where I have to subtract each long value of catalogue item from its corresponding long value in lookup and if the difference is greater than 100, I want to raise that particular value as invalid sample, so far I am not able to achieve this, it would be great if anyone can help me with this.

Is there any way to get notification for data Profiling schedule failure with log details or successful.

Hi I have a sub-query in Snowflake that is using the function of LISTAGG and PARTITION BY in multiple SELECT DISTINCT statements for example LISTAGG(DISTINCT TRIM(SUBJECT_REF), ' | ') OVER (PARTITION BY IDENTIFIER) AS EN_NUM_AGG, kindly see attachment to see the full SQL statement. Example of one of the subqueries: … en AS ( SELECT DISTINCT IDENTIFIER, ID, LISTAGG(DISTINCT ID, ' | ') OVER (PARTITION BY IDENTIFIER) AS ID_AGG, TRIM(SUBJECT_REF) AS EN_NUM, LISTAGG(DISTINCT TRIM(SUBJECT_REF), ' | ') OVER (PARTITION BY IDENTIFIER) AS EN_NUM_AGG, DQ_EN_CARD, LISTAGG(DISTINCT DQ_EN_CARD, ' | ') OVER (PARTITION BY IDENTIFIER) AS DQ_EN_CARD_AGG, DATA_SOURCE, ORIGINAL_SOURCE FROM db.schema.view1 WHERE subj_type = 'English' ) ... I wanted to replicate the same in Ataccama ONE Desktop using the Group Aggregator step, where I allocate each sub-query in one aggregation set with a condition of subj_type = '<value>' in the When condition. For each column in the SELECT DISTINCT subquery if it is a non-

We’re using version 15.4, mostly in the web tool. We’re trying to a subset of our input tables for testing before implementation the full table(s) in Production. We looked at using Data Slices, but we found that the ROWNUM feature of SQL met our purpose better: select * from (select * from dbname.tblname) where ROWNUM <=10000 Our primary question is how do we link/connect the SQL View and/or the Data Slice to the DQ Rule. We believe that it occurs in the Monitoring Project. I looked thorough the Ataccama online documentation, and the Community, but I can’t find the options to make these either of these connections. Any ideas! Thanks! Tim

What is the AQL to filter all catalog items’ attributes tagged with a particular term?

Hi all, I would like to share the guidance of Ataccama Support regarding a question that I had with respect to using relationship types. I suppose the question will become relevant for us all at some point. So hereby the question and Ataccama's response. Question “In the metadata model we can define relations between entities by means of references, or we can embed properties from other entities etc. Another way to define relations between entities is by means of relationship types. The latter option allows us to visualize the relation in for instance a relationship tab, like there is for terms. Suppose you are to model new entities. There is no requirement to have this visualized in a relationship tab. So you define a reference from one entity to the other. Later a requirement pops up from a new project, that the relation should be depicted in the relationship tab. So, unfortunately, not possible. Changing the reference into a relationship type is a major system change. Then always ch

Hi all, Can anyone help me with what this Add location feature do which is available in overview tab of Source connection?