Learn & Share

Hello Team, I am trying to create a rule for a column “account_number” in a dev table. We are using version 14.5 and “One Desktop” to create the rule. The requirement is to create a rule which removes the leading and trailing whitespaces from the records of the column. I tried defining below expressions in the Column Assigner step of the plan. The final step of the plan is the JDBC Writer step. trim(account_number) squeezeSpaces(account_number) trimRight(account_number) Once I make the changes, I save it, run the plan and the plan executes successfully. BUT when I check the records in the database… the whitespaces are still there in the database table records. Can you please help me understand how to fix this? Which expression should help remove the whitespaces from the records? Thanks, Dhruba

Hi all, In a JSON call-step in a Desktop component I use a query like this in order to retrieve the Version and Published on details. {"query":"query getDetails { product(gid: \"#IDAta#\") { gid draftVersion { name _effectiveFrom { id timestamp } } }}"} Does anyone know how to expand the query so that also Published by is retrieved? Kind regards, Albert

Hello everyone, How can I remove multiple characters, including the single quotation mark, for each row in the INPUT column with a string data type in OneWeb (advance expression) , e.g :- INPUT RETURN VALUE 'Tom Smith' 'Laura Jones' Tom Smith Laura Jones Tom's Toms NULL NULL Thanks in advance. Sabyasachi

Adding more details to a list view and providing additional filtering options can help business users in their daily tasks as you scale Data Governance across multiple teams, geographies, or business functions. In this article we’ll customize the Business Glossary to show additional term attributes as columns in the list view and to enable filtering by those attributes. This approach generally works across the Ataccama ONE Web app, so you can use this article as a guide to customize other pages, for example Rules, Catalog Items, or Monitoring Projects. You don’t have to be a developer to follow this guide. If you come across any concepts you’re not familiar with, have a look at our documentation. Adding columns First, navigate to the Business Glossary’s Terms list. In the top right, find the 3-dot menu which features the option to Edit page. In the side bar that opens up, go to the Layout tab. You’ll see the JSON that describes how the objects are shown on this page when the web app lo

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 REST

Audit logging should include all user activities within Policy Management.

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

We need to extract the Rule and other Metadata from Monitoring project. Below is the set of Metadata Information that is required DQ Rule UID - Ataccama system generated unique identifier of Data Quality rule Name of DQ Rule Definition of DQ Rule Threshold DQ Dimension DQR Owner DQ Rule Start Date DQ Rule End Date DQ Rule Creation Date DQ Rule Modified Date

We want to evaluate Data Quality Score of Rule after applying the filter condition so that DQ Score gets calculated based on subset of records which are applicable for a rule rather on the whole set. For example, we want to execute the DQ checks only on the records satisfying the filter condition such as ‘Product_Type’ = ‘DS’ We have taken the approach of SQL Catalog item to filter the records. Is there any other workaround for this problem ? With the SQL Catalog option, we will have to create multiple SQL Catalog items to implement the different filter condition if needed for each rule. For example, if there are 2 rules, we need to use 2 SQL Catalog items and similarly would need to use 10 SQL Catalog items for 10 such rules. Therefore, we would like to understand if there is any workaround or alternate to deal with this situation ? Please suggest.

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

In data observability, after configuring a source and setting up a schema for monitoring, the Schema Changes tab displays all detected issues. For each issue, recommendations such as "Update in Catalog Items" or "Import into Catalog" are provided. Is there a way to automate the process of updating newly added or missing catalog items in the Knowledge catalog section and need to view the Profiling results for the newly added attributes (When Change = ‘New Attribute’ in data observability).

There is column called Sales Amount (Long Data type). It has values in decimal point. I wanted to create a DQ evaluation rule that It should have exact two places decimal point. I tried to create rule by converting long to string and validated length after decimal point as 2 but failed for values 1.00 or 2.10 or 0.00 as conversion to string change value from 0.00 to 0, 1.00 to 1 or 2.10 to 2.1 Is there any way to implement this?

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?

Hi All, I have a question regarding RDM approval workflow. In our project, we have stages Initiator → Review → Publish. We have a customer request to allow RDM_admin users to participate in the approval process (i.e., they must be able to review and publish records) but not receive any email notifications. We tried removing RDM_admin role from Notifications section, but that didn’t help because this role remains in Workflows section. We can’t remove RDM_admin role from Workflows section, since that would prevent RDM_admin users from reviewing or rejecting records at all, they wouldn’t be able to participate in Approval workflow. The following settings don’t work, RDM_admin users still receive emails: Is there a way to keep RDM_admin’s ability to review and publish without receiving emails? Perhaps by checking user’s role or username in the Conditions section, so that Approval workflow gets skipped for certain users? The documentation for version 15.4 mentions something like meta.userna

Hello, I am trying to filter the monitoring project results based on filters value (Filter_val) and filter_id. The results sometime work fine, but sometime not. Is there a way out for this? Something to do with ‘Value Separator’ I believe.

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!)

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

Is there any way to create a calculated attribute on existing data using “Add Attribute”. As there is no option to add existing attribute in the table while creating attribute using “Add Attribute”. Is there any example how to use it? I have created one it contains only blank values.

Hello everyone,I'm currently facing an issue with accessing Tableau content through Ataccama. Although I've successfully connected to various Tableau Server sites, most of the content remains inaccessible due to group access restrictions. The only workaround I've seen so far is granting the connecting account a site administrator explorer role on Tableau, but I'd prefer to avoid this elevated access if possible.Has anyone encountered this problem and found a solution that doesn't involve using a site administrator explorer role? Any insights, workarounds, or experiences would be greatly appreciated. Thank you, Karine

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