Skip to main content
Solved

S3 based data Catalog in Ataccama oneWeb

  • September 15, 2023
  • 4 replies
  • 71 views
F
Data Voyager
Forum|alt.badge.img+1
  • ferozData Voyager
  • Data Voyager
  • 3 replies

How I can use create sql catalog on s3 files (csv, parquet) in Ataccama One Web Knowledge Catalog.

Do Ataccama use AWS S3 CData drivers

Best answer by Cansu

Hi @feroz, I’ve checked with the team, and at the moment, it is not possible to achieve this using either CData or native Ataccama drivers. The only available option is to utilize AWS Athena, but there are certain limitations when it comes to using it for Parquet or CSV. I have shared your feedback with the team and if there are any changes in regards to this you can always find them in our Product Updates section, please feel free to subscribe to get notifications whenever we have a new release🔔

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

4 replies

Cansu
Community Manager
Forum|alt.badge.img+3
  • CansuCommunity Manager
  • Community Manager
  • 625 replies
  • October 13, 2023

Hi @feroz, thanks for posting! May I ask if you’ve had a chance to take a look at the AWS documentation here? 

Check out our Quick Start Guide to get started on the community 🙋‍♀️
F
Data Voyager
Forum|alt.badge.img+1
  • ferozData Voyager
  • Author
  • Data Voyager
  • 3 replies
  • October 13, 2023

Hello @Cansu,

We are able connect to S3 but unable to create SQL catalog.

F
Data Voyager
Forum|alt.badge.img+1
  • ferozData Voyager
  • Author
  • Data Voyager
  • 3 replies
  • October 13, 2023

@Cansu We expect Ataccama catalog is able build catalog and users should be able to use SQL to perform query on cloud storage

Cansu
Community Manager
Forum|alt.badge.img+3
  • CansuCommunity Manager
  • Community Manager
  • 625 replies
  • Answer
  • October 18, 2023

Hi @feroz, I’ve checked with the team, and at the moment, it is not possible to achieve this using either CData or native Ataccama drivers. The only available option is to utilize AWS Athena, but there are certain limitations when it comes to using it for Parquet or CSV. I have shared your feedback with the team and if there are any changes in regards to this you can always find them in our Product Updates section, please feel free to subscribe to get notifications whenever we have a new release🔔

Check out our Quick Start Guide to get started on the community 🙋‍♀️

Reply


Most Liked this week

Community Terms of Use & ConditionsCookie settings

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