Let’s say in Dremio my Space name is “My-Space”
My reporting tool (SSRS) is using ODBC connection to connect to Dremio.
My SQL query looks like this - SELECT col1, col2 FROM “My-Space”.MyFolder.MyVDS
I am getting ODBC error because its not liking double quotes around my space name. I tried all different escape char ways putting “” ,"""", " etc but its not working.
Without double quotes Dremio is not liking the - in my space name “My-Space”.