Table very slow when run as upstream dependancy.

Help
1

I’ve got Table A and it is used to create Table B.
When I locally run Table A it takes ~14 seconds. When I run Table B and it’s 1st upstream dependancies including Table A, Table A takes literal hours to run.
Do you have any idea why this might be?

  1. dbt run --select TABLE_A (FAST!)
  2. dbt run --select 1+TABLE_B (TABLE A IS SO SLOW!)

pls help

2

First, look at how Table B is referencing Table A, if there are unnecessary joins or complex transformations, they might be causing performance issues.

Also, check if there are any incremental strategies in place. dbt might be processing more data than expected when running dependencies. Try running dbt debug to see if any caching or materialization issues appear.