duckdb - unable to list the table schema

[forestlzj]

A clear and concise description of what the bug is.

After setting duckb connection to a local file, in "SQL Editor", it can show list of duckdb connecton and schema correctly, when select a duckdb schema, it can't show the table names in the "See Table schema" drop down box. In superset oupt log, it shows error:

Engine no attribute 'exec_driver_sql'

Environment

(please complete the following information):

• browser type and version: chrome 104.0.5112.102
• superset version: 2.0
• python version: 3.9.13
• duckdb version: 0.4.0
• duckdb-engine version: 0.6.2
• any feature flags active:

Checklist

Add any other context about the problem here.
OS: Redhat 7.9

[forestlzj]

supplement: It can execute sql on duckb correctly but can't show table list and table schema

[forestlzj]

I think it can be fixed after this merge: Mause/duckdb_engine#393

[Mause]

@forestlzj are you able to try with the latest duckdb-engine version? (0.6.3)

[forestlzj]

@Mause duckdb-engine version (0.6.3, 0.6.4) works now, but it still needs to make some minor code change in duckdb_engine specs in superset to fix the said problem. I will submit a PR in superset .