Unanswered questions

Hello all,I am running into an issue when trying to grab terms from attribute items. My current use case is as follows. I have a list of catalog item that are tagged with a term (that we refer to as a jurisdiction) and I am attempting to first find all attributes associated with these catalog items and then find all terms that are tagged to these attributes. The order is as follows:Find all catalog items with term → get all attributes associated with catalog items → extract all terms on attributesMy plan looks like this: The issue that I am running into is that these plans take a very long time to run sometimes upwards of 30min to an hour depending on the term. I would like to know if there is a more efficient way to do this (either through graphql or some other components etc) or if I am simply stuck waiting with the current speed of the plan. Best Regards,Andrew

Hi All - Looking for design advice on tables that have related data that is not required (as in the case in the “relationship” where it’s parent-child and required).Take the following example: cost codes that can be related to different hierarchies of “groups”: “departments”, “project groups”, “governance groups”.  Each of the organizational groupings have their own relationship to cost code - but not all of them are required to use cost code, which rules out using a parent-child relationship. Also, it’s not necessarily an Mn Relationship, because each “group” (at whatever level) can only have 1 cost code, if it’s related at all.Additionally, we are not implementing any synchronization from our source systems due to security constraints - so things will be either manual or import by UI or plan if that makes a difference in terms of usage.I’m thinking about creating a junction table to hold the related values - but that doesn’t seem ideal from a user/UI perspective, because then users w

!--startfragment>Hi everyone,I'm working on a plan in Ataccama Desktop where I want to automatically assign Data Quality (DQ) rules to attributes based on their associated tags (terms). My goal is to streamline DQ evaluation by leveraging the Business Glossary and ONE Metadata Writer.Here’s what I’m trying to achieve:Build a plan in Ataccama Desktop that:Reads metadata from ONE Applies DQ rules based on tags Writes back the results using the ONE Metadata WriterHas anyone implemented a similar setup?I’d love to hear best practices, tips on configuring the Metadata Writer, or examples of how you’ve mapped terms to rules effectively. Thanks in advance!Philipp !--endfragment>

Hi ​@anna.spakova ​@Lisa Kovalskaia ​@Ataccama Community Admin I looked into the documentation for Ataccama ONE (the Ataccama data-management platform) regarding source/connectors and could not find a clear statement that it directly supports a connector to Google Analytics 4 (GA4).Could you please confirm the possibility?

Can we create interactive fields like “upvotes” or “likes” directly inside the Catalog UI for user interaction instead of using comments sections?

I have a requirement to develop a rule that checks value of an attribute should be from a given list of values. The attribute should have at least one record of each of the list item. It should fail if any of the values don’t appear in the attribute. I cannot consider lookup as lookup will perform OR operation on the given list, instead I would like to have AND operation. e.g., list of values List1 = {1,2,3,4,’pqr’, ‘abc’}, column name = Col1Test case - Col1 should have at least one entry of each item from List1. It should fail if any of the 6 values from List1 fail to appear in Col1 values Thanks for the help in advance! 

Hi ​@anna.spakova I am trying to write invalid data into DB using JSON Call. For that I want to first get the invalid values from the “Show Invalid Samples page”Not like any other array in JSON, the values array does not have key - value structure. Instead, it is like values: (array) 0: <no key> only values. When I run ONE Desktop Plan, I am only getting blank rows. Please help Thanks.  

Looking for ways to access the backend data storage for Ataccama ONE. We’re currently developing an internal data quality dashboard that needs to pull data from ONE to build visualizations in Power BI.Thanks!

I have created monitoring projects in Ataccama ONE . I don’t want those reports to be stored into MinIO. Instead, I would like to export those reports in csv format through Ataccama Desktop platform. How can I do that?

Hi,I added a DQ Rule on a boolean data type attribute inside a Monitoring Project (MP). After the attribute changed datatype I had to add a new DQ rule with string attribute, but the old DQ rule vanished. How do I get rid of the error?  

One of our teams need to use ataccama as a self service tool and catalog the excel file. How to do that?​@anna.spakova 

Hello ​@Lisa Kovalskaia ​@anna.spakova I have a requirement to do DQ of few tables that have names changing as per schedules of a release. e.g., Table Name could be Table1_release_1 etc. The database and schema are constant. The scope/structure of DQ attributes is mostly same.For now, I think it will need manual intervention to onboard new objects → Add DQ on attributes and then add monitoring projects manually. Is there any way we can automate this process?I am using v15.4

Hi I have tried looking into an article on how can we do data reconciliation on Ataccama, but I only found that can be achieve in Ataccama ONE Web, not on ONE Desktop. How can we achieve the same in ONE Desktop?My use case is, I want to know the number of rows between two tables from two different databases - Oracle and Snowflake. I tried doing that in ONE Web but it took a lot of time to load.

Hi everyone,I’ m having an issue with missing DQ results  in one of my dashboards.The dashboard had been running successfully for a long time, but it failed on July 27. After investigating, I fixed the issue on October 16, and it has been running normally since then.  However, the DQ results  between July 28 and October are missing, most likely because the dashboard didn’t run during that period or it failed for some reason. Is there a way in Ataccama to rerun DQ jobs or recalculate results for specific past dates?Or is there another recommended approach to fill this gap in the DQ dashboard? Thanks is advance for your help!Ece

Hello! One of the engineers on my team noticed that when trying to configure notifications for when Anomalies are detected on a monitoring project that it only works if the Data Observability for the source is also configured for Anomaly Detection and to send emails. Is this behavior anyone else has experienced in V 16.2? Is this intentional? It seems odd that these would be linked, I would think that users would want to be able to configure Anomaly Detection independently either at the source or the project level, and that the audiences for those anomalies might be different.We’re currently working through a bug where this is working this way in our dev instance and not working at all in our production environment. To clarify, this is not about the general Monitoring Project Run Completed email, which includes info on anomalies, data quality, etc., this is just about the “Anomalies Detected” notification on monitoring projects. This has occurred in multiple instances in Dev and has no

Hello folks,I am creating a new connection on web application for OneDrive/SharePoint using Microsoft Entra ID; while doing so there's this field (Drive Id) which is optional if you have multiple drives and you want to limit the connection to a specific drive, we enter the ID of the drive you want to connect to.Without Drive Id I am able to access the root folders and their content but I want to target a specific child folder.We tried the actual drive ID, folder name, web URL for that particular folder but faced below mentioned errorError - com.ataccama.extension.onedrive.connector.api.OneDriveConnectorException: Unable to connect to OneDrive  This is the error message I get if we provide Drive Id 

Hi everyone,I’m working on an MDM project where I need to configure reference data in such a way that it updates dynamically based on another attribute’s value.For example: I have an attribute Country and another attribute City.When a specific Country is selected, the city dropdown should automatically display only the cities associated with that country.Is there a way to achieve this kind of dependent reference data setup in Ataccama MDM?If yes, could someone guide me on how to configure it?Thanks in advance!For reference: