What Jira tables contain the CSAT information

[Kristi Yager]

I'm trying to find the csat information for a service management project. What tables would that data be found in?

[Aron Gombas _Midori_]

The DB is not exposed on Cloud, but you can get the rating for a single work item using this REST API end-point:

GET /rest/servicedeskapi/request/{issueIdOrKey}/feedback

[Kristi Yager]

I have the data exposed in snowflake. 

[Danut M _StonikByte_]

Hi @Kristi Yager,

As far as I know, Jira Cloud does not expose its database for external queries.

Instead, you could try using the Jira's REST API to get that info for each issue. Or,  try an app from Atlassian Marketplace that is capable to provide stats based on the customer satisfaction. 

In case you consider the idea of using an app, our Great Gadgets app offers all kind of stats based on Satisfaction. Have a look on these articles: 

• https://community.atlassian.com/forums/App-Central-articles/How-to-measure-Customer-Satisfaction-in-Jira-and-Confluence-with/ba-p/2741012 
• https://community.atlassian.com/forums/App-Central-articles/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Danut.

[Marc - Devoteam]

Hi @Kristi Yager 

Welcome to the community.

What tools are you using to get to the tables, as Cloud doesn't offer access to the backend DB?

[Kristi Yager]

I have the data coming into Snowflake via FiveTran. Trying to figure out what table, column.