Skip to main content

Product Updates
Events
Training Resources
Groups

Home
Search

Recently active topics

55 Topics

aish_TFStar Blazer L1

posted in Master Data Management & Reference Data Management 🛰️

Usage of Rematch and Reprocess jobs

I have been trying to explore the Reprocess and Rematch options in MDM.From this post I understand that Reprocess is used to reprocess the records. For example, lets say, after an initial load where the email values were not being modified in contact_clean.comp, we are now to determine which emails have the domain company-name.com and are now being updated to have domain companyname.com . So, I need to run the reprocess job.Rematch is to run the match step on top of the reprocess since the email values have been modified. What I do not understand is do I run a rematch job only if the email value participates in determining the master record or do I need to run it whenever the reprocess jobs is run irrespective of the changes that took place due to a reprocess?There is another question I have. When we run a load job, the change detection is done right. Does this change detection run on all the records or just the delta records. Post the change detection, matching and merging is run only

sumishaData Pioneer

asked in Data Quality & Catalog ⚙️

How to get terms tagged to attributes in Catalog in One desktop

How do I get Terms tagged to attributes to various catalog items in One Desktop?I need to get all catalog items which are tagged with a specific Glossary Term.

AbbyData Voyager

asked in Data Quality & Catalog ⚙️

Flow of columns after using group Aggregator

Hello All,I am using group aggregator in our plan but I am not sure how to make all the columns flow from input till the end/output through group aggregator.

Susan24usData Voyager

asked in Data Quality & Catalog ⚙️

Hello, i am using a free version of the Data Stories , I cant seems to find where to upload or import dataset as seen from the demo --- Data Stories Demo does this free version not support creating a story , Dashboard or visualization ? if its does, is there something i’m not doing right

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?Drop a comment below and raise your hand 🙋‍♀️🙋 if you want access now!

shikoh.zData Enthusiast

asked in Data Quality & Catalog ⚙️

Creating rule for productline

Hi,Could someone guide me on creating rules for the Productline field? I am following the lab exercise but am unable to find the option for selecting "is not from reference data."Any guidance would be appreciated.Thanks,Shikoh Zaidi

SoniyaNData Voyager

asked in Data Quality & Catalog ⚙️

Combining Excel file

I have 10 excel sheets, which need to be combined in one single excel sheet. can this be done in Ataccama?

daniel_bAtaccamer

published in Ataccama User Lab 🧪

Looking for your feedback: New navigation🧭

Hi community👋 I’m Dan from the UX team here at Ataccama.We are excited to share that my team and I have been working on improving our current information architecture and navigation for a while✨ We aim to bring you even better-organized navigation across the platform and enhance customization options for all users.As part of our work, we are looking for your feedback and inviting you to test our in-progress information architecture to ensure new enhancements and updates according to your needs.How?If you want to help shape our new navigation, join us for a testing session! It will be a 1:1 call which won't take more than 45 minutes ⏱️ The call will take place on a video conferencing platform of your choice. If you have any questions, feedback, or suggestions let us know in the comments 👇 p.s. Any beta is subject to change and doesn’t necessarily represent the final update.

LazovData Voyager

asked in Data Quality & Catalog ⚙️

Ranking numeric values in code query

Dear members,I am struggling with a step that rather reflects query/array logic than the logic of steps available in component editor.Task is to find the maximum from a range of values. I tried to retrieve it through a dynamic query written in a Representative Creator step, see details below:L1:= round((1-(levenshtein(W_CUA1,W_CUA1_MATCH)/(max(length(W_CUA1),length(W_CUA1_MATCH)))))*100,0);L2:= round((1-(levenshtein(W_CUA1,W_CUA2_MATCH)/(max(length(W_CUA1),length(W_CUA2_MATCH)))))*100,0);L3:= round((1-(levenshtein(W_CUA1,W_CUA3_MATCH)/(max(length(W_CUA1),length(W_CUA3_MATCH)))))*100,0);L4:= round((1-(levenshtein(W_CUA1,W_CUA4_MATCH)/(max(length(W_CUA1),length(W_CUA4_MATCH)))))*100,0);L5:= round((1-(levenshtein(W_CUA2,W_CUA1_MATCH)/(max(length(W_CUA2),length(W_CUA1_MATCH)))))*100,0);L6:= round((1-(levenshtein(W_CUA2,W_CUA2_MATCH)/(max(length(W_CUA2),length(W_CUA2_MATCH)))))*100,0);L7:= round((1-(levenshtein(W_CUA2,W_CUA3_MATCH)/(max(length(W_CUA2),length(W_CUA3_MATCH)))))*100,0);L8:= ro

sumishaData Pioneer

asked in Data Quality & Catalog ⚙️

Data Protection classification

I have a column in my catalog item which contains sensitive data. I have tagged this column with a Business Term. This business term is tagged as PII in Data Protection Classification section in Glossary terms. Is there a way to show at catalog item level that this table contains PII data?

TimBrown74Universe Traveller

asked in Data Quality & Catalog ⚙️

Confusing date data

The Business wants this date attribute validated. I don’t know why, it’s a key field and I assume managed by the DB. Nonetheless, I need to build a rule.But I think it’s strange that the Data Type is DATE while the date values are YYYY-MM-DD. I would expect to see DATE format data in the MM-DD-YYY HH:MM:SS AM format.I don’t know how to code it in the date functions since it doesn’t have the standard date format and it doesn’t work in any string functions.Any ideas?

NataliiaSpace Explorer

asked in Data Quality & Catalog ⚙️

SCD Type 2 using DQ rules

Hi everyone, Data Observability tab and AI functionality are not available. How can I check SCD Type 2 using DQ rules?Data Freshness. How can I check using DQ rules? Datetime datatype is for eff_strt_dttm, it’s one column where data is, but I don’t know how make: today() >>>as datetime minus 1 day

Data_VaultData Voyager

asked in Data Quality & Catalog ⚙️

Nested JSON with DAT file extension processing in Ataccama ONE

Hello,We recently started getting nested JSON event files with DAT file extension. We are getting an ‘Unknow Error’, when we try to import it.Can you help me in understanding, how nested JSON with .DAT extension can be processed in Ataccama.Thank you.

manidharData Voyager

asked in Data Quality & Catalog ⚙️

How to export a Summary of DQ Monitoring Project results?

Hello Ataccama Community,I am trying to export the summary statistics of the DQ monitoring project? I wanted to have a csv file with the columns like Date of the test results execution, Data_Catalog_Name, Attribute Name, DQ rule name, Data Source, DQ dimension, Total Number of Records, Number of records passed, and Number of records failed.To begin with I have tried using DQ monitoring projects step in One Desktop and the DQ Monitoring project is failing if I enable this post processing plan. Not sure why it was failing after enabling the below post processing plan. Any help is much appreciated. Thanks in Advance

NataliiaSpace Explorer

asked in Data Quality & Catalog ⚙️

ONE Web Redshift freshness possibility

Hi guys! Is there any opportunity to check data freshness in case we have Redshift connection?I see there is no such driver in freshness configuration drivers list - https://docs.ataccama.com/one/latest/data-observability/data-freshness-custom-configuration.html.

sumishaData Pioneer

asked in Data Quality & Catalog ⚙️

How do we filter the terms (AOL) by relationship type

Need support with AQL expression to filter terms based on a particular relationship type. Referring to Relations section under Glossary Terms.

Susan24usData Voyager

asked in Data Quality & Catalog ⚙️

Connections Update

We recently updated the Data Sources connection, and all Catalog items that were using the old connection are no longer working in the monitoring projects. When I expand the catalog items, an error message appears: "You are looking at a deleted item."However, if I create a new catalog item and add it as an attribute in the monitoring project, it works perfectly fine.My question is: How can I update the existing catalog items to use the new connection? Do I need to manually recreate all these catalog items with the new connection, or is there a way to automatically switch all catalog items from the deleted connection to the new one

Bhuvaneshwari BalasubramaniamUniverse Traveller

asked in Data Quality & Catalog ⚙️

How to access “Monitoring projects” through API calls

Hi ,I am trying to access “Monitoring projects” through API calls. For this purpose , I have created service account in KeyCloak with ‘default” and “DQIT_admin” IAM role access. Able to generate tokens with the service account. But unable to access “Monitoring projects” API , receiving 401 “Unauthorized” response.2 questions:How to check whether this service account is able to access the Ataccama application or not ? Any other or what level of access rights need to be provided to access API calls for a service account?Please note I am using Ataccama web application version 14.4.

CansuCommunity Manager

published in Getting Started with the Community 👋

Introduce Yourself & Meet the Community 👋

Welcome to the Data People Community 👋 We are very glad you’re here. This is a great space for you to introduce yourself to your fellow community members and offer up a fun fact (or three). Let me start!I’m Cansu, I’m a Community Manager at Ataccama. You’ll see me here a lot; managing the forums, chatting, and generally helping out. A little more about me: I’m based in the City of a Hundred Spires ️🗺️ I have two black cats named Goblin & Monkey🐈‍⬛ I am an amateur surfer ‍🏄‍♀️ Please don’t hesitate to share details about what you're looking to achieve with Ataccama, and what you hope to get from your experience in the Data People Community. See you in the forums 👀

CansuCommunity Manager

published in Data Quality & Catalog ⚙️

Collibra Integration in Ataccama ONE Desktop 🏹

Hi everyone, Today’s post is specifically on Collibra! So if you work with Collibra and are curious about how to integrate it with Ataccama ONE Desktop read on. This post will cover how you can harness the power of the Collibra Reader and Collibra Writer steps to effortlessly manage Data Quality (DQ) Rules. PrerequisitesBefore we dive in, ensure you have the following essentials:Ataccama ONE Desktop: Make sure it's installed on your machine with a valid license. Collibra: You need an active Collibra instance, complete with valid credentials for accessing and managing assets.Setting Up a Collibra Server ConnectionLet's establish a connection to Collibra from ONE Desktop:In ONE Desktop, right-click on Servers, and choose New > Server. Fill in the details: Implementation: Choose Generic. Name: Give your connection a meaningful name. URL: Provide the URL of your Collibra instance. Authentication: Select Basic. Username: Enter your Collibra username. Password: Input your Collibra

NataliiaSpace Explorer

asked in Data Quality & Catalog ⚙️

Hi guys, how did you check boolean date type in DQ rules? When I apply this rules it also make numbers, string, others value as correct.

RadziahData Voyager

asked in Data Quality & Catalog ⚙️

Fuzzy Checks with No Unique Identifier

HiI would like to ask whether we could do fuzzy check in Ataccama that involves two different datasets let’s say Set 1 and Set 2 from different data sources. Please note that both datasets have different number of columns but fuzzy checks involved only customer name and address. However, these datasets don’t have any unique identifier. Is it achievable in Ataccama and what would be the possible steps to achieve the results after the fuzzy checks? Thanks.

apejkoUniverse Traveller

asked in Data Quality & Catalog ⚙️

Assigning Data Usage Licensing Agreements (Policy) Through One Desktop

Hello everyone! I currently have a large group of catalog items that I am trying to assign a Data Usage Licensing Agreement too. I know that I can manually add these through Atacama online, however because of the large number I was wondering if it would be possible to create a plan to do this for me? I have all the catalogItem ids already compiled I simply do not know how to assign the policy.While I do see the option to write to policy, I cant seem to set the parent as a catalog item. Any help would be appreciated. Thank you!!!

Bhuvaneshwari BalasubramaniamUniverse Traveller

asked in Data Quality & Catalog ⚙️

Creating rules for Name field

Hi ,Could someone guide me on creating rules for Name field.Rule : Name should not have any special characters but can have numbers and spaces. Ex: Jhon Leo - ValidJho1 Leo - ValidJho( Leo* - Not Valid Regards,Bhuvi

jaygskData Voyager

asked in Data Quality & Catalog ⚙️

Creating Source in Ataccama One for Snowflake

I am creating new source connection from Ataccama ONE and I need help on how to connect Snowflake.From below screenshot I am trying to understand JDBC connection looks like.For e.g. I am using jdbc:snowflake://myorganization-myaccount.snowflakecomputing.com/, but it is not working.Any help is greatly appreciated.

1
2
3

Page 1 / 3

Badge winners

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

Powered by Gainsight

Community Terms of Use & Conditions Cookie settings

Sign up

Already have an account? Login

For Ataccama Customers and Partners

or

Username *

E-mail address *

Company *

Job Title *

A bit about yourself

How did you hear about the Data People Community? *

Ataccama version

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the Ataccama Community

No account yet? Create an account

For Ataccama Customers and Partners

or

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK