Effectively use the SQL query in CX Insights to display and export relevant data using this process. By following these steps, you can effectively leverage the SQL query in CX Insights to meet your data analysis and export needs.

1. Modify the SQL Query for Relevant Data

You can manipulate the SQL query to display the specific data you need. Customize the query to ensure you're pulling the relevant information for your analysis.

2. Display All Records

By default, the query may limit the number of records it shows. To view all records, remove the TOP (100) clause from the first line of the query. This will allow the query to display all available records.

Note on Azure Synapse Analytics

For Azure Synapse Analytics users, the default setting only displays the top 5000 records. If your dataset has more than 5000 records and you need to view all of them, follow these steps:

  • Click the “Settings” icon located in the upper right corner.

  • Select “All rows” to ensure all records are displayed.

3.  Use the WHERE clause to filter results; then the ORDER BY clause to sort them.

By following these steps, you can effectively leverage the SQL query in CX Insights to meet your data analysis and export needs.


Content by label

There is no content with the specified labels