Skip to main content
Solved

Ingest Lakehouse - Handling invalid characters


Søren Sørensen
Contributor
Forum|alt.badge.img+1

Version 7026.1 - Ingest into Lakehouse

I’ve got a SQL data source where some column names contain spaces. This causes the TX SQL connector (23.0.3.0) to throw the following error when I try to ingest data into a Lakehouse:

Executing table dbo_tx_profitcentreinfo:
failed with error:
Found invalid character(s) among ' ,;{}()\n\t=' in the column names of your schema. 
Please enable Column Mapping on your Delta table with mapping mode 'name'.
You can use one of the following commands.

If your table is already on the required protocol version:
ALTER TABLE table_name SET TBLPROPERTIES ('delta.columnMapping.mode' = 'name')

If your table is not on the required protocol version and requires a protocol upgrade:
ALTER TABLE table_name SET TBLPROPERTIES (
   'delta.columnMapping.mode' = 'name',
   'delta.minReaderVersion' = '2',
   'delta.minWriterVersion' = '5')

I can read what it says 😀 but I thought I’d ask the Community for advice. Has anyone encountered and resolved this issue? If so, what do you recommend?

@R&D - I think we should build character conversion of invalid Lakehouse characters to underscores into the TX SQL connector.

Best answer by Greg Lennox

@Søren Sørensen I tried to recreate this issue but was unable to. I replied on your support ticket with the details of my test for your perusal.

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+1
  • Community Manager
  • 28 replies
  • Answer
  • June 25, 2025

@Søren Sørensen I tried to recreate this issue but was unable to. I replied on your support ticket with the details of my test for your perusal.


Søren Sørensen
Contributor
Forum|alt.badge.img+1

@Greg Lennox I can no longer replicate the issue. The Target Field Names do now contain underscores instead of spaces … very strange. Thanks for looking into this!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings