Canner
Show original SQL toggle not working
After we get the result and select the view SQL tab, when you the view the SQL query it is inaccurate and when we click the Show Original SQL toggle button, it always gives a blank output. This especially happens when you select MSSQL database. Please refer the below attached image for the reference.
@shardulb13 Is this toggle issue only happening with MSSQL, or are your other database connections working fine? Also, just to confirm, you're not having any SQL Server connection issues in general, right?
@douenergy There is an issue with the SQL Server connection setup. Even when all the details are correct, an SSL certificate error persists, regardless of whether the certificate toggle is enabled or disabled. However, after repeatedly toggling the enable/disable option and clicking the "OK" button, the setup eventually proceeds to table selection and connection definition. Additionally, for MSSQL, the "Show Original SQL" toggle does not work, whereas it functions properly for a PostgreSQL database.
@douenergy There is an issue with the SQL Server connection setup. Even when all the details are correct, an SSL certificate error persists, regardless of whether the certificate toggle is enabled or disabled. However, after repeatedly toggling the enable/disable option and clicking the "OK" button, the setup eventually proceeds to table selection and connection definition. Additionally, for MSSQL, the "Show Original SQL" toggle does not work, whereas it functions properly for a PostgreSQL database.
Having same error.. almost whole week have been trying this.. still not able to go past this error