improper relation name (too many dotted names) for tables further than staging

[thomasglaser]

hi,

none of the create table tasks in the DAGs are working. they are exiting with this error message:

improper relation name (too many dotted names): dbt.***.dbt.customers__dbt_backup

it has nothing to do with the drop table macro itself but with the rendering of database.schema.table. proof is in the log of the docker postgres db:

DROP TABLE IF EXISTS dbt."postgres"."dbt"."orders__dbt_backup" CASCADE

in the dbt_profile_overrides dag it renders to the following:
improper relation name (too many dotted names): my_dbt_schema.***.my_dbt_schema.customers__dbt_backup

any idea for that? i didn't change a single line in the code.

thanks for helping
thomas

[judeleonard]

Hi @thomasglaser, the issue is as a result of the drop staging tables command in your macros. Once removed I believe the error should go away.