search

dbt-labs / jaffle-shop-template

Template for a DuckDB-based, Codespace-oriented sandbox project that is also dbt Cloud compatible, and includes code-first BI tooling via Evidence.
51 stars 30 forks source link

evidence.dev can't read duckdb file generated by python #27

Open eitsupi opened 1 year ago

eitsupi commented 1 year ago

Thank you for creating this useful project!

I tried this today and the duckdb file was created by python duckdb 0.8.0 and failed to load in js duckdb 0.7.1. https://github.com/dbt-labs/jaffle-shop-template/blob/12acd811dbdc44cf948af2c38c654cf6b1ac1ce3/reports/package-lock.json#L2214-L2216

I think we need to pin all DuckDB versions in this project (to 0.7.1 now).

szaffarano commented 1 year ago

Try updating the evidence dependencies:

diff --git a/reports/package.json b/reports/package.json
index 7b51329..34f3048 100644
--- a/reports/package.json
+++ b/reports/package.json
@@ -14,9 +14,9 @@
   },
   "type": "module",
   "dependencies": {
-    "@evidence-dev/evidence": "15.0.1",
-    "@evidence-dev/preprocess": "2.2.0",
-    "@evidence-dev/components": "2.2.1"
+    "@evidence-dev/evidence": "17.0.3",
+    "@evidence-dev/preprocess": "2.4.0",
+    "@evidence-dev/components": "2.4.0"
   },
   "overrides": {
     "jsonwebtoken": "9.0.0",

it worked for me