The problem I’m having
I get an error when using Alter Table statement. The error is “CatalogException: Table with name tablename does not exist!” This is strange because I used the Describe select statement just before it and it described the table, thus read the table.
The context of why I’m trying to do this
I want to change the column type from BIGINT to VARCHAR. I am running DuckDB in Python JuypterLab Version 4.0.2
What I’ve already tried
Some example code or error messages
duckdb.sql(“”" ALTER TABLE ‘/XXXX/XXXXX/tablename.parquet’ ALTER YYYYY TYPE VARCHAR “”")
Put code inside backticks
to preserve indentation
which is especially important
for Python and YAML!