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

Question

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

Akshay Patil 0

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!

ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2023-03-16T14:45:25.5666667+00:00
Hi Akshay Patil,

Thank you for posting query in Microsoft Q&A Platform. Could you please help me with below queries.

What is format type in ADLS in this case?

Are you seeing any error in Copy activity? If yes could you please share error details with screenshots if possible.

When you create dataset for data explorer table, are you able to import schema of table?
ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2023-03-20T09:52:24.0866667+00:00

Hi Akshay Patil, Just checking if any updates on above?
Akshay Patil 0 Reputation points

2023-03-27T11:57:49.9866667+00:00
Hi @ShaikMaheer-MSFT

The ADLS file format is parquet file format.

When creating a dataset we not able to import the schema of table.

Operation on target Full_Load failed: ErrorCode=ParquetInvalidColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The column name is invalid. Column name cannot contain these character:[,;{}()\n\t=],Source=Microsoft.DataTransfer.Common,'

1 answer

Your answer

ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2023-03-16T14:45:25.5666667+00:00

Hi Akshay Patil,

Thank you for posting query in Microsoft Q&A Platform. Could you please help me with below queries.

What is format type in ADLS in this case?

Are you seeing any error in Copy activity? If yes could you please share error details with screenshots if possible.

When you create dataset for data explorer table, are you able to import schema of table?
ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2023-03-20T09:52:24.0866667+00:00

Hi Akshay Patil, Just checking if any updates on above?
Akshay Patil 0 Reputation points

2023-03-27T11:57:49.9866667+00:00

Hi @ShaikMaheer-MSFT

The ADLS file format is parquet file format.

When creating a dataset we not able to import the schema of table.

Operation on target Full_Load failed: ErrorCode=ParquetInvalidColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The column name is invalid. Column name cannot contain these character:[,;{}()\n\t=],Source=Microsoft.DataTransfer.Common,'

Answer 1

Wilko van de Velde 2,231

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

Books
| project ['aut hor']

Share via

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

1 answer

Your answer