DBeaver (JDBC) not displaying view definition

[Alex-Monahan]

What happens?

DBeaver is not able to generate view definitions.

To Reproduce

Right clicking on a view in the left hand panel and generating the DDL does not show the view definition text. I receive the same error when I try to inspect the view itself, so DBeaver just isn't able to find the view definition in some way.

The view was generated with these statements:

create table testing as select 42 as test_col;

create view woot as select * from testing limit 1;

OS:

Windows 10

DuckDB Version:

0.7.1

DuckDB Client:

JDBC

Full Name:

Alex Monahan

Affiliation:

DuckDB Labs and Intel

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[chengjie0929]

I would like tad to be transformed into a duckdb proprietary database management tool based on the current functionality. Because dbeaver is too problematic for duckdb.

[chengjie0929]

What duckdb currently lacks is its own management tool, something similar to plsql developer.

[Mause]

I had a brief look into this issue the other day, and in short, dbeaver doesn't fetch a prerendered ddl string from the driver, instead it queries the driver for the columns, etc, and then depending on which dialect is selected in dbeaver, generates the ddl string using a string template.

This would be fine if you could easily switch to the postgres dialect (instead of the generic one that DuckDB uses by default in dbeaver), but we're not yet compatible enough with postgres for that to work.

Depending on how much we want this feature, we may need to contribute a DuckDB dialect to dbeaver

[LonwoLonwo]

Hello @Mause

Where can I find

prerendered ddl string from the driver

to check how we can read view definitions for DuckDB?

[Mause]

Hello @Mause

Where can I find

prerendered ddl string from the driver

to check how we can read view definitions for DuckDB?

select sql from duckdb_tables();

And similar queries for other things

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue was closed because it has been stale for 30 days with no activity.