Open katy-sadowski opened 1 month ago
This is getting "standardized" so that the columns will be lower case across the packages. I believe if you run off the development branch you should have success. Fix on its way.
Awesome! Thanks Frank!
I had the same issue with the current release and the develop branch worked. Thanks!
I'm getting the following error when I try to run Achilles on duckdb:
Full traceback:
It seems that
insertTable
is adding quotes around the csv column names, which in the achilles analysis csv are in all-caps. However, the achilles_analysis table is created with lowercase column names. Quoted identifiers are case sensitive in duckdb: https://duckdb.org/docs/sql/dialect/keywords_and_identifiers.html#case-sensitivity-of-identifiersI wasn't actually sure at what level to consider this a bug - Achilles, DatabaseConnector, or SqlRender :) let me know and I can move this report if needed.