bug: dbt tests failing

[pnadolny13]

• hubspot_publish https://app.meltano.cloud/logs/01GGWBJ538JBBW4TV91E4ST1PF/fa726c6dab7d4f95ad898d5781d53b69 unique_org_activity_project_org_name has 1 violation
• marts_refresh https://app.meltano.cloud/logs/01GGWBJ538JBBW4TV91E4ST1PF/69244454659c4598a90f8437cb11b962 unique_cloud_executions_base_cloud_execution_id
• mart_refresh https://app.meltano.cloud/logs/01GGWBJ538JBBW4TV91E4ST1PF/3bd9b15ddf994d68b2e5b0e83dc5fd65 assert_cloud_execution_timestamps

[pnadolny13]

The duplicate execution IDs is due to https://github.com/meltano/infra/issues/1500 in the join logic we assume deployments and environments are 1-1 but theres now a user who has multiple deployments for the same environment so its fanning out the join. The backend tables need to be altered in order to support this. Either limit 1-1 for deployments and environments or add the deployment to the workload metadata table.

UPDATE: the metadata workload tables does have deployment name but it was never staged in dbt, see https://github.com/meltano/infra/issues/1500#issuecomment-1609826312.