Connecting Spotfire to AWS Athena using JDBC driver

[Praveen Selvam]

Hello All,

 

We have connected Spotfire to AWS Athena data source using jdbc driver and we are able to see the database tables. However, how do I see the views that are created We cansee the views using a client such as SQLWorkbench/DBeaver but by default it is not appearing in Spotfire.

 

Is there a way to see the views by adding some commands in the connection url string itself Help and inputs areappreciated.

 

Thanks,

Praveen

[Khushboo Rabadia]

You can check if view is present in table-types in data source template as seen in below article:

https://community.spotfire.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-11

Data source template would be present on Spotfire server configuration which can be accessed using configuration tool (uiconfig.bat)

[Praveen Selvam]

Thanks for the tip, Kushboo. It was helpful. 

[Brandon Huynh 2]

Hi Ppanneerselv,

 

I try to set up a data source to Athena but keep getting errors.  I wonder if you can share the connection string you have that successfully let you connect to Athena.

 

Thanks in advance.

 

Brandon

[Praveen Selvam]

Hey Brandon, This is the format of my connection string/URL.

 

jdbc:awsathena://athena.<region>.amazonaws.com:443s3_staging_dir=<staging_dir> Regards,Praveen

[Brandon Huynh 2]

Hi Ppanneerselv,For <region> I have us-east-1 in that place but for <staging_dir> I have no idea what to put in that field.  I have the connection string from the cloud developer but it kept giving me errors.  In attached the error below in hope you can see what I did wrong.

Cannot connect to data source 'AthenaTest', due to invalid configuration or that the data source is not running.

Database reported:

[simba][AthenaJDBC](100131) An error has been thrown from the AWS SDK client. SAML error: Failed to login ADFS. [Execution ID not available]

 

Thanks,

Brandon