search

Baoqi / metabase-dremio-driver

Dremio driver for Metabase BI
Eclipse Public License 2.0
47 stars 10 forks source link

no catalog when using a user home schema like "@username" #2

Closed fabrice-etanchaud closed 3 years ago

fabrice-etanchaud commented 3 years ago

Hi @Baoqi ,

when configuring a new dremio connection with a user home as schema, catalog is not retreived. Maybe an issue with the @ ?

Best regards

Baoqi commented 3 years ago

Hi, @fabrice-etanchaud

Yes, this actually is a bug in dremio side, I have reported it to dremio: https://community.dremio.com/t/bug-report-current-schema-returned-extra-double-quote-when-the-current-schema-contains-special-character/7354

and they replied "have opened an internal ticket to address the issue".

But for now, we can work around this by check whether current schema's name matches the regex

^"(@[^"]+)"

and remove the "" if matched.

Release 1.0.3 has this fix, you can check whether it works if you have time (I did some basic tests)

fabrice-etanchaud commented 3 years ago

Thank you @Baoqi ! I will upgrade as soon as possible.

fabrice-etanchaud commented 3 years ago

Works like a charm on my side ! Thank you Baoqi.

Baoqi commented 3 years ago

Great it works. Let's close this issue for now