Synapse : Query spark table with sql serverless return "Invalid object name"

David Simon 1 Reputation point
2021-08-23T17:02:19.293+00:00

Hello,

I don't now why when I try to build spark table which contain decimal(32,16) the table is created but unqueryable.
When I remove this field, the rest of the other fields are string and now I can query the table into the SQL edior.

Can you explain me why I have this problem ?

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,488 questions
{count} votes

1 answer

Sort by: Most helpful
  1. David Simon 1 Reputation point
    2021-08-25T08:34:33.8+00:00

    126257-image.png

    Hey this is the code