Not able to escape `-` in external connected tablename
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2023 01:32 AM
We are having some issues with getting data from some tables with the character `-` in their tablename.
We are connected to the database with an SQL server connection, and the database is (as far as we know) a Microsoft Azure SQL Database. We do not have access to the database other than credentials to read a specific schema.
When we either try to view sample data in Unity Catalog, or run a query like:
"SELECT * FROM `tablename$i-comm`;"
We get the error: Incorrect syntax near '-'.
We have tried to escape special characters in the table name in various ways without luck.
- `tablename$i-comm`
- `[tablename$i-comm]`
- "tablename$i-comm"
- `tablename$i/-comm`
- `tablename$i\-comm`
- etc
Does anyone have any idea of how we can read data from a table with a name like that?
