testing reading from dedicated pool error

Jon Z 20 Reputation points
2024-05-22T15:12:18.18+00:00

Following





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.
4,556 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,111 Reputation points Microsoft Employee
    2024-05-23T20:55:33.52+00:00

    The error you're encountering is due to a data type mismatch. The system expects a NVARCHAR(10) data type, but it seems that the data being read does not match this specification.

    Please Check if there are any special characters or data that exceed the expected length of NVARCHAR(10) in the source data.

    or If the schema is correct, consider using a CAST or CONVERT function in your query to explicitly convert the data to the expected type.

    1 person found this answer helpful.