Possible bug in Synapse Serverless external tables

Valter Prykäri 106 Reputation points

Sometimes querying an external table gives an error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'NOT'.

Definitely not a syntax error on my side. The error can happen from a query like this:
SELECT * FROM "external_table"

This error has happened twice and disappears after a while, so it is only temporary but annoying.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,115 questions
{count} votes

Accepted answer
  1. Jason Horner 81 Reputation points

    I've just received confirmation from MS support that this is indeed a bug in serverless. I believe a fix is in the works no ETA or further information about the scope.

    Supposedly there might be a back end fix that can remediated but you need to work with MS Support to enable.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Jason Horner 81 Reputation points

    for some more details on this: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand#incorrect-syntax-near-not

    I still see it occasionally, usually it is transient. In extreme cases, dropping and recreating the external table seems to fix this.

    0 comments No comments