# Problem connecting with Metabase \>= 0.48.4

**URL:** <https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919>\
**Category:** 3rd Party Tools\
**Created:** [December 4, 2024, 3:02pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919 "2024-12-04T15:02:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![massimo\_ferrari](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/massimo_ferrari/32/1208_2.png) [@massimo\_ferrari](https://community.cratedb.com/u/massimo_ferrari)\
**Post date:** [December 4, 2024, 3:02pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919/1 "2024-12-04T15:02:33Z")

</div>

Hello,

I’ve installed a CrateDB cluster (v 5.9.2) on Hetzner Cloud, 5 nodes on ARM machines (ubuntu 24.04).

Each node has 4cpu, 8GB ram, external extensible SSD.

I am feeding it daily/hourly with various data arriving from my ingestion scripts (bulk inserts from HTTP POST and/or COPY table FROM … distributed across all nodes.)

Everything works well and I can query it via ad-hoc written queries (I use PHP PDO and it works!)

I want to link CrateDB with Metabase (v 51.6). It seems connected but when I tries to synchronize it hangs forever and never gives the list of tables with which proceed to build the dashboards.

Going to look at the Metabase logs I see that there is an error

> org.postgresql.util.PSQLException: ERROR: line 5:20: no viable alternative at input ‘select\n NULL as role,\n t.schemaname as schema,\n t.objectname as table’

If I try to execute the same query inside one of the nodes (from crash or from web console) I get the same error

> io.crate.exceptions.SQLParseException: line 1:62: no viable alternative at input ‘select NULL as role, t.schemaname as schema, t.objectname as table’

Any help is appreciated.  
Massimo

---

<div class="post-metadata">

**Author:** ![hernanc](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/hernanc/32/676_2.png) [@hernanc](https://community.cratedb.com/u/hernanc)\
**Post date:** [December 4, 2024, 3:06pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919/2 "2024-12-04T15:06:56Z")

</div>

Hi Massimo,  
This is a known issue that we are looking to address.  
In the immediate you have 2 options, you can downgrade Metabase to v0.47.13 or you can edit the file under `driver/postgres.clj` changing the aliases `as schema` , `as table`, etc to all use double quotes like `as "schema"` , `as "table"` , etc., like [demonstrated here](https://github.com/crate/crate-clients-tools/issues/153#issuecomment-2495582105).

I hope this helps.

---

<div class="post-metadata">

**Author:** ![massimo\_ferrari](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/massimo_ferrari/32/1208_2.png) [@massimo\_ferrari](https://community.cratedb.com/u/massimo_ferrari)\
**Post date:** [December 5, 2024, 8:51am UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919/3 "2024-12-05T08:51:01Z")

</div>

Thanks Hernan,  
are you telling me I have to modify Metabase to make it work with CrateDB?

At this point I can’t figure out if the problem is with Metabase or CrateDB !

If the problem is on the Metabase side, I can’t follow your advice as it becomes a potential problem for me on future releases of Metabase which I will definitely want to adopt for all the new features they release. I use the PRO version of Metabase and as CrateDB is an unsupported data source, I cannot open an issue on the Metabase side.

If, however, the problem is on the CrateDB side, i.e. how the connection and/or synchronization involving Metabase towards the CrateDB cluster is managed, I am interested in understanding whether it will be resolved by you in order to evaluate the complete adoption of CrateDB in my context.

I hope you will understand.

Thank you

Massimo

---

<div class="post-metadata">

**Author:** ![amotl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/amotl/32/617_2.png) [@amotl](https://community.cratedb.com/u/amotl)\
**Post date:** [December 5, 2024, 12:27pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919/4 "2024-12-05T12:27:38Z")

</div>

Dear Massimo,

thank you for writing in. We are currently exploring the situation at [Metabase v0.48.4: Problem connecting CrateDB · Issue #153 · crate/crate-clients-tools · GitHub](https://github.com/crate/crate-clients-tools/issues/153), and will most likely need to come up with a dedicated data source adapter for CrateDB that will be submitted to Metabase, so it will be natively supported.

That means the adapter will still significantly inherit capabilities from the PostgreSQL adapter, but will then be able to accompany for any differences in SQL dialect and other details.

We are currently working on it and kindly ask for your patience to improve the situation. We will inform you about any progress as we go.

With kind regards,  
Andreas.

---

<div class="post-metadata">

**Author:** ![massimo\_ferrari](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/massimo_ferrari/32/1208_2.png) [@massimo\_ferrari](https://community.cratedb.com/u/massimo_ferrari)\
**Post date:** [December 5, 2024, 1:33pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919/5 "2024-12-05T13:33:33Z")

</div>

Looks great to hear about a native Metabase adapter 🙂

Keep me (and the community too!) informed on evolution.

Regards.

Massimo

---

<div class="post-metadata">

**Author:** ![surister](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/surister/32/1087_2.png) [@surister](https://community.cratedb.com/u/surister)\
**Post date:** [December 5, 2024, 1:38pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919/6 "2024-12-05T13:38:46Z")

</div>

> [@massimo\_ferrari](#):
>
> my context.

On another note, we would love to understand your context, could you tell us a bit more about your use-case?

Thanks!

---

<div class="post-metadata">

**Author:** ![amotl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/amotl/32/617_2.png) [@amotl](https://community.cratedb.com/u/amotl)\
**Post date:** [December 5, 2024, 2:59pm UTC](https://community.cratedb.com/t/problem-connecting-with-metabase-0-48-4/1919/7 "2024-12-05T14:59:41Z")

</div>

Just for the records, the [CI job run](https://github.com/crate/cratedb-examples/actions/runs/12172893695/job/33952341809) on this PR demonstrates that Metabase connectivity works up to version 0.48.3, and goes south with 0.48.4.

- [Metabase: Update to v0.48.4 by amotl · Pull Request #761 · crate/cratedb-examples · GitHub](https://github.com/crate/cratedb-examples/pull/761)

Relevant changes to Metabase are reflected within the [Driver Interface Changelog for Metabase 0.49.0](https://www.metabase.com/docs/latest/developers-guide/driver-changelog#metabase-0490).
