cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Backspaces in Foreign Catalog Table Names

ssequ
New Contributor II

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!

1 ACCEPTED SOLUTION

Accepted Solutions

daniel_sahal
Esteemed Contributor

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

View solution in original post

3 REPLIES 3

daniel_sahal
Esteemed Contributor

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

ssequ
New Contributor II

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

daniel_sahal
Esteemed Contributor

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group