Learn & Share

Is it possible to create a data asset from an ETL job (SSIS or similar) so that this is included in the data lineage to allow for full impact analysis 

Currently only 4 sources are supported for data stories and they are mentioned below: Amazon Aurora PostgreSQL ONE Data PostgreSQL Snowflake We also use synapse as source for a lot of catalog items and it would be great if you can add synapse as well to the above. 

Hello,How we can delete one of the components in One Desktop? I created virtual catalog item through One Desktop. Virtual catalog item has already been deleted but its component still remains.  I want to delete its component as well.  For example, I want to delete component “branch_dwh_vs_lake”. How can I delete it from desktop?Thanks in advance, 

I have a data set created and the query runs fine in a sql editor against my local database. I can deploy the configuration with no errors, but when I go to look at the data in Ataccama One I get Fatal error occurred and click on Details just gives me Internal error. The only thing I can think of is the query is rather long. Is there a max for data set sql? What is the best way to try to troubleshoot this? The error messages are not at all helpful.

Hi, I notice that for some of my terms, the visual Insights is visible and for others it is not. What is the reason for this?Second question: I would want to automatically assign terms. if the column is named wnplts then I want to assign the term Residence to it. Is there an easy way to do this? Detection rules seem to look at the value and not at the column name.kind regards, Jur Dördregter

Hey All!I am aware that only Stewardship owners have the ability to use the “Document” button on a data source level, but is there a way that we can disable this button all together? If a user accidentally uses this feature, it eats up a lot of processing to import the metadata, and is a best practice that we are telling everyone not to use. Is there a way within the admin console to do this?Thanks! 

Hi,I have certrain fields in my data that should be masked for all users. This is information like social security number and IBAN. Now users can see this data from the sample data tab and from the profile. Can I apply some some masking of these attributes without have to create a VCI or SCI for this? Ideally masking should be applied based on the term assignment: as soon as I map the data to IBAN it should be masked for all users.Regards, Jur Dördregter

Hi,We have several Monitoring Projects that are scheduled to run at 07:00. If for instance 1000 jobs are still in the queue those scheduled MP will run after the 1000 jobs (assuming the priority is the same; 0). In order to change this I have to go to DPM and change the priority of the scheduled MPs. Is there a way where I can schedule a Monitoring Project at a specific time, 07:00, with a certain priority (automatically)?

how do i do an exact field search?For Ex: I have a field named trd_settle_date  - and when i search for that in the data catalog, it is Giving me all fields in catalog that either started with “trd” or had “settle” word some where in it etc.,Because of that, the search is giving so many unnecesary values in the list, and making it difficult to find the right one.How can i get Ataccama to perform exact match to my search string? If it doesnt find - its OK for it to give me “no items found”

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?

Is there a way to put columns in a view with a static value? Like you can in a sql statement, such asSELECT col1, ‘this is a static value’ AS col2

Is there a way to create views in RDM that contain union statements combining queries to different tables?

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 Ataccama team I would like to know if there is a reference about how to configure an external dpe using databricks on azure. Thank you

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? 

The response message was:null and response error was 'errorMsg:java.net.NoRouteToHostException: No route to host    at java.base/sun.nio.ch.Net.connect0(Native Method)    at java.base/sun.nio.ch.Net.connect(Net.java:579)    at java.base/sun.nio.ch.Net.connect(Net.java:568)    at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:593)    at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)    at java.base/java.net.Socket.connect(Socket.java:633)    at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:121)    at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)    at org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:326)    at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:605)    at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:440)  

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

I have an xml file with a structure like this:<model xmlns="http://www.ataccama.com">    <entities>        <entity name="table1" />     <columns>             <column datatype="varchar(100)" name="abc" required="false" />             <column datatype="int" name="xyz" required="false" />             <column datatype="datetime" name="123" required="false" />     </columns>...I want to produce a data stream that combines the column name and data_type with the name from the parent entity node.  If I define the columns using xpath nm:model/nm:entitles/nm:entity/nm:columns/nm:column then I cannot access the entity name using ../../@name (or any xpath expression for that matter).  If I define the columns using entity level xpath epxression nm:model/nm:entitles/nm:entity and the columns with xpath nm:columns/nm:column/@name then I only get 1 record per entity with the first column only.   How can I get the entity name, column name, and column data

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.