JDBC connector for live model

Hi rahuldhomane,

For your current connection to Athena in an Elasticube - are you using the Sisense Athena connector (yellow "Amazon Athena") or Generic JDBC (purple "Generic JDBC")? 

If you are using the Sisense Athena connector, there is a way to enable live connection to Athena with a few steps. We do advise caution in that the performance of Live queries to Athena may not be as speedy as a connection to a high performance warehouse. So your mileage may vary here. 

These are the steps (for Sisense Linux only):

1. Within Sisense, go to Admin tab > System Management > File Management 
   (if you're logged in as an Admin and don't see this menu, follow instructions at the end of this reply to enable)
   
2. In File Management, navigate to connectors > framework > athena
3. Double click the manifest.json file to open it it
4. Find "supportLiveDataSource"
   Update its value to true
   
5. Click the save icon at the top right corner
6. Exit out of File Management
7. Within Admin tab > System Management > click "Configuration"
   
8. Scroll down to the bottom of the page - click "Manage Connectors" 
   
9. Click "Athena"
10. Scroll down to "enableAnalyticalEngine.value" and toggle this on
    

     

11. Click "Save Changes"
12. Now Athena should be enabled for Live and it should come up as an option when you create a new Live model

___________________________________

How to enable File Management:

1. In Admin tab > System Management, click the Configuration button
   
    
   
2. Click on the Sisense logo 5+ times to reveal additional menu options
   
3. Click on ‘Base Configuration’
   
4.  Scroll down the ‘File Management’ and expand the menu item.
   Toggle on fileManagement.enabled
   
5. Click Save Base at the top right hand side of the page
   

    

6. Then the File Management icon should show up

___________________________________

Hope that helps,