Praveen Selvam Posted March 13, 2020 Share Posted March 13, 2020 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 More sharing options...
Khushboo Rabadia Posted March 13, 2020 Share Posted March 13, 2020 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) Link to comment Share on other sites More sharing options...
Praveen Selvam Posted April 13, 2020 Author Share Posted April 13, 2020 Thanks for the tip, Kushboo. It was helpful. Link to comment Share on other sites More sharing options...
Brandon Huynh 2 Posted April 14, 2020 Share Posted April 14, 2020 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 Link to comment Share on other sites More sharing options...
Praveen Selvam Posted April 14, 2020 Author Share Posted April 14, 2020 Hey Brandon, This is the format of my connection string/URL. jdbc:awsathena://athena.<region>.amazonaws.com:443s3_staging_dir=<staging_dir> Regards,Praveen Link to comment Share on other sites More sharing options...
Brandon Huynh 2 Posted April 14, 2020 Share Posted April 14, 2020 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 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