Jump to content

Connecting Spotfire to AWS Athena using JDBC driver


Praveen Selvam

Recommended Posts

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

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...