Skip to main content

We have reports being built on tableau based off the “User”, “Topic”, “Post” and “Mark as Answer” exports available for download under Analytics >  Export.
We need to automate this process as it is currently based on a manual download of these exports.
The Tableau Connector seems to allow connection to base tables in the CC Data Lake, but the export tables cannot be found here. I assume the export tables are based on these same source data tables in CC Data Lake.
Are the SQL queries used to generate these export tables available anywhere so it can used within the “Customer SQL” option in the AWS Athena based Tableau connector?
Or is there any other way to achieve this (connecting the export tables available on gainsight to Tableau).

Hi ​@KhalidAwad18 

Currently, the export tables have a different source than the Data Lake, and we don’t have the SQL queries ready to be shared. However, we plan to reconnect the export tables to the DL and expose them there in the future. This update is still on our roadmap and has not been delivered yet.


Reply