Learn & Share

Hi Ataccama communityI am trying to do the export of DQ monitoring project the results and use the filters in the export. I a post on this one ONE Desktop: Data Quality Results 🧑‍ on using the filters in the export data. I am able to get the filters extracted using the DQ monitoring project filter values but couldn't get the corresponding monitoring project results using the DQ Monitoring project check results. I am getting an empty file with just the column names in the file in the output file which I have checked the output into a CSV file just after the DQ monitoring project check results step. And I have enabled only one filter in the DQ monitoring project as I read in the community forum that two filter wouldn’t wo

Hi Ataccama Community, I want to upload a CSV file which is an export of DQ monitoring project results to SharePoint folder. I couldn’t see the Task SFTP upload file step in my OneDesktop (version 15.4). Is this step not available in the current version of Ataccama OneDesktop ? Or is there any work around to upload the CSV files to the Share Point server. CheersManidhar

Hi,I am attempting to connect to Collibra using the Collibra reader (refer to the page: Collibra Integration in Ataccama ONE Desktop 🏹).However, I am encountering the following error message when I execute the plan. Could someone please assist me?  I have set up a server without a username/password because I don't need to enter a username/password when accessing Collibra.  

Hello, Can we create nested sql catalog items.  Meaning, can I use a SQL catalog item in the query as a source to another sql catalog item?  

Hi all,Suppose you have 2 tables that relate as 1:n. When joining the tables in a query without filtering, the result will be n rows. My requirement is to have just one row returned, with the values of the n-table shown as an array. In SQL Server you could use a query likeSELECT     p.PK_ONETEST,    p.Name,    p.Description,    (SELECT         c.Name     FROM ODS.NTEST c     WHERE c.FK_ONETEST = p.PK_ONETEST     FOR JSON PATH) AS ChildrenFROM ODS.ONETEST p;resulting in My question is if we can also achieve this in one or more steps in One Desktop.Kind regards,Albert

Two records as same correation id and same version number one should process another one should error out how to implement this logic in ataccama 

Hello, i am using a free version of the Data Stories , I cant seems to find where to upload or import dataset as seen from the demo --- Data Stories Demo does this free version not support creating a story , Dashboard or visualization ? if its does, is there something i’m not doing right 

Hello,We recently started getting nested JSON event files with DAT file extension. We are getting an ‘Unknow Error’, when we try to import it.Can you help me in understanding, how nested JSON with .DAT extension can be processed in Ataccama.Thank you.   

Hi Can we have multiple workflows in single scheduler? I tried to add multiple workflows but I am getting error. is there any way to do this? Thanks in advance

We recently updated the Data Sources connection, and all Catalog items that were using the old connection are no longer working in the monitoring projects. When I expand the catalog items, an error message appears: "You are looking at a deleted item."However, if I create a new catalog item and add it as an attribute in the monitoring project, it works perfectly fine.My question is: How can I update the existing catalog items to use the new connection? Do I need to manually recreate all these catalog items with the new connection, or is there a way to automatically switch all catalog items from the deleted connection to the new one

Hello Ataccama Community,I am trying to export the summary statistics of the DQ monitoring project?   I wanted to have a csv file with the columns like Date of the test results execution, Data_Catalog_Name, Attribute Name, DQ rule name, Data Source, DQ dimension, Total Number of Records, Number of records passed, and Number of records failed.To begin with I have tried using DQ monitoring projects step in One Desktop and the DQ Monitoring project is failing if I enable this post processing plan. Not sure why it was failing after enabling the below post processing plan. Any help is much appreciated. Thanks in Advance

Hi guys, how did you check boolean date type in DQ rules? When I apply this rules  it  also make numbers, string, others value as correct.  

I am creating new source connection from Ataccama ONE and I need help on how to connect Snowflake.From below screenshot I am trying to understand JDBC connection looks like.For e.g. I am using jdbc:snowflake://myorganization-myaccount.snowflakecomputing.com/, but it is not working.Any help is greatly appreciated.  

Hi,I am able tot connect Bigquery from Ataccama ONE Desktop application but getting below error while inserting data in table - com.ataccama.dqc.commons.sql.atc.WrappedSqlException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: Transaction control statements are supported only in scripts or sessionswhile executing INSERT INTO ……..  

How do I get Terms tagged to attributes to various catalog items in One Desktop?I need to get all catalog items which are tagged with a specific Glossary Term.

When I try to open a Trans component on Ataccama One Desktop, I receive the error 'Index -1078132736 out of bounds for length 10.' Do you have any ideas or suggestions to resolve this issue?

Hi everyone, I was wondering if anyone could share how the i_event_log table is configured, as well as its details for the front-end (UI)? Also, could anyone provide guidance on how to configure the back-end audit log and retrieve it using pgAdmin? I’d really appreciate any insights. Thank you!

I have been trying to explore the Reprocess and Rematch options in MDM.From this post I understand that Reprocess is used to reprocess the records. For example, lets say, after an initial load where the email values were not being modified in contact_clean.comp, we are now to determine which emails have the domain company-name.com and are now being updated to have domain companyname.com . So, I need to run the reprocess job.Rematch is to run the match step on top of the reprocess since the email values have been modified. What I do not understand is do I run a rematch job only if the email value participates in determining the master record or do I need to run it whenever the reprocess jobs is run irrespective of the changes that took

Hello All,I am using group aggregator in our plan but I am not sure how to make all the columns flow from input till the end/output through group aggregator. 

Hi,Could someone guide me on creating rules for the Productline field? I am following the lab exercise but am unable to find the option for selecting "is not from reference data."Any guidance would be appreciated.Thanks,Shikoh Zaidi   

I have 10 excel sheets, which need to be combined in one single excel sheet. can this be done in Ataccama?

I have a column in my catalog item which contains sensitive data. I have tagged this column with a Business Term. This business term is tagged as PII in Data Protection Classification section in Glossary terms. Is there a way to show at catalog item level that this table contains PII data?

Hi everyone, Data Observability tab and AI functionality  are  not available. How can I check SCD Type 2 using DQ rules?Data Freshness. How can I check  using DQ rules? Datetime datatype is for eff_strt_dttm, it’s one column where data is, but I don’t know how make:   today() >>>as datetime  minus 1 day   

Hi guys! Is there any opportunity to check data freshness in case we have Redshift connection?I see there is no such driver in freshness configuration drivers list - https://docs.ataccama.com/one/latest/data-observability/data-freshness-custom-configuration.html.