"dbt seed --full-refresh" doesn't work if the relation exists already

[nicoweidner]

I created test_seed.csv in the seeds folder with the following content:

field1,field2,field3
value11,value21,1
value12,value22,2

Then I ran dbt seed, which created and populated the stream dbt_demo__test_seed as expected (where dbt_demo is my local namespace).

However, when running dbt seed --full-refresh afterwards, I get this error:

15:41:12  Unhandled error while executing seed.example.test_seed
Decodable: ResourceAlreadyExists: {'timestamp': '2024-01-14T15:41:12.112+00:00', 'message': 'Unable to delete stream id [cad36ab9] as it is referenced by connection [ff748cbd].'}

[nicoweidner]

Initial analysis:

• dbt seed --full-refresh calls reset_csv_table in full refresh mode, see this section
• reset_csv_table then attempts to drop the relation
• However, the drop_relation implementation does not account for connections - it only tries to delete pipelines first, then the stream. So in the seed case, it doesn't handle the created REST connection and just tries to delete the stream - which fails, as it is referenced by the connection