0

I created a DuckDB database in python and I'm getting:

con = duckdb.connect('../data/proposal.db')
con.sql("SELECT COUNT(*) FROM proposals")
>>>
┌──────────────┐
│ count_star() │
│    int64     │
├──────────────┤
│       200000 │
└──────────────┘

But once I setup a connection in DBeaver following the official docs here: https://duckdb.org/docs/guides/sql_editors/dbeaver, connect to the same file as in python and run the same query

select count(*) from proposals

I get

SQL Error: java.sql.SQLException: Catalog Error: Table with name proposals does not exist!
Did you mean "temp.information_schema.tables"?
LINE 1: select count(*) from proposals

I also do not see any tables in the GUI browser for this database.

I have read a related question here: Open DuckDB database using Python and DBeaver but it talks about setting up a connection which I have already done

How can I visually explore a DuckDB database in DBeaver?

ruslaniv
  • 458
  • 1
  • 6
  • 14

0 Answers0