Skip to main content

Data Quality & Catalog ⚙️

Discuss, learn, ask, suggest, share all things DQ&C 🔍

  • 554 Topics
  • 1,353 Replies
554 Topics
D
Data Enthusiast
DhavalMData Enthusiast
asked in Data Quality & Catalog ⚙️
How to mark unique queries based on their structure?

I have data coming from a SQL database. For most queries, the structure of these queries remains the same, as shown in the picture, with only the attribute name changing. Now, I want to classify these queries as unique based on their structure rather than the attribute name.Demo DataThank you.Regards,Dhaval 

362
D
Data Enthusiast
22 hours ago
kayhan.turker
Ataccamer
kayhan.turkerAtaccamer
published in Data Quality & Catalog ⚙️
Passing a dynamic query into a JDBC reader

Hi community!Today, I have a quick tip to share on how to pass a dynamic query into a JDBC reader. If you are using ONE Desktop as part of your day-to-day this would be a good practice to implement when it comes to using the JDBC reader step.OverviewThe following is a working example of passing a dynamic query into a JDBC reader. Its overall structure consists of two plans that are run sequentially in a workflow. The idea is that the first plan will produce the query that the second plan (that includes our main logic) will use.In the above example, an audit table is read in the second DQC plan, but with a query that depends on information on the current state of the table (for example, the maximum of a particular record, record count, and latest refresh date). First Plan - Retrieving QueriesIn the first plan, functions and variables are applied to produce a .sql file that contains the JDBC reader query to be used.As an example, functions can include getting the current date to apply a

992
kayhan.turker
Ataccamer
1 day ago
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

201
ivan.kozlov
Ataccamer
1 day ago
Albert de Ruiter
Star Blazer L2
Albert de RuiterStar Blazer L2
asked in Data Quality & Catalog ⚙️
Text File Writer: adding a datetime as suffix to an output file

Hey all,I was wondering if you ever came accross the following requirement and has some tips maybe to implement it.The Text File Writer step can be used to create for instance log files. For tracking or governance reasons it may be necessary to keep all log files. But because the output file name is fixed, each time the file will be overwritten whenever a new one is created. Of course it is possible to manually add a datetimestamp to the file name after its creation, but that is a rather cumbersome approach. So I would like to be able to add a datetimestamp to the file name automatically. Does anyone have a suggestion?Kind regards,Albert

1056
Albert de Ruiter
Star Blazer L2
5 days ago
O
Star Blazer L1
OjaswiniStar Blazer L1
asked in Data Quality & Catalog ⚙️
Environment variable $environment$ variable in the subject line in RDM notification

Hello,Has someone used $environment$ variable in the subject line in RDM notification or any other notification emails? We are experiencing an issue with the RDM when using the environment variable within our email notification template. When we configure the template to include $environment$ in the subject line, the received emails do not display the variable.  Thanks,Ojaswini

624
A
Ataccamer
7 days ago
K
Ataccamer
KaterinaAtaccamer
published in Data Quality & Catalog ⚙️
Enhancing Data Quality Evaluation with Component Rules in ONE Web

Speaking about data quality rules, we usually refer to DQ rule configuration in ONE web application. However, when it comes to referencing external sources or performing preliminary work or combining different sources, we may find that the capabilities within ONE Web are insufficient for our needs. For example, consider a scenario where we need to validate whether our data matches an external data source, such as ABN Lookup on https://abr.business.gov.au/. This is where component rules come in handy.The Task at Hand: Validate ABN Information.To implement this data quality (DQ) check, we require a component rule.Here's how you can configure the ABN validation component and use it for DQ evaluation: ​​​​​​​Configure a placeholder for the component Configuring Logic for the Component using ONE Desktop application Adding Changes to Runtime Configuration in ONE Web Application Configuring the DQ component rule Applying the Rule​​​​​​​Configure a placeholder for the componentNavigate to DQ s

2457
anna.spakova
Ataccamer
7 days ago
R
Data Voyager
ritguptaData Voyager
asked in Data Quality & Catalog ⚙️
Metadata Reader Plan to Export Column Names

Hi,I am looking for a plan to export column names for a catalog item in One Web. Can someone help me with it?Thanks

472
ivan.kozlov
Ataccamer
8 days ago
R
Data Voyager
RoelantVosData Voyager
asked in Data Quality & Catalog ⚙️
Query the monitoring report results at item level

I’m hoping anyone has some good GraphQL examples to share. For us, it is necessary to integrate Ataccama into our standard reporting. To do so I’m trying to get a GraphQL working that returns the scores for each item in a monitoring project. Ideally, listing out all monitoring projects and items with their scores - for the latest processing (although I’ll take all at this point and filter the old ones later). This is all about the statistics (# records passed/failed etc. not the individual results - I am aware I can create post-processing plans to export data, but this is not applicable here).It’s basically the overview from the report tab in the monitoring project, at item level:I can get everything I need, including the total row count except the passed or failed figure. I have tried and looked at all GraphQL examples everywhere, including ONE API :: Ataccama ONE, and have pieced this together based on the structures visible in the desktop app. Things like DqAggregationResultOverTime

231
R
Data Voyager
9 days ago
R
Data Voyager
RoelantVosData Voyager
asked in Data Quality & Catalog ⚙️
Reproducing the Term level Data Quality overview from GraphQL

Hi Ataccama community,I’m hoping someone with better grip on the Ataccama GraphQL model can shine a light on this. For internal reporting, we are looking to retrieve data quality details via the Ataccama GraphQL API. One of the requests it to produce an overview of the DQ score across the (rule’s) DQ dimensions. This is basically the same as is shown in the web UI when navigating to the ‘Data Quality’ tab for a Term. It shows the score broken down by dimensions, based on how the rules are defined.What I’m trying to do is retrieve the passed/failed rows at this level, so for each term and each dimension. This would allow me to summarise this into a score per dimension.However,  I am unable to get this out of the API.I’ve approached this from both the ‘terms’ and ‘rules’ pathway. In both approaches I always end up with the ‘Overall Quality’ score for each term - not the per dimension details.The ‘rules’ query looks promising, but ultimately only returns the passed/failed records for the

864
R
Data Voyager
9 days ago
R
Data Voyager
Raj YalakaData Voyager
asked in Data Quality & Catalog ⚙️
How to Add Date Parameter to output file extension

Hi, I’m trying to add the data value to the file extension in the component but I’m not able to get the expected results. I have added a new string column using alter format step (tostring(today(), 'yyyy-MM-dd'). When I pass the column as $date or ${date} in the output filename, I’m not seeing the data on the output filename. 

2004
S
Ataccamer
12 days ago
T
Data Voyager
ThanujaData Voyager
asked in Data Quality & Catalog ⚙️
Audit config in One desktop

Can anyone guide me on how to generate an audit for every action, log it, and integrate the logs with the UI in Ataccama One Desktop? Any best practices or examples would be greatly appreciated!

273
Albert de Ruiter
Star Blazer L2
12 days ago
D
Data Voyager
Devi
asked in Data Quality & Catalog ⚙️
Runtime error in JDBC reader: Error creating record

Encountering with Runtime error in JDBC reader, while running the basic profiling for a table from SQL Server. Full Error details -Runtime error in JDBC reader: Error creating record: column type: 'STRING', read value: '<null value>', read object type: '<null value type>', cause: Connection reset Looking for ideas troubleshooting this error.

162
Cansu
Community Manager
12 days ago
M
Data Enthusiast
mbiteyeData Enthusiast
asked in Data Quality & Catalog ⚙️
Monitoring Project Specific Notifications - Separated

I have been testing rule specific notifications within monitoring projects and it seems to add those notifications to the bottom part of the general notifications, but we are trying to see if we can receive separate emails due to different users needing to see specific issues.The documentation link is shown in the link below,https://docs.ataccama.com/one/latest/monitoring-projects/results-reports-notifications.html#specific-notifications  

221
K
Ataccamer
12 days ago
Prasad Rani
Data Pioneer
Prasad RaniData Pioneer
posted in Data Quality & Catalog ⚙️
I would like to get alert when any new data flagged with PII

Hello: I would like to create an alert - while scanning the datasets - if it flags any data to be PII (such as Social Security Number, Data of Birth, Tax Identification Number) etc., Is there a way to get alerted when a specific term is assigned to any catalog item attribute? 

291
W
Data Pioneer L2
12 days ago
may_kwok
Star Blazer L3
may_kwokStar Blazer L3
asked in Data Quality & Catalog ⚙️
Setup connection to an SFTP server in ONE Desktop

Hi folks,I’ve been given details to an SFTP server, and I can successfully connect to it using Winscp on my laptop: I tried to setup connection in ONE desktop:I put workflow task:But I get an error:14.11.2024 15:15:21 [INFO] Using following licenses:14.11.2024 15:15:21 [INFO] C:\Users\mkwok\license_hamilton_USER_v14_subscription_2025-01-29.plf14.11.2024 15:15:21 [INFO] ============================================================14.11.2024 15:15:21 [INFO] This is a subscription USER license for developers' laptops for "Hamilton". It expires on 2025-01-29.14.11.2024 15:15:21 [INFO] ============================================================2024-11-14 15:15:21 [INFO] com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvider reason=the 'properties.encryption.keystore' property not specified2024-11-14 15:15:21 [INFO] com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvid

175
may_kwok
Star Blazer L3
12 days ago
Albert de Ruiter
Star Blazer L2
Albert de RuiterStar Blazer L2
published in Data Quality & Catalog ⚙️
Business glossary - synonyms (part 5)

Hi Community,The first posts about the business glossary dealt about applying more term types (attribute and entity terms), and how they get context by adding relationship types. Following posts described an implementation for multilingualism and how to apply computed content. Especially the last one was rather tough to digest, so for my last post about the glossary I promise a soft landing.I think one thing needs some further attention and that regards synonyms.Defining a synonym for a term is existing functionality: you can define a synonym by pointing to another term.This means though that when you want to define a synonym for a term, you would have to define a new term first. For that term you would also have to define its metadata. In fact the new term including metadata would be redundant with the original term. Or would you leave out the additional metadata?We chose to use a different approach: for a synonym only its name is relevant, as the other metadata would be the same. So

90
Albert de Ruiter
Star Blazer L2
13 days ago
R
Data Voyager
ritguptaData Voyager
asked in Data Quality & Catalog ⚙️
Post Processing Transformation Plan in One Web

Hi,Can some help me with creating a post processing transformation plan that shows a different row for each DQ rule that has passed/failed on a particular field in the transformation plan in One Web UI. For Eg: I have 2 rules, a uniqueness check and a format check on the ID field. In the post processing output file, what’s the best way to see how I can split this for each rule and see the pass/fail metrics for each rule.Thanks

251
Cansu
Community Manager
13 days ago
R
Data Voyager
RAZORXData Voyager
asked in Data Quality & Catalog ⚙️
Policy Tagging to Business term or any other asset

Hi Team need your expert opinion on how to tag Policies to Business Terms or any other assets(Applying policies to asset types) in 14.5 version? I cannot see any options for the same is it any version limitation or any customization needs to be turned on. Any help is appreciated.

304
R
Data Voyager
14 days ago
B
Data Voyager
BhuviData Voyager
asked in Data Quality & Catalog ⚙️
Uniqueness DQ Evaluation rule

I am currently using 14.4.0.one-44751-landing-pa-230616-287787-f83b54a4 ONE web application version. While creating a Uniqueness Rule I am not getting WHEN condition as “is unique” and “is not unique” . Could someone help me understand why I am not getting the uniqueness condition  instead Validity condition.  

231
anna.spakova
Ataccamer
14 days ago
E
Data Voyager
evan.sasowskyData Voyager
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"))

221
anna.spakova
Ataccamer
14 days ago
S
Data Pioneer
sumeyraData Pioneer
asked in Data Quality & Catalog ⚙️
Writing DQ rule for interval values

Hello all,I want to create a DQ rule, In this rule I need to check a numeric field if the value is in the predefined interval or not. Let me give an example of logic. I have a column X contains ‘types of product’ and column Y contains ‘value of product’. And have a list of valid values. If the value of X is ‘abc’ then Y must be in the interval 1-30. If hte value of X is ‘xyz’ then Y must be in 1-200 and so on.I was going to create a lookup file for this one, but couldn’t be sure how to define intervals. Does someone know how to implement my DQ rule for this logic ? Thanks a lot !

183
T
Data Pioneer L2
14 days ago
N
Data Voyager
NBalaguraData Voyager
asked in Data Quality & Catalog ⚙️
Bulk editing of metadata using reference excel file

Hi Ataccama community. Could you please share examples of plans used for adding a new metadata entity and bulk loading values from excel file.We have an excel file with sensitivity level defined for each attribute. We need to add an entity called e.g. sensitivity level and to import this from excel file.  

90
N
Data Voyager
15 days ago
greglvaughan
Data Enthusiast
greglvaughanData Enthusiast
asked in Data Quality & Catalog ⚙️
monitoring project processing custom label

Issue: We receive files to be tested against our DQ rules (Monitoring Projects) every 2 weeks.  Each set of files is referenced by its date created (aka 2024-10-01,2024-10-14...).  When running Monitoring Projects against these items we only get the Execution Date which can be different from the file date.   When extracting data for reporting from ONE we only have the Extraction Date and don’t necessarily know which file date the plan results are for (sometimes have to rerun old files for new rules etc..).  Question:  Is there a way to add a custom attribute / parameter for when we run the Monitoring Project (at the processing id level) so we can report our DQ results by File date?  The 2 options we could think of: In extraction component connect to the catalog items and get the file date which is in the table itself (tried this but we need to extract history so would need file date, catalog item, and Monitoring Project processing id to join with DQ Aggregation Results tasks in the com

476
Cansu
Community Manager
15 days ago
E
Data Voyager
evan.sasowskyData Voyager
asked in Data Quality & Catalog ⚙️
How long should it take to kill a job in the DPM?

I’ve recently noticed that some jobs I’m trying to kill, jobs which happen to running for much too long (~2 days), take a long time to kill. Is that a bug in the kill function or maybe related to the jobs themselves taking so long to run?

70
E
Data Voyager
18 days ago
C
Data Voyager
ChrisAbdelmalekData Voyager
asked in Data Quality & Catalog ⚙️
Exporting Monitoring Projects

Hello everyone, We recently upgraded to version 13.9.3, and gained the ability to export DQ rules from one Ataccama environment and import them into another. This works great, but I need to do the same thing for our monitoring projects. I would like to be able to export them from DEV and import them into a higher environment.  Unfortunately, there doesn’t seem to be a plan available in my version to export monitoring projects. Has anybody figured out a way to migrate monitoring projects without recreating them in each environment? Alternately, I am considering trying to write my own plan. Is there any documentation out there on how to write the JSON for export plans? Thanks!

1995
Cansu
Community Manager
25 days ago

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