Skip to main content
Solved

Compare data between file and table


Forum|alt.badge.img

we need to achieve completeness DQ control by comparing data in the file and the table irrespective of the position of primary key in either of them or by using composite keys. - This is in continuation with the query posted in ataccama community - Regarding DQ controls (ataccama.com) Do we have any step or document to follow on how we can import that file into ONE web app as catalog item and can we upload the file from local or we need to get that from the file system?

 

Thanks,

Karthikeyan.

Best answer by srija piratla

Hi @Karthikeyan ,

 

These are the prerequisties for the file system connection. https://docs.ataccama.com/one/latest/sources/local-file-system-connection.html. If you have these setup then you can add the mount name. 

Hope this helps !

Regards,

Srija Piratla

View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img

Hi @Karthikeyan ,

You need to connect to the source(file) - https://docs.ataccama.com/one/latest/sources/sources.html  and once it is done you can get the table into the catalog items, where you can see all the location and schema that is mentioned in the previous post. For reconciliation projects to create here is the documentation - https://docs.ataccama.com/one/latest/data-quality/data-reconciliation.html. Hope this helps.

Regards,

Srija Piratla


Forum|alt.badge.img
  • Author
  • Data Pioneer
  • 12 replies
  • August 22, 2024

Hi @srija piratla , I have gone through the above document and tried creating a source which is a file, so I chose β€œFile System” since I am trying to import a file. 
 

 

Once I chose - β€œFile system”. when I try to select β€œMount name”. I am not able to find anything in the mount name dropdown or not able to type in the β€œMount name”. 

 

 

My understanding might not be correct - let me know your thoughts whether I am trying to follow the correct steps or I am missing anything.


Forum|alt.badge.img
  • Ataccamer
  • 49 replies
  • Answer
  • August 23, 2024

Hi @Karthikeyan ,

 

These are the prerequisties for the file system connection. https://docs.ataccama.com/one/latest/sources/local-file-system-connection.html. If you have these setup then you can add the mount name. 

Hope this helps !

Regards,

Srija Piratla


Forum|alt.badge.img
  • Author
  • Data Pioneer
  • 12 replies
  • August 27, 2024

Thanks @srija piratla - will check this and get back.


Cansu
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • 625 replies
  • September 12, 2024

Hi @Karthikeyan, I’m closing this thread for now if you have any follow up questions please don’t hesitate to share them here or create a new post πŸ™‹β€β™€οΈ


Forum|alt.badge.img
  • Author
  • Data Pioneer
  • 12 replies
  • September 12, 2024

sure @Cansu / @srija piratla  just need one information. I have posted a new question 

data reconciliation for snowflake data (ataccama.com) .


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings