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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!