Skip to main content

Learn & Share

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

1077 Topics
H
Universe Traveller
Hanish NUniverse Traveller
asked in Data Quality & Catalog ⚙️
Get updated data and created date of any entity via API

Is there any way to get updated date, created date and deleted date of any entity via API. Basically we should get the data whatever we are seeing in history tab.Please let me know if we have any API query for that.

250
H
Universe Traveller
M
Star Blazer L1
mp_ataccamauserStar Blazer L1
asked in Data Quality & Catalog ⚙️
How to add Custom DQ rules as auto suggested rule for any attribute

HelloCan we add custom DQ checks added by Ataccama users to the list of automatically suggested rules for a any attribute? If yes, how? 

383
Lisa Kovalskaia
Ataccamer
V
Data Voyager
vishnuData Voyager
asked in Data Quality & Catalog ⚙️
How to send multiple records to one email?

These are some sample records generating through the One desktop plan. Finally, these results will send to the Responsible persons who can resolve these issues. So in this results, we have three issues assigned to two users, instead of sending two emails, how can we send one email to Mohit?In the Send email step, we are using HTML. Please see the below code.This is a sample email received.  

503
anna.spakova
Ataccamer
L
Data Voyager
lokeshpottiData Voyager
asked in Data Quality & Catalog ⚙️
Compare sql caalog vs file

i have a sql catalog in one web and i have a file in sharepoint now what is the best way to compare the contents of sql catalog and file ?will virtual catalog help ? if yes how could i do it ?  my idea is to join sql catalog and file as full join in one desktop and use this joined data as a catalog in one web application . how to do it ?

293
L
Data Voyager
A
Data Voyager
aisayev001Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
On-Prem AI Chat Widget Integration into Ataccama ONE UI

Hi everyone, We’ve developed an on-premises AI agent that supports users in data governance tasks such as data quality monitoring, catalog navigation, and metadata enrichment. We’re now looking to integrate this AI agent as a chat widget directly into the Ataccama ONE user interface.Our goal is to embed a floating or sidebar-style chat widget inside the Ataccama UI to provide real-time assistance to users without modifying the Ataccama core UI code.This is strictly for on-premise deployment, so cloud-based or external proxy solutions are not relevant for our use case.We’d appreciate any insights or guidance from the community on the following: Has anyone successfully embedded a custom widget into the Ataccama ONE interface? Are there any supported mechanisms or hooks for extending the UI in on-prem installations? Are there UI customization capabilities available in the Ataccama ONE roadmap for partners or customers? Happy to share our approach and progress with the community as we

491
A
Space Explorer
T
Data Enthusiast
tyler manawesData Enthusiast
asked in Data Quality & Catalog ⚙️
How to create a column on the Terms overview page to display a referenced object array

Hello!My org wants to create a new column on the Terms overview page to display items from a referenced object array. Specifically, we want to display Data Protection Classification information there on the overview page in a column. At first, we were told this was not possible, but we have seen this done on another one of our overview pages that displays Policies, which is also a referenced object array.  This was created for us, and the json from the “Edit Page” screen looks like it is inherited from another entity. { "_type": "entity.page.listing", "children": { "_type": "entity.listing.v2" }} Here is what our current Terms overview page layout looks like:  And the JSON behind the layout: { "_type": "entity.page.listing", "children": { "_type": "relationships.hierarchyListing", "enableSelection": true, "columns": { "type": { "dataPath": [], "name": "Type", "after": "name", "renderer": { "_type": "glossary.termType.tableCell"

786
anna.spakova
Ataccamer
C
Data Enthusiast
csapocheData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
Best practice for utilizing/stacking multiple validations for RDM

Hi All - new to Ataccama’s products and I’ve got a question re: RDM and validations. What is the best practice for creating multiple validations for a field (column) level validation, with the aim being reusability and scalability? For example, I might have the following use cases:string must be all upper case string must not contain all spaces string must be camel case string must be alpha characters only string must be alphanumeric only string can contain digits but not special characters …...etc - the list could be lengthy!…….And I want to apply the rules in various combinations like this:Column A: 1,2,4 Column B: 1,2,6 Column C: 1,2,3,5….etc.Current thinking: It seems like domains would be a good place to start, but that given the different permutations it would mean creating a multitude of domains, and the regex could be cumbersome.  Expression validations don’t promote reuse Online services: this might be more in line with modularizing validations - setting up a “library” of vali

80
C
Data Enthusiast
P
Data Voyager
pickle21Data Voyager
asked in Data Quality & Catalog ⚙️
Duplicate table Detection

HI I need to find duplicate tables by comparing the row to row from two or more than two tables. i have 300 tables i need to find duplicate tables. Please help to find this out

231
Lisa Kovalskaia
Ataccamer
M
Star Blazer L1
mp_ataccamauserStar Blazer L1
asked in Data Quality & Catalog ⚙️
Is it possible to integrate MS Teams using office 365 workflows?

Hello,I want to integrate my Ataccama monitoring results with Teams notification.I checked the below link but Office 365 connectors within Teams are retiring, that's may be why I do not see Incoming webhook on my Teams. Is there any way to set up Teams with Atacamma using workflows instead?https://docs.ataccama.com/one/latest/notifications/ms-teams-integration.html#add-incoming-webhook-to-ms-teams-channel Please suggest.

353
Lisa Kovalskaia
Ataccamer
K
Universe Traveller
kellymremzilybUniverse Traveller
asked in Data Quality & Catalog ⚙️
Monitoring Project Missing Report

Hello, I have a rule looking for unique vendors that is tied to a monitoring project.  The monitoring project is running on a regular basis; however, the report is not showing on the report tab of the monitoring project.  This is the only project I’m seeing this behavior.  Has anyone encountered this issue?  We are on version 16.1.

111
Lisa Kovalskaia
Ataccamer
A
Data Pioneer
akshayl09Data Pioneer
asked in Data Quality & Catalog ⚙️
Adding Notification to Monitoring project for all the rules

How to add notification to all the rules in monitoring Project for all the catalog items and set alert at 95% at once instead of doing it manually one by one?

436
A
Data Pioneer
W
Universe Traveller
WesTUniverse Traveller
asked in Data Quality & Catalog ⚙️
Monitoring Project Summary Exports Not Generating/Landing in S3

Last week we noticed that the export files we created for the summary results of monitoring projects are no longer generating and landing in our S3 bucket. The component/scheduler/workflow were all created by an Ataccama consultant and so we never tamper with these in ONE Desktop. One thing that recently changed is the way the DPE works with the monitoring projects. We were having trouble with scheduled monitoring projects running (they would always fail). Our platform engineer determined that the scheduled runs were going to the wrong DPE so he forced it to go to the hybrid-DPE instead. The scheduled monitoring project runs are no longer failing, but coincidentally the summary export files stopped working the same day that the scheduled runs problem was fixed. Could the change with the hybrid-DPE be the cause of the issue?

433
A
S
Space Explorer
Shefhali singhSpace Explorer
asked in Data Quality & Catalog ⚙️
toDate function in Ataccama

Hi All,toDate(Input, “yyyy/MM/dd”) function is not throwing null when I am passing value “1/1/1”. Input datatype is string.can anybody help why it takes 1/1/1 as valid date value?Regards,Shefhali

323
S
Space Explorer
C
Data Enthusiast
csapocheData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
Is there a way to change the default Referenced Data Display mode globally?

I’d like to default the referenced data display mode to “label” rather than “binding keys” as the default display mode option for all tables. See this link for details on how it is changed per table: Viewing Data in RDM :: Ataccama ONEIs there a way to accomplish this?

173
A
E
Universe Traveller
evan.sasowskyUniverse Traveller
asked in Data Quality & Catalog ⚙️
Date Field Format Data Quality Check

Hey y’all, I was wondering if anyone had a quality rule or advice on how to construct a quality rule to check a date type field for formatting. I know there is the “matches” function for strings and that you can convert a date field to a string using “toString”, but that requires you to specify a format, which invalidates the point of the rule.The desired format is “MM-dd-yyyy”, as shown in what I’ve got so far.matches("^\d{4}-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01])$",toString(ATTRIBUTE_1, "MM-dd-yyyy"))

1417
S
Space Explorer
A
Data Voyager
Apurva KapoorData Voyager
asked in Data Quality & Catalog ⚙️
What the different types of APIs available for read and write of Metadata and Data that can be used ?

Can someone share the list of different types of APIs available for reading and writing of Metadata and Data that can be used along with their GraphQLs ?

546
A
S
Universe Traveller
shikoh.zUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
How to acess MDM Web Application

Hi,I'm currently working with Ataccama ONE and would like to access the MDM (Master Data Management) Web Application. Could someone please guide me on the steps to access it? Specifically:What is the typical URL format to access the MDM web interface?Do I need any specific roles or permissions to view or manage master records?Is there any difference in access for cloud vs on-premise deployments?What should I do if I don't see the MDM module after logging in?

293
E
Ataccamer
V
Data Voyager
vvalcakData Voyager
asked in Master Data Management & Reference Data Management 🛰️
XSD validation of XML files

Hello,do you plan to add feature for One Desktop regarding xsd validation of xml files? So it is possible to check if the xml file has correct structure.Thank you.RegardsVeronika

70
V
Data Voyager
C
Data Voyager
ckaushikData Voyager
asked in Data Quality & Catalog ⚙️
Ataccama ONE Certification Queries

What is the exam fee for  Ataccama ONE v13 Data Quality & Governance Foundation Level certification for attendees who exchange a minimum of 12 months hands-on experience for the must have training? How can we apply for the certification exam? Is the application process online or offline? Is the exam proctored? 

4569
A
H
Universe Traveller
Hanish NUniverse Traveller
asked in Data Quality & Catalog ⚙️
API to trigger ONE Desktop job

Do we have any API that will trigger ONE Desktop jobs? We are doing some post DQ steps in databricks, we want to trigger ONE Desktop job from that notebook via API. Could anyone help me on this?

361
ivan.kozlov
Ataccamer
Lisa Kovalskaia
Ataccamer
Lisa KovalskaiaAtaccamer
published in Data Quality & Catalog ⚙️
How to organize assets in ONE web app: adding columns and filters in Business Glossary

Adding more details to a list view and providing additional filtering options can help business users in their daily tasks as you scale Data Governance across multiple teams, geographies, or business functions.In this article we’ll customize the Business Glossary to show additional term attributes as columns in the list view and to enable filtering by those attributes. This approach generally works across the Ataccama ONE Web app, so you can use this article as a guide to customize other pages, for example Rules, Catalog Items, or Monitoring Projects.You don’t have to be a developer to follow this guide. If you come across any concepts you’re not familiar with, have a look at our documentation. Adding columns First, navigate to the Business Glossary’s Terms list. In the top right, find the 3-dot menu which features the option to Edit page. In the side bar that opens up, go to the Layout tab. You’ll see the JSON that describes how the objects are shown on this page when the web app load

72711
Lisa Kovalskaia
Ataccamer
M
Star Blazer L1
mp_ataccamauserStar Blazer L1
asked in Data Quality & Catalog ⚙️
Can we create a lookup with two columns and use it DQ check

hi,I have a scenario where two columns ID and Value to be verified using DQ check together (like key value pair) against two columns of Table1 key (compared against ID) and name (compared against Value)I am using Atacama web, I see we can create lookup but it could be created only for one column and not both.Appreciate your suggestions here.Cheers!

351
ivan.kozlov
Ataccamer
S
Universe Traveller
Susan24usUniverse Traveller
asked in Data Quality & Catalog ⚙️
Business Term Bulk Update

I have a plan that reads a CSV file from my storage and writes the data to the Business Glossary page.What I Want to Achieve:I would like to enhance this plan to not only insert new terms, but also check for existing terms and update them if necessary to avoid duplicate If a term already exists and nothing has changed, it should be skipped. If the term exists but the definition (or any attribute) has been modified, it should update the existing entry with the new information. If the term does not exist in the glossary, it should be inserted as a new entry. Challenge:I noticed that some solutions in the community reference a unique ID for each term---community chat on bulk term update, but my business glossary terms currently do not have an ID field.Question:How can I structure the plan to perform insert, update, and skip logic effectively, What’s the best practice for comparing and managing term updates in this scenario?below is a snip of what my current plan that write only new pl

351
Albert de Ruiter
Rocket Pioneer L1
V
Data Voyager
VertigoData Voyager
asked in Data Quality & Catalog ⚙️
unzip GZIP DB Column - attacama one desktop

 Hi, I am using Ataccama One Desktop 15.4.0. In this case, I am creating a DQC (Data Quality Center) plan with an HANA database as the source. Now, in this database, I also have columns with GZIP data. I would like to unzip these in the DQC plan, but how? Unfortunately, the database does not have this feature. Such functionality does not exist in DQC either. Developing a custom step? It's possible, but apparently not encouraged by Ataccama. Perhaps you could recommend an approach. Best regards, Sergej

140
V
Data Voyager
S
Data Pioneer
sumishaData Pioneer
asked in Data Quality & Catalog ⚙️
ADLS Connectivity from One Desktop

Hello, I am trying to make connectivity to ADLS in Azure subscription from One Desktop. What would be the Authentication token endpoin?

222
S
Data Pioneer

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