Solved

Hello everyone,I’m working on a project that integrates a data masking tool with Ataccama, and I’m encountering some issues when trying to retrieve actual catalog item data (the row-level data) via the REST API. I’ve been testing both GraphQL and REST approaches, and here’s what I’ve found so far:GraphQL vs. REST for Data Retrieval:The GraphQL API appears to focus on metadata – attributes, versioning, policies, etc. However, based on my understanding, the actual table data (the rows and cells) isn’t available through GraphQL; it’s only accessible via a REST endpoint. Based on available documentation for MDM and RDM REST APIs, the REST endpoints follow a pattern using a fixed base path (/api/rest) on the default port (8051) and use basic HTTP authentication.Endpoint URL Confusion:Initially, I attempted to use an endpoint like:  https://teranet.test.ataccama.online/catalog/data/catalogItem/<gid>/datawhich returned a 404 error. Later, based on the docs, I switched to the documented

Hello, Is there any way I can pull a list of catalog items that have been associated with a policy via graphQL given the policy gid? If not, is there another way I can access such a list ? The Policy is a data usage license agreement that is an array or references on ONE Desktop’s metadata reader. Thanks,Karine 

Hi community,We have a usecase to set a property's value automatically: based on several conditions that property gets a value. First we considered creating a desktop plan for this. Then we figured it would be preferrable to have this value set automatically, something that can possibly be accomplished by applying computed content.We have used computed content before, mainly for concatenating values (like described in Computed Content: Show attribute values based on existing attributes (ataccama.com)). But in this case we would need to define a case statement to define the conditions and determine the value.So the question is, does someone know if sql-like case stamenent can be implemented as computed content? And if so, can an example be provided?Thanks for your attention and kind regards,Albert

I am able to fetch all the rule details like name, label, id, stewardship etc. But I am unable to get the dimension of the rule. I don’t find any entity relation between rule and DQ dimension. Could anyone please help me on this?

Is it possible to configure default value in Catalog item filter by admin? 

Hi folks,We’re on 14.5.3 right now, and we have a use case to display an embedded object in a grid view on a glossary term.Take my example here:glossaryTechnicalInformation is an embedded object array under my term entity. Inside glossaryTechnicalInformation are 4 simple string scalar properties. But yes I forgot to give it “name” property, my mistake.When I add some info in there, I get a guid. I know I can get it to display the “name” if I give it a property “name”, but then, I would only get the “name” to display in the page.Is there some way to make it display like this? (excuse my poor skills in Paint!) 

Hello everyone,I was looking through the email templates and was wondering if it would be possible to create one for the tasks dashboard? I know its possible to enable these for monitoring projects, but would like to know if there's any way to also enable them for updates to tasks, ie task assigned, task status changed, task deleted etc. Searching through the documentation I haven't seen anything relating to this, Any help would be very much appreciated!

Hello,I am looking for guidance on ensuring automatic data masking/hiding during data exports to csv/excel files based on Data Protection Classification in Ataccama ONE.From the documentation, it appears that access to sensitive attributes (ones tagged with terms that have data classification tags applied to them) can be restricted for unauthorized users, but I would like to confirm:1.  How can we configure permissions to ensure that unauthorized users can still export data but only receive masked/hidden values for classified attributes? What permissions do we give them?2. Is it possible to automatically apply masking transformations based on classification tags, so that even authorized users exporting data only receive masked values instead of raw sensitive data?3. Are there any recommended workflows for enforcing automatic masking at the export level while leveraging Data Protection Classification?Thank you,Karine

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,Albert

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?

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 ? 

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

HiI 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 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.

We made changes into the clean operation of an entity. it will take effects for new transactions.How can we apply this to the current records that we already have into the database? We are exploring use a full reprocess of this entity:but we have some doubts about the setup. For example:What is the difference between a reprocess vs rematch checkbox? We tried to read the documentation but there is not detail explanation about it. Thanks in advance!

HiI 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_SOURCEFROM    db.schema.view1    WHERE     subj_type = 'English') ...I wanted to replicate the same in Ataccama ONE Desktop using the Group Aggregator step, whereI allocate each sub-query in one aggregation set with a condition of subj_type = '<value>' in the When condition. For each column in the SELE

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 <=10000Our 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 

Is there a way to quickly select only distinct rows in Ataccama One Desktop? (I now used a record descriptor and filter with Regex find(“.:.:1”, rd_column)

How do we activate Business Domain Analysis option in Profiling section. 

Hi Ataccama Community, I want to upload a CSV file which is an export of DQ monitoring project results to SharePoint folder. I couldn’t see the Task SFTP upload file step in my OneDesktop (version 15.4). Is this step not available in the current version of Ataccama OneDesktop ? Or is there any work around to upload the CSV files to the Share Point server. CheersManidhar