Forum Discussion
Community ChampionHow to Resolve Issues Loading Data from Tables with Spaces in Their Names?
I'm using a notebook to load data from a Fabric warehouse called 'warehouse name'. Some of the tables have spaces in their names, and I'm unable to load the data using the ABFSS path shown below:
abfss://[email protected]/WH_id/Tables/dbo/[Table and name]
When attempting to load the data, I encounter an AnalysisException indicating that the path does not exist:
Loading data from tables without spaces in their names works correctly. I've tried enclosing the table names with backticks (`), single ('), and double (") quotes, but none of these approaches have resolved the issue. Is there a way to load the data without renaming the tables?
I was able to solve this after wasting a day. just remove these [ ] from the name and it works. so the path would be
abfss://[email protected]/WH_id/Tables/dbo/Table and name
3 Replies
rubayatyasminI was able to solve this after wasting a day. just remove these [ ] from the name and it works. so the path would be
abfss://[email protected]/WH_id/Tables/dbo/Table and name
Hi, rubayatyasmin
Glad you found your problem, and you can mark your approach as a solution to help more people with similar problems find answers. Thanks for your understand.Best Regards,
Yang
Community Support Team- rubayatyasmin
Done, thanks
