Skip to main content

Learn & Share

Discuss data, share best practices, learn, and grow with Ataccama's Community.

1077 Topics
J
Data Enthusiast
JohnYData Enthusiast
asked in Data Quality & Catalog ⚙️
Where are lookup tables stored?

In Ataccama One web we can download Canada.lkp but on Ataccama Desktop we could not find this file (searched on drive C: as well).Where are these lookup tables stored?How to get a complete list of all of them?Thanks!

325
BrianF
Ataccamer
A
Ataccama Community AdminIntergalactic Expert
published in Data Quality & Catalog ⚙️
How to get started: Snowflake x Ataccama ❄️⚙️
How to get started: Snowflake x Ataccama ❄️⚙️

Heard about Ataccama x Snowflake pushdown and wondering how to leverage it?You’re in the right place. In this guide, we’ll walk through what Snowflake pushdown is, why it matters, and how to get started with it using Ataccama.What is Snowflake pushdown?Run processing directly in Snowflake by enabling pushdown. Pushdown allows Ataccama to offload data processing tasks directly to Snowflake—right where your data lives. That means faster performance, better security, and less infrastructure overhead.Why use pushdown processing?Enabling pushdown unlocks multiple benefits:🚀 Performance: Evaluate millions of records in seconds. No need to pull large datasets into external servers for processing. 🔐 Security: Processing is executed inside Snowflake. Results (and invalid samples, if configured) are returned—no external data transfers required, all processes run on secured and governed Snowflake warehouses. 🖥️ Infrastructure: Leverage your existing Snowflake environment—no need to set up or m

750
A
JTH
Data Pioneer
JTHData Pioneer
asked in Data Quality & Catalog ⚙️
Delete dataset from report (Monitoring Project)

Hi,ONE Web > Monitoring ProjectI have a MP A which contains 7 CIs, I want to copy this MP to create MP B. For MP B I only want to use 6 out of the 7 CIs as the last CI is unnecessary. I use the import configuration (great qol btw) and for the 7th CI I use same CI.After the import configuration has been completed I delete the 7th CI from the MP. Inside the Report tab I still see that same CI appear which is not ideal. You'd think clicking the three dots besides it lets me Delete it from the page, but to my surprise that option is greyed out. How do I get rid of this CI from the Report page?​​​

556
ivan.kozlov
Ataccamer
OGordon100
Ataccamer
OGordon100Ataccamer
published in Data Quality & Catalog ⚙️
🔐 Logging into Keycloak via SSO: Best practices for admins
🔐 Logging into Keycloak via SSO: Best practices for admins

Hi everyone 👋By default, Keycloak admin access is limited to a single account with fixed credentials provided by Ataccama. But just as we recommend using SSO for logging into the Ataccama platform, it’s also best practice for Keycloak administrators to log in the same way—for better security, auditability, and ease of access. Here’s a quick guide to help you set up and enable SSO login for Keycloak admins 👇 1️⃣ Set up admin access in KeycloakFirst, log in to your Keycloak instance using the default admin credentials at:<your_env>/authOnce logged in:Switch to the ataccamaone realm Go to the Realm Roles tab Decide whether to use an existing role (e.g., admin) or create a new one (e.g., Keycloak_Admin) based on your security requirements2️⃣ Assign the right permissionsOpen the role you've selected or created:Navigate to the Associated Roles tab and click Assign Role Under Filter by, select ClientsNow assign the appropriate permissions. At a minimum, these should include:manage-acc

820
OGordon100
Ataccamer
A
Data Voyager
Apurva KapoorData Voyager
asked in Data Quality & Catalog ⚙️
How to fetch Rule and Catalog item metadata from a monitoring project using Graphql API ?

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

602
Lisa Kovalskaia
Ataccamer
S
Data Voyager
sjettawiData Voyager
asked in Data Quality & Catalog ⚙️
Defintion/Decription Field for Business Terms

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

353
A
JTH
Data Pioneer
JTHData Pioneer
asked in Data Quality & Catalog ⚙️
Export output location (Monitoring Project)

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.

424
A
S
Data Pioneer
sumishaData Pioneer
asked in Data Quality & Catalog ⚙️
Can we use reference data in case statement in Computed content?

Can we add reference data in case statement in Computed content?

327
A
V
Data Voyager
Vaishali
asked in Data Quality & Catalog ⚙️
Create DQ rule to validate data in same column

Hi,I want to create DQ rule to check data within same column. For example, from below table, I want to check if Value of Category B is >= Value of Category D.How can I do this in the Ataccama One UI? ThanksCategory Value A 5 B 2 C 6 D 4

925
A
A
Ataccama Community AdminIntergalactic Expert
published in Data Quality & Catalog ⚙️
🔦 Community Spotlight Highlights: Glossary Customization in Ataccama ONE with Stater
🔦 Community Spotlight Highlights: Glossary Customization in Ataccama ONE with Stater

Hi everyone,  We're excited to share highlights from our very first Community Spotlight event, where we heard directly from ​@Albert de Ruiter, Lead Data Management at Stater, the largest mortgage service provider in the Netherlands.Albert took us on a deep dive into how his team tackled glossary customization in Ataccama ONE to better reflect their business logic and metadata needs. With over 25 years of experience in data, Albert brought both expertise and practical insights to the session. 💡 Here are some key takeaways: Why customize the glossary? Stater needed different metadata for catalog items and their attributes—customizing allowed them to reflect these distinctions clearly. Custom term types: They introduced entity terms, attribute terms, and business terms to better align with their logical data model. Reusability with relationships: Using relationship types ("roles"), they elegantly modeled attributes that appear in multiple entities—like keys, foreign keys, and descri

970
A
A
Data Voyager
Apurva KapoorData Voyager
asked in Data Quality & Catalog ⚙️
Extracting Rules and other Metadata Information from a Monitoring Project ?

We need to extract the Rule and other Metadata from Monitoring project. Below is the set of Metadata Information that is requiredDQ 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

934
Lisa Kovalskaia
Ataccamer
H
Universe Traveller
Hanish NUniverse Traveller
asked in Data Quality & Catalog ⚙️
Rule instance details via API

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?

513
Albert de Ruiter
Rocket Pioneer L1
N
Data Enthusiast
NormanThink
asked in Data Quality & Catalog ⚙️
How to promote customized asset type/properties/relationship/valuelist to higher environment?

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

261
Albert de Ruiter
Rocket Pioneer L1
B
Data Voyager
bobparryData Voyager
asked in Data Quality & Catalog ⚙️
Ataccama Desktop Iterate Tool Erros

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 workflowBased 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, e

628
B
Data Voyager
S
Universe Traveller
Susan24usUniverse Traveller
asked in Data Quality & Catalog ⚙️
Business and Report Terms Bulk Uplaod

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

371
I
Ataccamer
L
Data Voyager
lokeshpottiData Voyager
asked in Data Quality & Catalog ⚙️
How to get PK viloation identification in Data Quality indicator in One Desktop ?

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.   

102
L
Data Voyager
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Data Quality & Catalog ⚙️
Questions for Ataccama One Power BI connector

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

2768
M
Data Enthusiast
A
Ataccama Community AdminIntergalactic Expert
published in Data Quality & Catalog ⚙️
How to import terms from ONE Desktop 🟣🔎
How to import terms from ONE Desktop 🟣🔎

Hi everyone,  This week’s last best practice is on how to import terms from ONE Desktop 🖥️ In data governance, importing terms is a crucial step. Using ONE Desktop, you can streamline this process by batch-importing terms into your ONE Web Application instance. This guide walks you through the process of importing terms from a CSV file into your ONE instance using the Text File Reader and ONE Metadata Writer steps. Please note that while we use the Text File Reader in this example, you can choose alternative input steps like JDBC Reader or ONE Metadata Reader.Step 1: Prepare Your Term FileBegin by preparing your term file. In this example, we have a CSV file called party.csv, which contains several terms: Step 2: Create a New PlanCreate a new plan in ONE Desktop. Simply drag and drop your term file into the plan. This action will automatically generate a new Text File Reader step. Step 3: Edit Text File Reader PropertiesEdit the properties of the Text File Reader step:In the Columns s

3302
A
T
Data Pioneer L2
ThomasProData Pioneer L2
asked in Data Quality & Catalog ⚙️
Single Post Processing Plan that is able to be used for all monitoring projects

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?

231
anna.spakova
Ataccamer
R
Data Enthusiast
Raj KData Enthusiast
asked in Data Quality & Catalog ⚙️
Matching runtime error raised.[STEP Matching 2[Md Unify]]

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.

182
A
H
Universe Traveller
Hanish NUniverse Traveller
asked in Data Quality & Catalog ⚙️
Can we change the catalog name in MP?

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?

201
anna.spakova
Ataccamer
S
Ataccamer
srija piratlaAtaccamer
published in Data Quality & Catalog ⚙️
How to use Dynamic Expression Assigner?
How to use Dynamic Expression Assigner?

Hi I'm Srija, Solutions Consultant here at Ataccama.In this post, I’ll walk you through how to use a dynamic expression assigner. What is a dynamic expression assigner?The Dynamic Expression Assigner in Ataccama allows you to define dynamic expressions or rules to determine how values are extracted or assigned to specific attributes based on conditions present in your data. Use Case:The Monitoring project results will give the attributes , Invalid DQ rules and Invalid DQ Attributes for the failed rows. If we need to extract the DQ Error Attribute Value based on the Invalid DQ Attribute then Dynamic Expression Assigner can be used in the post processing plan.In the below example, I have a DQ_Error_Attribute which is causing the issue for that record. If I need to extract the respective value of the DQ_Error_Attribute then, I can use the Dynamic Expression Assigner. We can achieve this using a column assigner, but we must hardcode the attributes to extract the value. If any new attribute

1494
A
A
Data Pioneer
akshayl09Data Pioneer
asked in Data Quality & Catalog ⚙️
DQ Rule for missing values

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. 

172
A
Data Pioneer
jdordregter
Data Voyager
jdordregterData Voyager
asked in Data Quality & Catalog ⚙️
Exclude attributes from Reconciliaton Project

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

303
E
Ataccamer
A
Data Pioneer
akshayl09Data Pioneer
asked in Data Quality & Catalog ⚙️
Identifying data quality issue in monitoring project: DQ Issues Detected

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. 

537
E
Ataccamer

Badge winners

Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, and have an opportunity to shape the future of new products.

Read more
Community Terms of Use & ConditionsCookie settings