Skip to content

Quack Client: discover server objects (tables, views, etc) using information_schema.tables/information_schema.views and/or duckdb_tables and/or SHOW TABLES #175

Description

@rpbouman

DuckDB 1.5.4.

I set up a quack server and a quack client as per https://duckdb.org/quack/
the client can select from the remote table.

However, when I run SELECT * FROM information_schema.tables, or friends like select * from duckdb_tables() the remote database does not show up.
I can discover tables using SELECT * FROM remote.query('SELECT * FROM information_schema.tables') , but I was hoping that is not necessary.

I expected it to work without explicitly calling remote.query, because when I attach a ducklake or iceberg catalog, I can also discover those tables using just a plain query on information_schema.tables. Since access to those was also obtained through ATTACH, one would expect that the mechanism for discovering objects would also the same.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions