Hi everyone! I’ve just installed the elementary package for the first time and I received errors on the run command

dbt run —select elementary

. The output is:

13

elementary tables get created but

9

fail to create (e.g. dev_elementary.dbt_columns, dev_elementary.dbt_exposures, dev_elementarty.dbt_metrics etc.) I’m using

dbt

with

DuckDB

as my “warehouse” btw. After those failures I get these error messages:

14:39:49    Runtime Error in model dbt_columns (models/edr/dbt_artifacts/dbt_columns.sql)
  Parser Error: syntax error at or near "meta"
  LINE 6: ... 14:39:42','3271b3bd344e830e44326962a61aea9a'),('column.model.elementary.dbt_m...
                                                    ^
14:39:49
14:39:49    Runtime Error in model dbt_exposures (models/edr/dbt_artifacts/dbt_exposures.sql)
  Catalog Error: Table with name "dbt_exposures" already exists!
14:39:49
14:39:49    Runtime Error in model dbt_metrics (models/edr/dbt_artifacts/dbt_metrics.sql)
  Catalog Error: Table with name "dbt_metrics" already exists!
14:39:49
14:39:49    Runtime Error in model dbt_models (models/edr/dbt_artifacts/dbt_models.sql)
  Parser Error: syntax error at or near "elementary"
  LINE 6: ...ev_timestamp_column": "generated_at"}','[]','dev','dev_elementary','["macro.el...
                                                    ^
14:39:49
14:39:49    Runtime Error in model dbt_seeds (models/edr/dbt_artifacts/dbt_seeds.sql)
  Catalog Error: Table with name "dbt_seeds" already exists!
14:39:49
14:39:49    Runtime Error in model dbt_snapshots (models/edr/dbt_artifacts/dbt_snapshots.sql)
  Catalog Error: Table with name "dbt_snapshots" already exists!
14:39:49
14:39:49    Runtime Error in model dbt_sources (models/edr/dbt_artifacts/dbt_sources.sql)
  Parser Error: syntax error at or near "s3"
  LINE 6: ...ss_warn_after,freshness_error_after,freshness_filter,freshness_description,rel...
                                                    ^
14:39:49
14:39:49    Runtime Error in model dbt_tests (models/edr/dbt_artifacts/dbt_tests.sql)
  Parser Error: syntax error at or near "structured"
  LINE 6: ...alias,test_column_name,severity,warn_if,error_if,test_params,test_namespace,ta...
                                                    ^
14:39:49
14:39:49    Runtime Error in model metrics_anomaly_score (models/edr/data_monitoring/anomaly_detection/metrics_anomaly_score.sql)
  Catalog Error: Scalar Function with name dateadd does not exist!
  Did you mean "date_add"?
14:39:49
14:39:49    on-run-end failed, error:
 Parser Error: syntax error at or near "dummy_string"
LINE 8: ...tus,resource_type,execution_time,execute_started_at,execute_completed_at,compi...
                                                  ^
14:39:49
14:39:49  Done. PASS=13 WARN=0 ERROR=10 SKIP=8 TOTAL=31

Let me know if I can provide any other information (e.g. my profiles.yml or dbt_project.yml, etc.) Thank you!

Hi @Seyi Ogunsemi, this happens because unfortunately we don't yet support DuckDB.

Ah ok, thank you!