Riccardo Schillaci Posted January 29, 2021 Share Posted January 29, 2021 Hello, I would like to connect Amazon S3 as Data Source and read .parquet files. Can you help me Thanks Link to comment Share on other sites More sharing options...
Sooriya rangasamy Posted April 22 Share Posted April 22 It is achievable via datafunction. I tried it and it works for me:) but you need aws IAM permissions for this. 1) Create a datafunction| Pass your aws access id, region, secret access key in it 2) use Python package: BOTO3 3) Try listing all the objects in s3 with a button on text area 4) Once listed as "Key" which gives the s3 location click on the item and bring the data from selected obj as dataframe and load as your datasource. DM me on Linked-in for any help Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted April 22 Share Posted April 22 Hi Riccardo, Sooriya, According to our documentation, it should be possible to connect to S3 using via the Amazon Redshift ODBC driver: https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connectors%2Famazon-redshift%2Fredshift_accessing_data_from_amazon_redshift.htm&rhsearch=S3&rhhlterm=S3&rhsyns= . Kind regards, David Link to comment Share on other sites More sharing options...
CoC Spotfire Posted July 16 Share Posted July 16 Hello via this connector is there any possibility to load image format like jpeg or png (for example)? This connector right now can only load basic data. Thanks in advance. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted July 16 Share Posted July 16 Hi CoC, By default, this isn't possible but you could try a workaround. If you convert the images to a binary format in S3, you should be able to decode them back into images in Spotfire, using scripting. An example of such as script can be found here. Kind regards, David Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now