Skip to main content

Recently active topics

50 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!

205
BrianF
Ataccamer
N
Data Voyager
NormanThink
asked in Data Quality & Catalog ⚙️
is catalog item overview page customizable?

on v15.4, can we customize the snowflake table overview page after cataloging, to show or hide certain properties? I don’t see edit page option in top right 3 dot.  I do see the “edit page template” option for MDM data, but not for snowflake tables.  is this intended product feature? Thanks. 

70
N
Data Voyager
A
Data Pioneer
akshayl09Data Pioneer
asked in Data Quality & Catalog ⚙️
Handling Large Dataset while data profiling & Data Quality

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?

111
E
Ataccamer
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
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

50
Cansu
Community Manager
M
Data Voyager
manidharData Voyager
asked in Data Quality & Catalog ⚙️
data freshness support for databricks

Hi Ataccama Community, Is the data freshness feature is supported for data bricks database now? In the documentation it says Snowflake, PostgreSQL, BiqQuery, and Oracle are supported. I am using Ataccama version 15.4 

30
M
Data Voyager
Cansu
Community Manager
CansuCommunity Manager
Ataccama ONE v16.1 is here with updates to Data Stories, MDM, Lineage, and more 👀

Hi everyone 👋We’re excited to announce the release of Ataccama ONE v16.1! 🎉This version brings new integrations, smarter lineage capabilities, enhanced search functionality, and more powerful tools to help you scale your data quality and catalog efforts. Let’s take a look at what’s new 👇 🟣 ONE Platform UpdatesAzure Synapse Pushdown ProcessingYou can now run profiling and DQ evaluation directly in Azure Synapse via SQL pushdown! This means improved performance, scalability, and security—especially useful for working with large datasets.Pushdown can be enabled globally per connection, with flexible controls to exclude specific catalog items or projects if needed.Support for Apache AvroONE now supports importing and processing Avro files and tables. When importing, attributes are automatically generated from the asset—making it easier to work with Avro data formats.Lineage Enhancements Self-Managed Scanner Support – Install built-in lineage scanners in on-premise deployments, not just

631
A
Data Voyager
Cansu
Community Manager
CansuCommunity Manager
published in News & Announcements 📣
Exciting News: Ataccama Academy is now 100% free for customers 🎉

Hi everyone 👋We’re making learning Ataccama even more accessible! Starting today, all our on-demand training in Ataccama Academy is completely free for our customers. But that’s not all—certification is now available and free too! 🎉This means you can:✅ Access all on-demand training materials anytime, at no cost✅ Get officially certified without any fees✅ Upskill and master Ataccama ONE with easeWe’re committed to empowering you with the best learning experience possible and this wouldn’t be possible without your continuous feedback. Thanks to your input in our 2024 Community Survey which heavily influenced the team to take this decision ⚡️ Now, ready to level up?Join the Academy today and access all on demand trainings for free 👈 Start by signing-in or filling the form to create a new account on the Academy and confirm your registration from the email you receive from us. From then on, you will be able to access on demand trainings catalog and start learning. Please note that issuin

43627
DannyRyan
Ataccamer
O
Star Blazer L1
OjaswiniStar Blazer L1
asked in Data Quality & Catalog ⚙️
DQ Monitoring project UAT/Test deployment

Hello,I am new to DQ and Ataccama. Our code is in development environment and soon to be deployed in Test/UAT for UAT testing and later to Prod once we get UAT signoff.My question is what is the way to export DQ monitoring project and its related components (like rules, etc) from Dev environment to UAT/Test environment? Is there any export capability? I have also heard that we may need to recreate it again in UAT environment. Really appreciate any direction in this.Thanks in advance.

903
S
Data Voyager
Cansu
Community Manager
CansuCommunity Manager
14.5 Updates: ONE 🟣

Hi everyone!This week, we’ll continue covering the latest features and updates in 14.5 ⚡Today on the menu we have ONE updates and features in 14.5. Let’s dive in 🤿DQ Firewalls 🧯DQ Firewalls allow you to apply data quality rules to your data using API calls, specifically, the evaluation APIs provided by the new DQF Service. Both GraphQL and REST options are available.This allows you to be able to maintain one central rule library and use Ataccama data quality evaluation rules on your data in real-time in the data stream. For example, you have an ETL pipeline in Python that processes data, and you want to make sure that it filters out invalid records. After defining the DQ rule in ONE, the pipeline for each record (or batch of records) can call the DQF endpoint, and records will be split up by their validity.DQF ServiceWith 14.5 we have a new DQF service that handles rule debug in rules and in monitoring projects, as well as allows live data quality validation in ONE Data and the new D

3082
M
Data Voyager
B
Data Voyager
bobparryData Voyager
asked in Data Quality & Catalog ⚙️
Best Practices for Data Quality Rules based on joins

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! 

263
B
Data Voyager
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?​​​

496
ivan.kozlov
Ataccamer
OGordon100
Ataccamer
OGordon100Ataccamer
published in Data Quality & Catalog ⚙️
🔐 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

120
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

202
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? 

273
Cansu
Community Manager
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.

204
Cansu
Community Manager
jdordregter
Data Voyager
jdordregterData Voyager
asked in Data Quality & Catalog ⚙️
Profiling Date or Datetime

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

154
Cansu
Community Manager
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?

287
Cansu
Community Manager
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

835
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
🔦 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

380
Cansu
Community Manager
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

534
Lisa Kovalskaia
Ataccamer
Albert de Ruiter
Star Blazer L3
Albert de RuiterStar Blazer L3
asked in Data Quality & Catalog ⚙️
'Deleted by' details via GraphQL

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

130
Albert de Ruiter
Star Blazer L3
S
Universe Traveller
sriniUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
read MDM workflow status using API in v15.4

How can we retrieve or read the workflow status (running, success, or failed. Etc) using a GET API after triggering the workflow via an Http service?

120
S
Universe Traveller
H
Data Voyager
Hanish NData Voyager
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?

333
Albert de Ruiter
Star Blazer L3
N
Data Voyager
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?

231
Albert de Ruiter
Star Blazer L3
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

548
B
Data Voyager

Badge winners

  • First idea 💡
    Mkuruphas earned the badge First idea 💡
  • First idea 💡
    AdamShas earned the badge First idea 💡
  • First idea 💡
    NaveenKumarhas earned the badge First idea 💡
  • First idea 💡
    Monicazimhas earned the badge First idea 💡
  • First idea 💡
    Hanish Nhas earned the badge First idea 💡
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