topic Re: Backspaces in Foreign Catalog Table Names in Warehousing & Analytics

Backspaces in Foreign Catalog Table Names

ssequ — Tue, 11 Jun 2024 07:53:37 GMT

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!

Re: Backspaces in Foreign Catalog Table Names

daniel_sahal — Wed, 12 Jun 2024 05:56:11 GMT

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

Re: Backspaces in Foreign Catalog Table Names

ssequ — Wed, 12 Jun 2024 06:08:30 GMT

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

Re: Backspaces in Foreign Catalog Table Names

daniel_sahal — Wed, 12 Jun 2024 06:51:37 GMT

@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.