Data Quality & Catalog ⚙️

Hello,I’m setting a new connection for Snowflake datasource, and I need to use key pair authentication for this.In the credentials drop-down menu it doesn’t look like this option to be present:  What do you advise?

At our site we have Ataccama on premise and several sources from different data systems. It happened a couple of times that profiling on one of the sources was no longer possible and that we found that out more than a week later. After which it was difficult to track back why this happened.We do have monitoring of all kinds of Ataccama components with Prometheus. But that didn't seem to detect these issues. I was looking for a way to monitor profiling functionality.So what I came up with was a monitoring project that profiles a small table from each source, every hour.Since you can schedule a monitoring project every hour at least, and since you can add notification in case of failure, this gives us warning at most near 1 hours after something breaks.Just adding a catalog item of a table to the MP turned out not to be sufficient though. Because when the monitoring project ran, it did only a structure check, not a profile. To get it profiling, it needed an anomaly check.When you do an a

We have a question. The basic viewer can view the global settings and with that also a list of users. We'd rather not share this info with the basic viewer. How can we change this?

Easy question: I used to be able to use this AQL search to look up tables with specific purpose tags, but it’s no longer working with the upgrade to 14.3. Does anyone have a suggestion? Here is the AQL search I used: dataInstances.any(displayName = '[Purpose Tag]')

Hi everyone!A new week means new best practices! This week we will focus on Anomaly Detection to our new Data Dictionary so if you haven’t started to follow our forums - click on Subscribe now to not miss out on any news 🔔 Easiest way to follow us is by selecting all forums you are interested to follow from our homepage and hit subscribe. Now let’s dive in! Anomaly detection is a pivotal tool for ensuring data accuracy and quality by identifying irregularities and inconsistencies within datasets.Why Anomaly Detection MattersAnomaly detection is your safeguard against data discrepancies and plays a crucial role in maintaining data quality and relevance. With this service, you gain the following advantages:Swift Issue Resolution: Users are promptly notified of potential data discrepancies or pipeline variations, enabling timely problem resolution. Enhanced Data Quality Monitoring: Monitor your dataset's quality to ensure its alignment with actual data conditions. This, in turn, improves

How to extract the root of JSON result which I got from GET api call from JSON CALL step .?I am able to fetch the attributes of root but I am unable to fetch the root itself .

I’d like to check if I am listing the correct steps to add a DQ rule in an existing Monitoring Project, and the order in which to take them. I am quite new to Ataccama so please excuse my ignorance. Can anyone please confirm or adjust them? Many thanks in advance! How to add a DQ ruleCheck if the rule you want to apply, already exists out of the box. For example, if you want to say a certain field cannot be empty, you can apply the predefined rule: String completeness. Other standard checks include validation of email addresses, and URLs. Go to Monitoring Project, tab Configuration & Results Choose the file you want to check (either a VCI or a Parquet File – the latter starts with PF). Choose which attribute you want to check In the 5th column, add: applied DQ checks Doublecheck whether the scoring of the rule is correct (some of the standard rules have a scoring of 0 – you might want to change that) In the upper right hand corner, choose “Publish” Run monitoring. This will take so

How to implement Timeliness rule in web application 

Hi everyone! This week’s last best practice post is on Monitoring Project Results Retention! Managing data retention is crucial for maintenance and security purposes. Whether you want to keep results for a specific duration or limit data storage based on the number of runs, Ataccama's Monitoring Project Results Retention feature has got you covered. Flexible Retention SettingsWith Monitoring Project Results Retention, you have the flexibility to choose how long you want to store the results of your monitoring projects. This can be defined in two ways: Per project configuration: Keep the last X runs. Remove runs after X days. Global configuration (available to power-users only) that takes precedence over project configuration: Keep the last X runs. Remove runs after X days. When global settings are configured, you'll receive notifications in the web application.For more details on configuring global settings, check out Monitoring Projects Global Retention.When Data Will Be DeletedMo

Hi Team,I have tried to create Accuracy rule for Date datatype to check whether Date is in the standard format. Accurate rule should be as follows:Standard date format is ‘MM-DD-YYYY’. If date is entered in any format other than the above mentioned (‘DD-MM-YYYY’ or ‘YYYY-MM-DD’ or ‘YYYY-DD-MM’) then it should be considered as inaccurate.When I tried using regex expression, I am getting error. Any ideas?

Is there any way that we restrict accessing the data that are imported to Ataccama Thin client ?, as we do role based access , we are able to see all others catalogue items imported into Thin Client.Such catalogue item view breach the data classification compliance which is managed in main data factory where we store the data.Anyone suggest here your thoughts to how restrict the data by giving right access / restriction while we importing the catalogue item or any measure we can take to restrict in viewing the catalogue items within Thin client w.r.t catalogue item import owner?  

How can we implement concatenation of the last 10 rows in a column?I am looking for a way of storing previous values in a variable and adding the current row value to the variable like that.

As per requirement I want to read a marker value from a file and pass that value as parameter in select SQL of a JDBC reader to pull only delta records. Is this possible in 13.9.1 version? Please advise with documentation link if available.

How to implement a DQ rule to check if an attribute's value is present in another attribute (for eg. Attribute1 'Product' value is present in Attribute2 'Quantity' field) using Thin client

Hi everyone! In the last part of Monitoring Projects Configurations, we will talk about how to easily import configurations from one monitoring project to another, making your data quality monitoring more efficient. If you’ve missed Part 1&2 you can find them below:Import the Configuration Instead of creating a new project from scratch, you can copy the configuration of one monitoring project and apply it to another. This is particularly useful when you want to replicate settings from a testing environment to a production environment. The copied configuration includes all checks, invalid samples, reports structure, and DQ filters.To import the configuration:Navigate to the project where you want to apply the configuration.   Expand the more options menu and select Import configuration. Choose the monitoring project from which you want to copy the configuration, from the list provided. Check if the preselected catalog items are correct. You can modify the list by deleting items or

The source csv file has splitted into 13 rows for each actual row in target.By using Ataccama one desktop we would like to pivot the data by sending source 13 rows into one row in target. I am trying to implement the logic below in the Text file reader step but it's not working . v_RowNum =  iif(v_RowNum IS  NULL,0,v_RowNum+1)                    -------- Initialize v_RowNum to 0 if NULL; otherwise, increment it by 1 for each row.v_CurrentNumber =  iif(v_CurrentNumber%13= 0, v_CurrentNumber+1,  v_CurrentNumber  ).    -- Increment v_CurrentNumber by 1 for every 10 rows.GENERATED_NUMBER= v_CurrentNumber GENERATED_NUMBER INTEGER   Please  help us  to make it work in Ataccama one desktop .

Hi everyone! In this continuation of our best practices post on Monitoring Project Configuration, we will explore additional settings and actions to ensure seamless data quality monitoring.Check out the part one of the series if you’ve missed it:Disable Rule SuggestionsPower users can disable rule suggestions in monitoring projects. For more details, refer to the link provided in the text. Set Partition DefaultsFor partitioned tables in monitoring projects, identify them with the provided icon. Define default analysis for partitioned tables using the more options icon and selecting either Last partition analysis as default or Full analysis as default. These settings will be applied when running the monitoring project. See the link provided for more information. Anomaly DetectionWhen running anomaly detection during monitoring projects, choose between the time-dependent model or time-independent model. Configure the sensitivity of the detection as well. For further details, check out th

My input file is in the below structure and looking to pivot all rows into columns. No name 1 value1 2 value2 3 value3 4 value4 5 value5    Expecting output should be like  Col1 Col2 Col3 Col4 Col5 value1 value2 value3 value4 value5   What will be the best approach in Ataccama One desktop? Looking for support and help..

Json : [   {      "Headers":[         "Empid",         "Name",         "dept",         "EMAIL"      ],      "ID":"Table_112",      "Rows":[         [            "100",            "John",            "Finance",            "John@gmail.com"         ],         [            "101",            "Smith",            "HR",            "Smith@gmail.com"         ],         [            "102",            "Derek",            "Marketing",            "Derek@gmail.com"         ]      ]   }] Expecting the output in below format:Empid Name dept EMAIL ID 100 John Finance John@gmail.com Table_112 101 Smith HR Smith@gmail.com   102 Derek Marketing Derek@gmail.com      I have created a plan with below details:After running a plan with JSON CALL step below response file got created.   Based on response file i have given below columns in Data Streams    I am not getting the out put what i expected. Appreciate your help and support . 

Hi Community!In the next few days, we will discuss Monitoring Projects, a powerful tool to evaluate and monitor data quality over time for selected catalog items. Monitoring projects use DQ checks, automatic anomaly detection, and structure checks to maintain data quality. We also have a short video introduction to Monitoring Projects, go check it out here 👇 If you are ready, let's dive in 🤿 Accessing Monitoring ProjectsTo access Monitoring Projects:Go to the left-hand menu and select Data Quality. Choose Monitoring Projects.     In this section, you'll find all configured projects. If you want to start a new project, click Create.Each project listed will show the following information:Name: The project's name. Terms: The glossary terms associated with the project. Items: The number of items monitored within the project. Latest run: The date of the project's last evaluation.   The current state of a project is indicated through row highlighting, showing if it's published, recently ad

I would like as an example to have one ‘MS Teams’ channel for one DQ Monitoring to reach out different groups of people tus set up diffirent Teams connections  Is there any option to set it up in the current version? cheersPiotr 

Hello Community! In this second part of the lookup best practices series, we'll cover how to schedule automatic rebuilds of Lookup Items and provide some useful tips for managing your Lookup Files effectively. If you’ve missed the first post you can check it out here: Scheduling Lookup Item RebuildsAutomating the rebuild process of your Lookup Items can save time and effort. To schedule automatic rebuilds, follow these steps:In the Lookup Item, select the more options icon, and then click Schedule.   In the sidebar, choose Add scheduled event.   Set up the scheduled events for the rebuilding of lookups. For more details, refer to the Scheduler documentation.Managing Lookup FilesEditing Lookup FilesOnce Lookup Items have been uploaded, you can edit them manually or reupload the files if necessary. To edit the lookup manually: Select the required item. Click the more options icon, then choose Edit.   To reupload the lookup item: Select the required item. Click Upload new version

Hi guys, I'm doing the dq foundation course and I'm stuck.I have tried to look it up, but no result.This is on an environment in the portal.When I'm doing, with AVG or avg, this:It says:How do I make this work? Kind regards,Marcel

I have a legacy database without primary keys.  I know how to evaluate a single column for uniqueness, and thus a primary key. How do I evaluate multiple columns which together would be unique and thus be a composite primary key?