search

codeforkjeff / dbt-sqlite

A SQLite adapter plugin for dbt (data build tool)
Apache License 2.0
78 stars 13 forks source link

models with CamelCase names don't work properly #5

Closed codeforkjeff closed 4 years ago

codeforkjeff commented 4 years ago

dbt will create the model successfully on the first run, but on a subsequent run, I get this error:

Compilation Error in model CamelCaseTest (models\CamelCaseTest.sql)
  When searching for a relation, dbt found an approximate match. Instead of guessing
  which relation to use, dbt will move on. Please delete "main"."CamelCaseTest", or rename it to be less ambiguous.
  Searched for: main.camelcasetest
  Found: "main"."CamelCaseTest"

  > in macro materialization_table_sqlite (macros\materializations\table\table.sql)
  > called by model CamelCaseTest (models\CamelCaseTest.sql)

Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

Not sure why it is searching for a table name with all lower case, instead of the original CamelCaseTest passed in through dbt run -m CamelCaseTest.