Skip to main content
K
KhalidAwad18
Contributor ⭐️
June 23, 2025
Question

SQL Queries for available exports

  • June 23, 2025
  • 1 reply
  • 45 views

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).

1 reply

Aleksandra
Aleksandra
Gainsight Product Manager
July 1, 2025

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.

Aleksandra
Terms & ConditionsAccessibility statement