Skip to main content

Recently active topics

55 Topics
A
Data Voyager
A_NData Voyager
asked in Master Data Management & Reference Data Management 🛰️
How to delete the classification types from the tables and attributes level through One Desktop Plan?

Hello all,I’m using the Ataccama v14.5 there we have created the custom entity for classifications and created the classification types (Internal, Public etc) and added them with tables and attributes through the One Desktop plan. But when i am using the same plan to delete it from table or attributes just by changing the One Metadata Writer property in General tab “workflow state as deleted” and in the Columns tab providing the “Id Column Name as table_id” then it is not deleting anything. Any guidance or suggestions is really helpful. Thanks.General tab Screenshot:Columns tab screenshot: 

192
Cansu
Community Manager
S
Data Voyager
Susan24usData Voyager
asked in Data Quality & Catalog ⚙️
Semi Structured Data

Hello, i have a report that we usually saved to hard drive that i would like to bring into Ataccama, the report is in semi structured format . does ataccama accept or work with semi structure data ?or do i need to convert the report first before connecting to source ?

283
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Improving Data Quality: Turning insights into action

We are half-way into the end-to-end DQ guide! Just jumping on here? Read the first post of the series 👇Identifying data issues is just the beginning—what really matters is fixing them 🛠️Data quality improvement involves standardizing formats, removing duplicates, and setting up automated remediation workflows​. Whether it’s fixing customer records, cleansing addresses, or resolving inconsistencies, clean data means more reliable insights.Data transformation tools play a crucial role in making data fit for purpose, while matching and merging ensure that duplicate records don’t pollute your systems. Additionally, data remediation workflows enable businesses to track and resolve data quality issues efficiently​.Ultimately, improving data quality isn’t just about technology—it’s about creating a culture where teams take ownership of data health. Organizations that prioritize continuous data improvement see better business outcomes and reduced operational risks.How did you manage to build

70
Cansu
Community Manager
N
Space Explorer
NataliiaSpace Explorer
asked in Data Quality & Catalog ⚙️
Primary key/nullable/column size field disappears after refreshing catalog item

Hello, does anyone faced with issue when primary key/ nullable/ column size fields are gone after refreshing catalog item and rerun data select?I use ONE Web app v14, after setting attribute as primary key, nullable or defining column size then it disappears after  rerunning query.How did you solve this issue? 

132
N
Space Explorer
N
Space Explorer
NataliiaSpace Explorer
asked in Data Quality & Catalog ⚙️
List of functions for advanced builder DQ rules

Hello guys, does someone know where I can find the information about all functions list that are available from Advanced builder while creating DQ rules? Will appreciate any help or advice, thanks.

151
A
Ataccamer
B
Universe Traveller
Bhuvaneshwari BalasubramaniamUniverse Traveller
asked in Data Quality & Catalog ⚙️
DQ - Monitoring project "Export"

Hi ,Kindly share your inputs on below scenario.I am trying to place the “Monitoring Projects” export  “.csv” file in a shared path/folder with in the organization. Purpose of this “Report need to accessed by different set of stakeholders who do not have Ataccama access” Is there a way to access this export file by any API calls or we can directly configure the shared folder path for example “S:/SharedPath/Ataccama/Exports” in output location field ?  Note : This is on Ataccama ONE 14.4 version. Any input is appreciated. Thanks,Bhuvi

151
anna.spakova
Ataccamer
B
Universe Traveller
Bhuvaneshwari BalasubramaniamUniverse Traveller
asked in Data Quality & Catalog ⚙️
Apply rules only to newly created records through any filter

Hi,Could anyone help me on below scenario. I am using Ataccama ONE web 14.4. Millions of records are populated in testing environment from Production real time data. However , for testing purpose manipulated few 1K records. Is there any way in Ataccama where we can apply rules and perform “Monitoring Projects” only to the new records 1K created by giving any date created filter? Regards,Bhuvi

282
B
Universe Traveller
A
Data Voyager
Anurag choubeData Voyager
asked in Data Quality & Catalog ⚙️
Clearing all special characters expect defined special characters

In the above image I want to clear all special characters expect .(dot) As their can be any thing in place of  ! number may have *, &, %, $, etc. I tried it using trashnondigit() function but it will remove all the characters from the number, Is their a way to do it?

272
A
Data Voyager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Monitoring Data Quality – The key to trustworthy data

Hi everyone,  Ready for the second part of our end-to-end DQ guide? Monitoring DQ is essential for building trust in your data assets.This post explores how data profiling, observability, and automated monitoring help organizations detect and address data quality issues in real-time, ensuring data remains accurate, complete, and reliable. Before starting, missed the first post? Check it out here 👇 Once your data is documented, the next step is understanding its quality. Without proper monitoring, data issues can go unnoticed, leading to poor decision-making. Data profiling helps by analyzing patterns, completeness, and accuracy, while data observability provides real-time monitoring to detect anomalies before they cause harm​. A data quality monitoring system tracks key dimensions such as validity, completeness, and consistency, helping organizations demonstrate progress and ROI. Automate this process, detecting unexpected changes and flagging them for review​. By continuously assessi

110
Cansu
Community Manager
N
Data Voyager
NBalaguraData Voyager
asked in Data Quality & Catalog ⚙️
Configure the MMM Module for generating links in emails

Hi everyoneCould you please advice if there is any instruction how smpt server can be configured for e-mail notifications?Where we can perform this configuration? Is there any option in Ataccama ONE web? I have checked this part of documentation MMM Configuration :: Ataccama ONE but it is still not clear where mmm configuration can be done

232
N
Data Voyager
may_kwok
Star Blazer L3
may_kwokStar Blazer L3
asked in Data Quality & Catalog ⚙️
v15 Data slices - multiple slices in the same catalog item in the same project?

Hello all,I am on v14.5.3, so I haven’t seen the Data Slice feature hands on yet. Been reading the documentation on the Data Slice and its use in the monitoring project. Say for example, I have a table of transactions, and I have some statuses:Pending Active Inactive Cancelled  Let’s say I have the following rules and the respective slices they need to be applied on:Rule 1 Status = ‘Active’ Rule 2 Status in (‘Active’, ‘Pending’) Rule 3 Status = ‘Pending’  Is it then possible to create an ‘Active’ slice, and a ‘Pending’ slice?And then in my monitoring project, I add my catalog item, then I apply my Rule 1 to the Active slice, Rule 3 to the Pending slice, and Rule 2 to both the Active and Pending slices? Or something like that? Trying to gauge how we can use it, how much maintenance overhead there will be and the effort to try and start using this feature. Any insights from people who’s already using v15 much appreciated!

402
may_kwok
Star Blazer L3
Cansu
Community Manager
CansuCommunity Manager
Version 16 is here! Updates to ONE AI, Data Observability, MDM, and more 👀

Hi everyone! For our latest release we have a long list of updates for you! So let’s get into what’s new in v16 👇Data Quality & Catalog 1️⃣ Profiling and DQ pushdown on Google BigQueryYou can now run data quality checks on Google BigQuery by enabling pushdown execution for a variety of DQ rules, which includes all rules created via Condition Builder, as well as certain rules written in Ataccama Expression Language. This means you can now perform DQ checks efficiently, optimizing performance especially for large datasets.New implementation will provide users with flexibility, when choosing which CIs should be evaluated in Pushdown. This is especially handy when using more complex, unsupported rules on certain CIs.Domain Detection and Term suggestion will be now executed alongside existing Pushdown Profiling, ensuring a comprehensive and efficient data assessment to bring faster, more scalable data quality processing for BigQuery users!  2️⃣ AI identification of similar rulesWith v1

600
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Data Reconciliation Best Practices 👾Best Practice

Hi Community! In the last few months the focus of our articles was majorly on features of ONE Web platform, from the basics to more complicated practices and now it’s time to move on to the next step. From next week we are moving on to ONE Desktop🖥️ Today we will focus on Data Reconciliation, and cover how you can utilize this feature effectively for seamless data consistency across multiple sources. Let’s get to it! In a nutshell, the Data Reconciliation feature confirms that your migrated data from one database to another is intact and accurate, without any data leaks or glitches. It conducts high-level checks on data consistency by comparing attribute profile statistics and even attributes fingerprints (except for Snowflake data). Step-by-Step Guide to Data Reconciliation 1. Create a Reconciliation Project in Data Quality:To kick off your data reconciliation journey, navigate to Data Quality and then select Reconciliation Projects. Here, you can either create a new project or edit

5057
anna.spakova
Ataccamer
Cansu
Community Manager
CansuCommunity Manager
Introducing Ataccama ONE v16: Ataccama Lineage is here! 🪢

Hi everyone! As part of our latest release, we’re thrilled to introduce Ataccama Lineage 🎉 —our native data lineage solution that lets you explore every step of your data’s journey, from creation to consumption, ensuring transparency, trust, and compliance.  Why is it important?Ataccama Lineage brings integrated and automated lineage scanners to your Ataccama ONE.It helps you scan metadata across data sources, ETL jobs, and data destinations to visualize the entire data pipeline, including all dependencies and transformations without the need to do manual investigations of table dependencies, data issues and lineage tracking.Our advanced AI capabilities enable automated anomaly detection, data classification, and data quality assessment, helping you to track data quality scores, monitor key business terms and identify data issues like unexpected values, missing records, or duplicates caused by transformation errors or process failures.With Ataccama Lineage, you can now:Troubleshoot &a

1080
Cansu
Community Manager
Arno
Universe Traveller
ArnoUniverse Traveller
asked in Data Quality & Catalog ⚙️
Selecting multiple checkboxes

Hi everyone,Sometimes I'd like to select a large number of checkboxes in Ataccama, for example to profile a large number of Catalog items. Of course creating a plan is also an option, but not always the least time consuming.How do you do this with many checkboxes involved? There are browser extensions available for many browers, but not sure if those are secure enough. Any recommendations or tips?

312
Arno
Universe Traveller
Catherine
Data Pioneer
CatherineData Pioneer
asked in Data Quality & Catalog ⚙️
Data Source - BOX.COM Connectivity

Please advise if “BOX.COM” is a data source that is supported out of the box, being that ONE can integrate with “BOX.COM” using an existing JDBC or API connector. 

151
R
Ataccamer
Catherine
Data Pioneer
CatherineData Pioneer
asked in Data Quality & Catalog ⚙️
Atacama "Security Terms" written to

Use Case:  For our Data Lose Protection initiative, we are profiling and classify OneDrive, SharePoint, etc and we have a requirement to write the “security term (data classification - restricted, confidential, etc)” to the asset sensitivity labels (metadata) 

201
R
Ataccamer
R
Universe Traveller
RAZORXUniverse Traveller
asked in Data Quality & Catalog ⚙️
Notification on Policy Update or Creation

Hi Community,Is it possible to have a email notification to a group of people in case of an update in the existing policies in One Web?

223
A
Ataccamer
K
Data Pioneer
KarthikeyanData Pioneer
asked in Data Quality & Catalog ⚙️
Reading array of response using Json call

Hi Team, I am trying to json call to read the response of api and process it for further results. This is my example response { "Data": [ { "Name": "Amount", "Id": "12345", "ValueListAttribute_5d": [ { "term": "Attribute", "term_Id": "67" } ], "StringAttribute_00": [ { "definition": "Dollar amount", "definition_id": "5" } ], "BooleanAttribute_18e": [ { "indicator": "true", "indicatorid": "6" } ], }, { "Name": "Amount", "Id": "12345", "ValueListAttribute_5d": [ { "term": "Attribute", "term_Id": "67" } ], "StringAttribute_00": [ {

1199
A
Ataccamer
T
Universe Traveller
TimBrown74Universe Traveller
asked in Data Quality & Catalog ⚙️
Validate a string in the format YYYYMMDD

How would I validate a string in the format YYYYMMDD is a valid date?  I assume the range of valid years is 1940 to 2050.

616
T
Universe Traveller
K
Data Enthusiast
kellymremzilybData Enthusiast
asked in Data Quality & Catalog ⚙️
SQL Catalog Item Creation Issue

I am trying to create a SQL catalog item to filter out the inactive records.  When I create the SQL catalog item I get the following error message:SQL compilation error: Object 'DEV_SOURCE.SAPMDG.VTLFA1' does not exist or not authorized.I can see the data tab for this table.  I can run profiling/DQ insights tab so I’m not sure what is happening.  I have created the query with the schema name and without the schema name. Shouldn’t the credentials be the same to create the SQL catalog item?

142
K
Data Enthusiast
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Introducing the end-to-end Data Quality Guide: Laying the foundation – understanding your data landscape

Can you truly trust your data? If you or your team hesitates before answering, you’re not alone. Many organizations struggle with understanding what data they have, where it resides, and whether it’s reliable. Without proper documentation, data quickly becomes fragmented, outdated, or even misleading, and potentially leading to missed opportunities and poor decision-making. And that’s why we’re introducing our End-to-End Data Quality Series! 🚀Data is one of the most valuable assets for any organization, but without a strong quality framework, it can quickly become unreliable and untrustworthy. In this four-part series, we’ll walk through the essential steps of achieving high-quality, trustworthy data—from documenting your data landscape to preventing issues before they arise. Each post will break down a key stage of the framework and providing actionable insights. Please do join in the discussion in the comments, let us know if you have followed any of these tips, or what helped you i

470
Cansu
Community Manager
A
Universe Traveller
Ajeesh_GUniverse Traveller
asked in Data Quality & Catalog ⚙️
Send files to sftp location

Hi, How can I send a file to SFTP folder using below task item? I am using Desktop version.Can someone help me how to get the required fields from the below screenshot? I have the location where I want to drop the file. 

351
Phil Holbrook
Ataccamer
B
Universe Traveller
Bhuvaneshwari BalasubramaniamUniverse Traveller
asked in Data Quality & Catalog ⚙️
Validating Date

Hi,I am trying to validate the date given between 100 years ago and 15 years ago are valid , everything else is invalid. I am able to achieve this validation in YEAR part. I am looking for validating complete date instead of only Year part.Below are few screenshots.  

352
B
Universe Traveller
R
Universe Traveller
RAZORXUniverse Traveller
asked in Data Quality & Catalog ⚙️
Policy Creation/Update Date

Hi Community,Is it possible to fetch the policy creation or last update date for Policies, in order to make a DQ rule around it in Ataccama One? My use case is to build a DQ rule which will notify the stakeholders based on a timeframe after which the policy has been created or last updated, but unfortunately i am not seeing any property to fetch the Created or Last Update date. 

262
R
Universe Traveller

Badge winners

  • First idea 💡
    BarbaraBhas earned the badge First idea 💡
  • First idea 💡
    jbinghas earned the badge First idea 💡
  • First idea 💡
    samsTmobilehas earned the badge First idea 💡
  • First idea 💡
    ViLashas earned the badge First idea 💡
  • First idea 💡
    ScottAndersonhas 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