Error when I use synapse serverless sql pool OPENROWSET to read from a data lake structured stream with similar column name but only different casing

Salander He 66 Reputation points Microsoft Employee
2024-05-08T03:19:52.6833333+00:00

User's image

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

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 10,635 Reputation points Microsoft Vendor
    2024-05-09T04:18:59.85+00:00

    @Salander He Thank you for the clarification about the error you encountered while using Synapse Serverless SQL Pool's OPENROWSET function to read data from your Azure Data Lake structured stream.

    We understand that you're using the FORMAT = 'SSTREAM' option in your query. However, we'd like to inform you that this option is not supported in Synapse Serverless SQL Pool's OPENROWSET function, and it supports only CSV, Parquet and Delta formats.

    Reference doc: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset

    I hope this helps. Please let us know if you have any further questions.

    0 comments No comments