I'm using MariaDB and have created a new database connection in the BI server website using the "Generic Database" type naming the MariaDB driver class as my driver. My connection test is successful

  1. I can proceed to defining a data source using the "Reporting and Analysis" option checked.
  2. I'm then presented with my listing of tables, which I can select without a problem and hit "Next"
  3. I'm presented with a screen to define my join which shows my tables on my left and right sides however no columns are listed under those table names
  4. When looking at my Tomcat output, I see an error:

An error occurred executing SQL:
SELECT * FROM "db_warehouse"."dim_client"
(conn:85) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"db_warehouse"."dim_client"' at line 1
Query is : SELECT * FROM "db_warehouse"."dim_client"
The query generated is placing double quotes around my schema name and my table name, however MariaDB uses single quotes or backticks.

How do I fix this issue?