Backspaces in Foreign Catalog Table Names

[ssequ]

Hi,

is there a way to import tables with UC disallowed characters when creating a foreign catalog? The database we are dealing with contains table names with backspaces and UC seems to completely ignore them when creating the catalog.

Thanks for any help!

[daniel_sahal · Accepted solution]

@ssequ I assume that you're refering to lakehouse federation? Unfortunately that's a limitation, tables with disallowed characters will be ignored.

[ssequ]

Thank you, @daniel_sahal . Are you aware if/when disallowed characters in table names will be possible with lakehouse federation?

[daniel_sahal]

@ssequ Unfortunately i've got no info about that. It's still in a preview, so I hope that they will be able to handle that in the future.
There's one thing that you could test here - create a views that will just simply do SELECT * from your tables, but they would be named correctly.