Full refresh of seeds fails because the table doesn't get dropped first

microsoft / dbt-fabric

MIT License

79 stars 28 forks source link

Full refresh of seeds fails because the table doesn't get dropped first #128

Closed natej-eb closed 7 months ago

natej-eb commented 9 months ago

When using the dbt seed --full-refresh command or having +full_refresh: true in dbt_project.yml, the seed table doesn't get dropped first throwing this error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]There is already an object named '<seed_name>' in the database. The create table command tries to run when the table already exists.

Running with dbt=1.7.8
Registered adapter: fabric=1.7.4

prdpsvs commented 8 months ago

@natej-eb , I tested it locally using Jaffle shop project. Please see the following screenshot. I tried the same steps you mentioned, and I can see that the tables are dropped from logs folder. I did dbt seed & dbt seed --full-refresh with and without following in dbt_project.yml file. seeds: jaffle_shop: +full_refresh: true

prdpsvs commented 8 months ago

Screenshot of dbt logs from jaffle_shop project.

prdpsvs commented 7 months ago

@natej-eb , I could not repro this error. Could you please repro and let me know?