Data Quality & Catalog ⚙️

Hi Community,Is it possible to have a email notification to a group of people in case of an update in the existing policies in One Web?

Hi Team, I am trying to json call to read the response of api and process it for further results. This is my example response { "Data": [ { "Name": "Amount", "Id": "12345", "ValueListAttribute_5d": [ { "term": "Attribute", "term_Id": "67" } ], "StringAttribute_00": [ { "definition": "Dollar amount", "definition_id": "5" } ], "BooleanAttribute_18e": [ { "indicator": "true", "indicatorid": "6" } ], }, { "Name": "Amount", "Id": "12345", "ValueListAttribute_5d": [ { "term": "Attribute", "term_Id": "67" } ], "StringAttribute_00": [ {

How would I validate a string in the format YYYYMMDD is a valid date?  I assume the range of valid years is 1940 to 2050.

I am trying to create a SQL catalog item to filter out the inactive records.  When I create the SQL catalog item I get the following error message:SQL compilation error: Object 'DEV_SOURCE.SAPMDG.VTLFA1' does not exist or not authorized.I can see the data tab for this table.  I can run profiling/DQ insights tab so I’m not sure what is happening.  I have created the query with the schema name and without the schema name. Shouldn’t the credentials be the same to create the SQL catalog item?

Hi, How can I send a file to SFTP folder using below task item? I am using Desktop version.Can someone help me how to get the required fields from the below screenshot? I have the location where I want to drop the file. 

Hi,I am trying to validate the date given between 100 years ago and 15 years ago are valid , everything else is invalid. I am able to achieve this validation in YEAR part. I am looking for validating complete date instead of only Year part.Below are few screenshots.  

Hi Community,Is it possible to fetch the policy creation or last update date for Policies, in order to make a DQ rule around it in Ataccama One? My use case is to build a DQ rule which will notify the stakeholders based on a timeframe after which the policy has been created or last updated, but unfortunately i am not seeing any property to fetch the Created or Last Update date. 

Glossary terms are used to add more metadata to different assets in the Ataccama ONE, they are necessary for data quality evaluation of Catalog Items after profiling. 👉 Get Certified with Ataccama article series#1 Adding Data Sources#2 Add a Data Source to the Catalog 🔎 LET’S TEST YOUR SKILLSUsing the ONE Web App, in the ONE Business Glossary module, create business terms for '<your_name>_Blood Type', '<your_name>_Rhesus Status', '<your_name>_Blood Group'. Using the ONE Web App, in the ONE Business Glossary module, configure the business terms '<your_name>_Blood Type' and '<your_name>_Rhesus Status' as child terms of the parent term '<your_name>_Blood Group'.💡 How to do it? Navigate to Business Glossary in the left navigation menu and click on Create in the top right menuSelect Type - Business Term, fill in Name and SaveYou will see that your business term has been successfully created, repeat the same process for remaining business termsOnce you

Hi,In one of my Monitoring Projects I am apparently missing input attributes for a DQ rules which doesn't appear anymore in my MP. The error, however, is still there. How can I get rid of this?  

Hi Community,I have created a custom entity with parent type as Term as “Class”. Now when i linked it to the catalog items and attributes using Reference Array writer its showing in my Custom Class section in the attributes as well as in the Catalog Item. But unfortunately i am not able to see it in the occurrence tab of this Custom Entity. Is there any way to add some properties in the Occurrence tab so that i can see the link for custom reference arrays. Any help is highly appreciated. 

Hello community, I need to retrieve KeyCloak user information (e.g., email address) based on their username using Ataccama One Desktop. Has anyone done this before? If so, can you please share your experience or point me to some documentation?Thank you in advance for your help!

Hi, I’m working with data stories, and I’ve created a custom metric to represent by using percentage format.This is the metric expression:iff(sum("Valid") + sum("Invalid") > 0, round(sum("Valid") * 100/ (sum("Valid") + sum("Invalid")), 2) / 100, 0)Both “Valid” and “Invalid” are defined in Snowflake as REAL datatype.I’ve read this article Create Custom Attributes :: Ataccama ONE and I’m using round function, but it doesn’t work.Thanks in advance,Gaston 

Hi Team,Is there a way to update the existing Term name or description or any property like termInstance from One Desktop metadata writer? I can only see option to add or delete but no update option. Any idea is highly appreciated.

Hi Team,I am trying to add my Business Terms in two separate child folders inside my Business Term Folder(Not Data Domains). Just wanted to know if its possible or not?I have created two child folders inside from navigation in settingsBusiness Glossary→ Terms →  Business Terms → Folder1Business Glossary→ Terms →  Business Terms → Folder2But unfortunately i am not sure how to add Business Terms in those two folders specifically, the normal Business Terms are added directly in the parent folders. Do i need to do some changes in the metadata model for this one or need to create any AQL filter for this folders(Same as Datadomains). Any tips or help is highly appreciated.

I am currently using 14.4.0.one-44751-landing-pa-230616-287787-f83b54a4 ONE web application version. While creating a Uniqueness Rule I am not getting WHEN condition as “is unique” and “is not unique” . Could someone help me understand why I am not getting the uniqueness condition  instead Validity condition.  

How can we handle csv output from API response?I tried to use json call ,SOAP call but it didn't work.Anyway, can we handle in One desktop csv output from API.

Hi,I am running a workflow that includes a task called 'Execute SQL'. This task updates some values in the SQL database, but the code is quite heavy. When the workflow reaches this task, I encounter the following error message. Can anyone assist?  

Hi Is it possible to tag Terms to the attribute metadata present in one web, while importing the terms in bulk from one desktop?Ask: Attributes and Tables are already present in one web. Importing business terms from csv file using one desktop.So while importing the business terms using one desktop is it possible to directly tag those business terms with their corresponding attributes?(The tagging list also i want to provide in a csv file and don’t want to use the automated tagging from ataccama)

Hi,I have two columns: first name and initials. # first_name initials 1 John J. 2 Robin Earl R.E. 3 Mark Tate Lynch M.T.L. 4 Bert Ern B.E. 5 Johan Flugg J.F. Is there a DQ rule that can check if the two columns are correctly in synch in what they should be? I understand checking the initials format is one thing, but I actually want to check if it is correctly formatted based on the first_name column. Looking for a preferred solution in ONE Web.

I have been testing rule specific notifications within monitoring projects and it seems to add those notifications to the bottom part of the general notifications, but we are trying to see if we can receive separate emails due to different users needing to see specific issues.The documentation link is shown in the link below,https://docs.ataccama.com/one/latest/monitoring-projects/results-reports-notifications.html#specific-notifications  

Hello: I would like to create an alert - while scanning the datasets - if it flags any data to be PII (such as Social Security Number, Data of Birth, Tax Identification Number) etc., Is there a way to get alerted when a specific term is assigned to any catalog item attribute? 

I’m hoping someone can help.  I created a term called Personal Information (PI).  I’m trying to create a detection rule to find all columns that are considered PI.  Ideally, I would be looking at both the name and the data within.  Is that even possible?

I have data coming from a SQL database. For most queries, the structure of these queries remains the same, as shown in the picture, with only the attribute name changing. Now, I want to classify these queries as unique based on their structure rather than the attribute name.Demo DataThank you.Regards,Dhaval