Resolving Missing Parse Option in SQL DB Connection
This article addresses the issue of the missing "Parse" option when connecting to an SQL database in Sisense. Users may encounter this problem when attempting to parse data from SQL DB connections. This guide will explain why the "Parse" option might be unavailable and provide steps to resolve the issue.
Instructions
The "Parse" option is unavailable when all selected tables in your SQL DB connection are base tables. This option becomes accessible only when custom import queries are used.
1. To enable the "Parse" option, ensure that you are using custom import queries rather than selecting only base tables. Review your SQL queries and modify them to include custom queries if necessary.
2. Ensure that your SQL user permissions are correctly configured to allow for custom queries
3. After making changes to your queries and permissions, test the connection again to verify that the "Parse" option is
now available.
Conclusion
The "Parse" option in Sisense is only available when custom import queries are used. By ensuring that your SQL
connection utilizes custom queries and that your user permissions are correctly configured, you can resolve the issue
the missing "Parse" option.
