How to Access CSV file kept on S3 bucket using Tibco Data Virtualization without Athena Setup

[Anandkumar Shukla]

Hi,

I am trying to access files kept on S3 bucket of AWS from Tibco Data Virtualization.

I have received an advised to setup Athena on top of S3 bucket and connect to

However Client is not ready tp setup Athena over S3 and wants us to acess data directly from S3 bucket

 

Kindly Advise

[Leo Kwok]

Please kindly find the steps for the S3 connector.

The S3 URI prefix should be changed from s3 to s3a, and also the Assumed Role Name should be empty.

The difference between s3 and s3a is that s3 is a block-based overlay on top of Amazon S3, while s3a are not (they are object-based).

The link explains the difference between s3 and s3a in detailed: https://stackoverflow.com/questions/33356041/technically-what-is-the-difference-between-s3n-s3a-and-s3