Error 001003 (42000): SQL compilation error: syntax error line 1 at position 27 unexpected ''. when upgrading Artifacts

[TommyD053]

Hi,

I'm hoping I can get some assistance with the upgrade issue. I'm upgrading 0.8.0 to 1. I'm following https://github.com/brooklyn-data/dbt_artifacts/tree/1.0.0
my dbt yml file shows

• package: dbt-labs/dbt_utils
  version: ['>=0.8.6', '<1.1.0']

• package: calogica/dbt_date
  version: ['>0.5.7', '<0.7.2']

• package: data-mie/dbt_profiler
  version: ['>0.4.1', '<0.7.0']

• package: brooklyn-data/dbt_artifacts
  version: [">0.8.0", "<1.1.0"]

  my dbt version is 1.3

  when I run dbt run-operation create_dbt_artifacts_tables I get this error
  ........
  File "/usr/lib/python3.8/contextlib.py", line 131, in exit
  self.gen.throw(type, value, traceback)
  File "/usr/local/lib/python3.8/dist-packages/dbt/adapters/snowflake/connections.py", line 254, in exception_handler
  raise DatabaseException(msg)
  dbt.exceptions.DatabaseException: Database Error
  001003 (42000): SQL compilation error:
  syntax error line 1 at position 27 unexpected ''.

removing dbt_artifacts schema and running everything from scratch also returns that error. Could anyone please, help me resolve it?

Thanks heaps in advance!

[TommyD053]

issue also happens when

packages:

• package: dbt-labs/dbt_utils
  version: 1.1.1

• package: calogica/dbt_date
  version: 0.7.2

• package: data-mie/dbt_profiler
  version: 0.7.0

• package: brooklyn-data/dbt_artifacts
  version: 2.4.0

  1.3 dbt

[TommyD053]

issue resolved by removing the old dbt_artifacts all together and replacing it with 2.4.2