Data Quality & Catalog ⚙️

Hi, In ONE Desktop > Servers > OnePlatform > Monitoring Projects > Create new > Post Processing Plan > client_dataset_invalidrecords (as a name to the component) > a new component will be created accordingly. Once created, is it possible to rename the component?

Hi All, At Bupa, within our Power BI environment we have a number of reports that have been tagged with a sensitivity label of ‘Confidential - Internal Use Only’ or ‘Highly Confidential: Internal Use Only’ using Microsoft’s sensitivity labels. https://learn.microsoft.com/en-us/purview/sensitivity-labels When reports have one of these labels applied, the data returned by the Export Report API in Power BI is encrypted. This is the main API call that the Ataccama scanner uses to extract metadata/lineage information for ingestion into the catalog. As the data returned is encrypted, the scanner is not currently processing it and skipping to the next report. Reports - Export Report In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn Has anyone come across scenario in their own environment and been able to identify any workarounds/ways forward to capture lineage for those reports with a higher sensitivity label? Either on the Ataccama side or the Microsoft side? Below is what

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!

I'm facing an issue with selecting schemas to observe for schema change detection in Observability for one of our sources(Sybase). Context: In our SQL database source setup, we have a single connection that includes multiple schemas, and Observability allows us to select multiple schemas without issue, as shown below. However, for the Sybase source, we're unable to select multiple schemas under a single connection. I only get the option to choose one connection and one schema from the dropdown. (See screenshot below.) Ideally, I’d like to select all dbo across all connections to monitor for structural changes. Question: Has anyone experienced a similar limitation?Is there a recommended approach for configuring Observability for schema checks on sources that have multiple connections and schemas under a single source — especially in cases like a Sybase database, where multiple connections are used? Any guidance or best practices would be greatly appreciated.

Hello, Is this possible now in latest version? I am using 15.4.0. Requirement is to schedule profiling of specific schema in the database. Or subset of that schema if schema is too big (set of tables). Thanks in advance.

Hello, I have two questions I would love to inquire about: 1. Exporting Lookup Items in Ataccama I would like to know if it's possible to configure exports for lookup items in Ataccama.When I try to export my lookup items, the export option is greyed out. When I hover over it, I see a message saying: "No export plan exists for the selected lookup items." Under Global Settings > Import and Export, I see an option to create a new export plan. I tried using this, but got to a stage where I need to input a code for the export plan. I found the following JSON online and was wondering if this would work as-is or if it needs any tweaks: { "name": "Export_All_Lookup_Items", "description": "Exports all lookup items for backup or migration", "type": "LOOKUP_ITEM", "format": "JSON", "filters": { "lookupTypes": ["ALL"], "tags": [], "projects": [] }, "output": { "combineIntoSingleFile": true, "fileName": "lookup_export.json", "includeMetadata": true }} Would this JSON-based export plan enable the e

Use Case; to configure a scheduled profiling job daily for a specific schema of a data source within Ataccama Web application and not via Desktop?

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.

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

Is there any mutation to create terms in Ataccama web using API.

Are you looking to connect to SAP HANA using jdbc driver? Here are the simple steps Download and copy SAP HANA jdbc driver file into /opt/ataccama/one/dpe/lib/jdbc/ folder Add a set of properties for SAP HANA driver in /opt/ataccama/one/dpe/etc/application.properties.( Check the attached document for properties) Restart DPE & check logs of DPE service for any errors Go to ONE Web UI and new driver “SAP HANA” is available under connections “Select Connection type “drop-down menu

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.

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?

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!

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

Hi, ONE Web > Monitoring Project I 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? ​​​

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

Is anyone able to provide guidance on how to make the businessDefintion a required field when creating new terms?

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.

Can we add reference data in case statement in Computed content?

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? Thanks Category Value A 5 B 2 C 6 D 4