Power Platform Community Forum Thread Details

Hi,

Some error shows when I'm inserting new data into snowflake via the connector and virtual table in dataverse, the new data appears in the snowflake database, but an error is thrown as below, is that a bug for the preview version of the connector and other wrong configuration in Power Apps or Snowflake?

"message": "BadGateway",
"innerError": {
"status": 500,
"message": "SQL compilation error:\nsyntax error line 1 at position 36 unexpected 'TABLE'.\nsyntax error line 2 at position 1 unexpected 'ID'.\r\nclientRequestId: 5bc6f933-bed3-46b8-89c3-3dc1b8c4b872-self",
"error": {
"message": "SQL compilation error:\nsyntax error line 1 at position 36 unexpected 'TABLE'.\nsyntax error line 2 at position 1 unexpected 'ID'."
},

Thanks

Categories:

Building Power Apps