Data Quality & Catalog ⚙️

Please advise if there is an easy way to capture how much volume of data in total we have to report up to our CIO? I was thinking creating a plan but that will execute forever.  Any ideas?

We're currently working on a setup where different customers can see their own data in our Cloudera data lake. So when a customer looks at sample data or profiling data they should only see the row of their own data. I'm currently working on a solution for the profiling data. For this I want a service account for that customer to do the profiling. This service account can also only see the rows for that customer. I was thinking of creating a component for this that reads a database table with lists of customers, url resources and CIs (Hive tables) to profile. And then use a Json call that runs a GraphQL command to run the profiling as the correct service account. Unfortunately the url resource in the Json Call is the only part that cannot be parameterized (as far as I can see). The url resource has the authentication (One Desktop server connection), so that will not be the way to go then. Alternatively I was thinking of using authorization in the HTTP Header. Like this.But some experim

Hi everyone, Today we will cover how to use the search function in ONE Web Application 🔍Whether you're a business user looking for specific information or a technical user executing complex queries, our search engine has you covered. Let's dive in!There are two areas for search:Global Search: full-text search is enabled on the whole application and is a good starting point for searching entities and locating the area for the future detailed search if necessary. Search in Navigation Sections: combines full-text and filtering capabilities to query entities. Search options are restricted to the currently selected navigation section: for example, using the search bar in Catalog Items will only return results found within that entity and configured areas of search on this entity.1️⃣ Global Search: Discovering Catalogued EntitiesThe Global Search is your go-to tool for searching use cases across cataloged entities. It allows users to explore preconfigured entities like catalog items, terms,

Hello:I would like to use GraphQL queries to extract results of a monitoring project - and load the results into my own database table for reporting and other purposes. I need to make it split the invalid records - in a way  - that each record should be for one failed rule - even if the primary key record - has multiple DQ issues (failed rules).Can some one help me with sample code on how you may have accomplished it - if you did such a thing? 

Hello hive mind,I am calling an API that gets me some foreign exchange rate data (all from USD). The data that comes back is in this format:timestamp AUD EUR GBP 2024-04-24 12:00:00 1.538766 0.935636 0.803964  I’ve highly simplified this. There’s a possible169 currencies here, I’m only showing 3. I need to unpivot it and get it into this format:timestamp from_ccy to_ccy rate 2024-04-24 12:00:00 USD AUD 1.538766 2024-04-24 12:00:00 USD EUR 0.935636 2024-04-24 12:00:00 USD GBP 0.803964  My current plan looks like this: It is fine for 3 currencies. But not fine for 169!Anyone got any ideas for steps I can use to keep my plan clean and tidy? (And that I don’t have to make 169 copies of Alter Format 😱) 

Hello Ataccama team I am working with ataccama 14.5 , I would like to know if there is a documentation to know more about dpe service. Kind Regards

Hi everyone!In today’s post, I’ll walk you through the Policy Management module with best practices so that you can make the most of it in your organization. Let’s start with the basics: Understanding Policy ManagementPolicy Management is your one-stop hub for documenting and tracking policies and regulations that impact your entire organization. It's designed to help you stay compliant with regulations and internal policies. By using this module, you can easily define, organize, and monitor the rules and guidelines that guide your organization's operations. Navigating the Policy OverviewTo get started, head over to the Policy Management section on the left sidebar.Here, you'll find the All Policies tab that provides an overview of all your policies. Each policy is highlighted with different colors to indicate its status:No highlight: Published policy. Green highlight: Recently added policy. Orange highlight: Policy with requested changes. Red highlight: Policy with removal requested.C

Happy Wednesday Community! Today we will talk about workflows - let’s dive into it right away 🤿 Currently, workflows in Ataccama ONE are focused on the access request process. They offer additional automation for requesting changes to data access in ONE. Here are some key actions that workflows allow:If you have insufficient access rights on a node, you can request a higher access level from the node owner. The default assignee of the task can either approve or reject the request from the Kanban Board. For more information on tasks, check out our previous post on the community here.Before you can request access to entity data, make sure you meet the following prerequisites:The workflows:ableToStartRequestDataAccess trait must be enabled on the entity. Data access requests can only be enabled for the following entities: Catalog Item Source Location Connection Monitoring Project To view the list of workflows, navigate to Tasks And Workflows > Launched workflows tab. Here's what y

Hi,I created a Monitoring Project with a Catalog Item Loan from Source A. In the Monitoring Project I apply 100 DQ checks and I'm very happy. I want to change the source afterwards because I'm done checking the CI Loan from Source A and need to check the same CI (not same data) from Source B. Is it possible/doable to change the underlying Source A to Source B keeping the 100 DQ checks in the same Monitoring Project? I heard it was possible, but couldn't find it anywhere in the community.

Hi Community!I was wondering if anyone has used the Security term (as extension of term) functionality in OneWeb and if so how. There seems no documentation available from the Documentation portal or the Community to clarify the modeling choices. The node has the following properties regulation is a string instead of a reference to node regulation and responsiblePerson is also a string. The effectiveDate is not of type date but string as well. Why would this be?Anyhow, I would appreciate if anyone can shine some light on this.Thanks and kind regards!Albert

We want to profile Hive managed tables in our Cloudera data lake. This is only possible if the Hive managed table is defined as non transactional. However to turn of that feature you need to rebuild the table. We had a discussion with our architecture team and they don't want to turn off this functionality.The other option then is using Hive Warehouse Connector. It is known that this has some performance costs. But we want to test this anyway.Is there any documentation on using this feature?

Hey all, Has anyone been able to integrate with TWS for kicking off Reconciliation or Data Quality Project runs? I have users asking if their DQ Projects can run after their jobs have run which are scheduled by TWS. I was thinking that there has to be a way that Ataccama could listen for when a TWS job runs and finishes, it could kick off a DQ or Reconciliation project to also begin running. Has anyone successfully set this up before? either in the Orchestrative server or within Ataccama Desktop?Thanks

How can I map custom input parameter for Validation component in Ataccama One Web UI?   

I have a workflow that runs multiple components. In the workflow I have a parameter called load_id that I would like to use to query all kinds of tables later in the flow. But if you use a JDBC Reader in your component you can't use the parameter in the query. You could if you were able to do an Alter Format before the JDBC Reader, but JDBC Reader allows no input.I've seen some tips here in the Community, like these: But initially I still ran into some issues before I got it working. So I decided to share a working example.This is my very simple workflow.It only has a Run DQC task that will run the component.But let me show the global variables in my workflow. I hardcoded the load_id, so my query would get rows back. Now lets look at the configuration of the Run DQC task: As you can see, I run the parameterinquery.comp component and pass on the load_id with the expression """"+load_id+"""" .On to my component:The Random Record Generator is the start of this, because with the JDBC Reade

Hi Community,In a term's listing (overview) page you can click on the term's name after which the detail page for that term opens. If you click beside the term's name a kind of preview pane or side window opens, also showing details for that particular term. So like this:In the details screen it is possible to change the page layout, which is especially important after having added custom properties, so that a logical layout can be retained.It looks though that for this preview pane the layout cannot be changed. Does anyone of you know how to accomplish this?Kind regards,Albert

Please advise if you have any documentation that provides a short description on each Ataccama functions pertaining to user access:  for exampleAtaccama Function Description  Administrator Data Owner Data Steward Custodian System   Full access       User Management   Full access Editing access View metadata access View metadata access Source   Full access Full access Full access View metadata access Connection   Full access Full access Full access View metadata access Folder Folders in Workspace are intended for storing SQL catalog items and virtual catalog items (VCIs).  Full access Full access Full access Full access Location   Full access Full access Full access View metadata access Catalog Item   Full access Full access Full access View metadata access Term   Full access Full access Full access View metadata access Rule   Full access Full access Full access View metadata acc

Hello everyone!In the new version of Ataccama 14.5, Is it possible to add comments on tables and fields from the database automatically to the Description field in Ataccama ONE, if the Description is empty and the Comment from the database is not empty?I will be very grateful for your help🤗Thank you!

I know that it is possible to use variables in filenames in a Text Writer (see here: Text File Writer: adding a datetime as suffix to an output file (ataccama.com)). But what about the Request and Response Debug File in a Json Call?I have a component for ServiceNow integration and I want to reuse another component to retrieve incident details. But when I run the main component I get this error:File file://d:/Ataccama/workspace/SNOW/distribution/debug/03_getincdetails_request_debug.txt must not be multiplicatively accessed in writing mode.The only way to get it all working, is by removing the Request and Response Debug File in the Json Call that gets incident details. A possible way around this would be if I could use variables in the filenames. But this does not seem to work in the same way that variables work in Text Writer steps (by putting the variable name between { } ).Is there another way?

Hello everyone,I’d like to set up access permissions in Ataccama One so that users within a particular stewardship group are limited to making changes only to that specific group (e.g., adding/removing users from certain roles within that group)?For example, HR users should only be allowed to make user related changes within the confine of the HR group.However, the user management seems to be a global page and does not have stewardship-specific access. If anyone has insights on how to achieve this restriction, could you kindly share your workaroundThank you in advance!Ben

Hi everyone, and happy Thursday!As I’ve mentioned starting this week, this post will be the last of the Ataccama ONE Web Best Practice Series for a while because…… we are moving on to ONE Desktop next week on! In this post, we’ll cover Workflows, and I highly suggest checking out the Tasks article from yesterday before reading it if you haven’t checked that out. It will help out with laying the foundation for workflows.Let's explore how these workflows supercharge your access and review request processes. Demystifying WorkflowsIn the realm of Ataccama ONE, workflows are your dynamic companions for handling access and review requests.Access Request Workflows automate data access change requests. Imagine needing higher access to an asset – this workflow empowers you to request and assigns the task to an approver, who can then give it the green light or a gentle decline.Review Request Workflows introduce automation to review changes made to data assets and get them published. If you hold

Hello:I really appreciate the commnity helping me solve more use cases and get value out of the investment we made in Ataccama. Now - i have another area that i need help with.We have a vendor that drops a file every night - this is not comma delimited and not fixed length. Based on the first character of the line, it decides the format of that lineFor ex: if char(1) is - 1 - then the lenght of the file will be 10 characters with first 5 characters as identfier and next five char as status.But if the first character is 2 - that means it is a different type record (type 2), that has 100 characters in length - and each of them fixed length positions. Now - when i scan that file through Ataccama, it is thinking the file attributes based on the first row. But is there a way i can give the metadata to the profiler?And by the way, i need this to be a monitoring project that runs DQ on a demand basis (that i would like to trigger through Airflow when the file arrives)can some one give me some