Data Quality & Catalog ⚙️

Hi all, Some time ago I posted a question ('Published by' details via GraphQL) about how to make visisble who published for instance a glossary term. I noticed that like this you can't show who may have deleted the asset. Does anyone have a clue how to retrieve this details via graphQL (or in a different manner)? Kind regards, Albert

Can we fetch Rule and Catalog item metadata from a monitoring project using Graphql API ? If yes, can you share the Graphql query ? I could not find it on ONE API Documentation

Can we get the metadata of one rule instance. I have been using below query. It is giving all the dq checks. I want to pass only one DQ check ID and get the results. query{ ruleInstances(versionSelector: {draftVersion: true}){ edges { node { gid draftVersion { name displayName, target { gid } } } } } } Can anyone help me on this?

After testing manually created asset type/properties/relation in DEV environment, how to promote these change to high environment?

Hello!Does anyone have experience using the Iterate tool within the Ataccama Desktop, when creating a workflow? I’ve found a couple of old community posts referring to it, along with the files they’ve used, but I can’t get it to work in my environment. see the following: Iterating rows of a table (Record-by-record - SQL Iterator) in a workflow Based on that post and my testing, it seems like the Iterate tool needs to call another workflow, so I’m calling another .ewf file that just has the Run DQC tool, which runs the .plan file. I’m able to succeed in running the .plan file from the Run DQC .ewf, however i can’t seem to get the Iterate tool to run, without getting Configuration errors, like the following: 12.03.2025 15:30:51 [INFO] Task 'Iterate' : failed with exception: com.ataccama.adt.internal.core.runtime.EwfConfigException: Configuration contains errors, exitingjava.lang.RuntimeException: com.ataccama.adt.internal.core.runtime.EwfConfigException: Configuration contains errors, ex

Ataccama One Web: How to handle large dataset with 1 B rows in the data set while working on data profiling & Data quality evaluation? (Best Practices) What is expected Infrastructure configuration required with respect to infrastructure in case such huge datasets?

Hello , please advise on the steps required to perform a bulk upload of business or report terms to the Business Glossary page? Additionally, is it possible to deploy the glossary content to a higher environment (e.g., from Dev to QA or Prod), or do we need to manually replicate the same steps in each environment

in One Desktop we will get the summary of DQ checks like if the column is empty or if the column (salary) is having greater than defined. For each and every record it will show the record which got failed in the output of Data Quality indicator . My question here is How to achieve Primary key violated here ? i will show with an example.

Hello community, I’m creating a Power BI source on Ataccama One and have a few queries: Is the built-in Power BI connection allow One to retrieve a Power BI datasets? Or this is strictly for only bringing the Power BI reports to One? The imported catalog items from this connection shows “0” number of attributes and “-” number of records (screenshots below). This is also presents in the the screenshot from the Ataccama support page (link). Is this behave as intended or am I missing anything here? Thank you in advance. Ben

Hello! I am trying to think of a way through building a single post processing plan and or component that is able to be applied to every monitoring project in my ecosystem. It is a very simple plan, I will just have a filter for when invalid_rules_explanation is not null, and export to a default CSV location. The issue I am running into is that in all documentation, it is project / catalog specific when setting up a post processing plan. For a company with numerous projects and catalogs (around 500 unique configurations and more coming), I do not want to manually have to create the same post processing plan for every project and catalog. Is there a way to automate this, or have something within the UI of the web version that would allow me to do this more seamlessly?

I am performing deduplication for which am using matching step. I have configured it using name attribute to find duplicate with jarowrinkler() but getting a runtime error. Here is the configuration details - Here the error message - Not getting any error warnings on any step, configure window within my plan file. I appreciate any assistance you can provide. Thanks for taking the time to look into this. Your help is greatly appreciated.

Is there any way to give some logical name to the catalog item which is added in Monitoring Project. Actual catalog name and the catalog instance name present in MP should be different. Is that possible?

Is anyone able to provide guidance on how to make the businessDefintion a required field when creating new terms?

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

Hi! I am profiling tables and am looking at the profiles. I noticed that for date and datetime the profile does not show the MIN or MAX values. That is something I had expected though. Working on the data quality of this data, I really would like to know the MIN and MAX values for these attributes. Is there a way to change the configuration and include these profile statistics for these datatypes? kind regards, Jur Dördregter

I'm facing an issue with selecting schemas to observe for schema change detection in Observability for one of our sources(Sybase). Context: In our SQL database source setup, we have a single connection that includes multiple schemas, and Observability allows us to select multiple schemas without issue, as shown below. However, for the Sybase source, we're unable to select multiple schemas under a single connection. I only get the option to choose one connection and one schema from the dropdown. (See screenshot below.) Ideally, I’d like to select all dbo across all connections to monitor for structural changes. Question: Has anyone experienced a similar limitation?Is there a recommended approach for configuring Observability for schema checks on sources that have multiple connections and schemas under a single source — especially in cases like a Sybase database, where multiple connections are used? Any guidance or best practices would be greatly appreciated.

Hello!Wondering if anyone has experience with creating data quality rules for values in joined tables. For example, we have 2 tables (Table A and B), related to each other through a shared attribute. I want a data quality rule where the value of a column in table A must be lower than the value of a column in Table B. My only idea for this is to create a SQL catalog item joining the two tables, and creating a dq rule on the SQL catalog item. This works, but has flaws, I can’t have this data quality rule contribute to the overall data quality of Table A, nor will users who find this table in the catalog know of all the identified data quality issues. Does anyone have a better way of doing this, or is there a built-in tool I’m not familiar with that anyone has used?Thanks!

I want to find out missing values in the columns. Use case, column called colors which has values as [‘ORANGE’,’BLACK’,’BLUE’] and rule is if RED is not part of column values, then Rule should fail and alert that RED color is missing in table.

Hi, In ONE Web Monitoring Project there's an export tab with an export funcationality build within ONE Desktop. In ONE Desktop there's an output location. Might be an easy question, but how can I select an output location for the invalid records in this case to be send to a location inside my file directory? So basically what I want is the .csv/.xlsx file that come from invalidRecords to be sent automatically to a file directory folder I created. I understand the file can be downloaded from the Ataccama ONE Web export tab, but our customers have no use for this as the downloaded file will be downloaded in a file directory outside their working environment. Automatically moving the export invalid records to a file directory which they can access is a better solution in this case.

Hi, we are making use of reconciliation projects to compare two different dataset with eachother. Most of the data needs to be compared, but some fields we want to skip in the comparison. is it possible to skipp certain attributes in the comparison (we got some mutation date fields that show differences, but are no importance) is it possible to distinguish in notification between some attributes missing and data showing differences (Dataset A has a few extra attributes then Dataset B, but all other data should be exactly the same). I don't want daily notifications that I am missing these attributes, but I do want a notification when the data is showing differences. kind regards, Jur Dördregter

Is there any global setting at Monitoring Project level to get DQ issue detected warning if DQ percentage is less than 95%.? 14.5.3 version, warning seems to be given after below 60%. It means that if for catalog item in Monitoring project shows overall data quality less than 95%, it should be shown amber warning. instead of green ok.

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?

Hi, This file is comma separated with header and “ text qualifiers and keeps failing as below with a long line error. The data is from an MSAccess table with specific column widths not the default 255 in length. I have tried a number of times to no avail. Any assistance would be most welcome. 2025-04-10 16:27:04 [INFO] com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvider reason=the 'properties.encryption.keystore' property not specified2025-04-10 16:27:04 [INFO] com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvider reason=the 'internal.encryption.keystore' property not specified10.04.2025 16:27:04 [INFO] Using following licenses:10.04.2025 16:27:04 [INFO] /data/ataccama/one/dpe/license_axaUK_PROD-dpe-bde_v14_subscription_updated.plf10.04.2025 16:27:05 [INFO] running job 2f1568e2-0000-7000-0000-00000026b0c8 (14-CRESTDSS POLICY AND POPULATION.txt)10.04.2025 16:27:05 [DEBUG] metrics will b