Unable to pull data from data explorer in Azure synapse whose columns contains spaces

Akshay Patil 0 Reputation points
2023-03-15T07:33:25.2733333+00:00

Hi team,

We are trying to pull data from data explorer to ADLS from synapse using a linked service. However In copy data I am unable to fetch columns whose column name contain spaces or special characters in data explorer.

Can you please help me on this or let me know another option to do this?

Thanks in advance!

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
479 questions
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,350 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Wilko van de Velde 2,146 Reputation points
    2023-03-29T16:56:40.5266667+00:00

    You may have to use ['column'] when using the column, for example:

    Books
    | project ['aut hor']
    
    0 comments No comments