Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Gel 6.1 Metabase connection - relation "public.XXXX" does not exist #8457

Open
ruizehung opened this issue Mar 10, 2025 · 0 comments
Open

Gel 6.1 Metabase connection - relation "public.XXXX" does not exist #8457

ruizehung opened this issue Mar 10, 2025 · 0 comments
Assignees

Comments

@ruizehung
Copy link

I want to connect my self-hosted gel instance with Metabase. I'm getting

ERROR sync.fetch-metadata :: Error while fetching metdata with 'db-metadata'
org.postgresql.util.PSQLException: ERROR: relation "public.KnowledgeBase" does not exist

with Gel "6.1+299edfe" and metabase:v0.53.5.4

Screenshot
Image

But when I connect to my Gel instance via psql, public.KnowledgeBase does appear

main=> \d
                        List of relations
 Schema |                Name                 | Type  |  Owner   
--------+-------------------------------------+-------+----------
.....
 public | KnowledgeBase                       | table | gel
 public | KnowledgeBaseItem                   | table | gel
.....
(39 rows)

main=> \q

And main=> SELECT * FROM "public"."KnowledgeBase"; works too.

Schema public is in search_path

main=> SHOW search_path;
 search_path 
-------------
 public
(1 row)

main=> \l
  • EdgeDB Version: 6.1+299edfe
  • EdgeDB CLI Version: Gel CLI 7.0.3+df3d924
  • OS Version: I use geldata/gel:6.1 Docker image
  • Metabase version: v0.53.5.4
  • Metabase connection option
Image

Steps to Reproduce:

  1. Host Gel 6.1 via Docker
  2. Run migrate using the schema below
  3. Host metabase:v0.53.5.4 via docker.
  4. Connect

Schema:

module default { 
    type KnowledgeBase {
        required name: str;
        description: str;
        
        items := .<knowledge_base[is KnowledgeBaseItem];
    }

    type KnowledgeBaseItem {
        required knowledge_base: KnowledgeBase;

        required created_at: datetime {
            default := datetime_current();
        }
        required last_updated_at: datetime {
            default := datetime_current();
            rewrite insert, update using (datetime_of_statement());
        }

        required name: str;
        file_key: str;
        source_url: str;

        constraint exclusive on ((.knowledge_base, .name));
    }

}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants