any dealt with this error when running `load assets from dbt

Question

any dealt with this error when running `load assets from dbt project` in a venv ```ImportError cannot import name bigquery from dbt include unknown location ```

Charlie Bini · Answer

oddly it doesn t have a problem in production but fails in my local dev environment

Charlie Bini · Answer

there is no bigquery module under dbt include

Charlie Bini · Answer

but I have dbt bigquery installed

rex · Answer

have you tried clearing out your `~ dbt ` profile folder this cache may be overriding your existing profile <https docs getdbt com docs get started connection profiles>

Charlie Bini · Answer

ooh good call

Charlie Bini · Answer

let me see

Charlie Bini · Answer

nope actually don t have ~ dbt

Charlie Bini · Answer

here s the full traceback ```Encountered an error cannot import name bigquery from dbt include unknown location Traceback most recent call last File workspaces teamster venv lib python3 10 site packages dbt main py line 135 in main results succeeded = handle and check args File workspaces teamster venv lib python3 10 site packages dbt main py line 198 in handle and check task res = run from args parsed File workspaces teamster venv lib python3 10 site packages dbt main py line 225 in run from args task = parsed cls from args args=parsed File workspaces teamster venv lib python3 10 site packages dbt task base py line 186 in from args return super from args args File workspaces teamster venv lib python3 10 site packages dbt task base py line 108 in from args config = cls ConfigType from args args File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 263 in from args project profile = cls collect parts args File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 207 in collect parts profile = cls collect profile args=args File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 229 in collect profile profile = cls get rendered profile args profile renderer profile name File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 200 in get rendered profile return Profile render from args args profile renderer profile name File workspaces teamster venv lib python3 10 site packages dbt config profile py line 426 in render from args return cls from raw profiles File workspaces teamster venv lib python3 10 site packages dbt config profile py line 392 in from raw profiles return cls from raw profile info File workspaces teamster venv lib python3 10 site packages dbt config profile py line 346 in from raw profile info credentials Credentials = cls credentials from profile File workspaces teamster venv lib python3 10 site packages dbt config profile py line 179 in credentials from profile cls = load plugin typename File workspaces teamster venv lib python3 10 site packages dbt adapters factory py line 201 in load plugin return FACTORY load plugin name File workspaces teamster venv lib python3 10 site packages dbt adapters factory py line 56 in load plugin mod Any = import module + name dbt adapters File usr local lib python3 10 importlib init py line 126 in import module return bootstrap gcd import name level package level File lt frozen importlib bootstrap gt line 1050 in gcd import File lt frozen importlib bootstrap gt line 1027 in find and load File lt frozen importlib bootstrap gt line 1006 in find and load unlocked File lt frozen importlib bootstrap gt line 688 in load unlocked File lt frozen importlib bootstrap external gt line 883 in exec module File lt frozen importlib bootstrap gt line 241 in call with frames removed File workspaces teamster venv lib python3 10 site packages dbt adapters bigquery init py line 8 in lt module gt from dbt include import bigquery ImportError cannot import name bigquery from dbt include unknown location Traceback most recent call last File usr local lib python3 10 runpy py line 196 in run module as main return run code code main globals None File usr local lib python3 10 runpy py line 86 in run code exec code run globals File workspaces teamster src teamster kippcamden definitions py line 10 in lt module gt from teamster kippcamden import CODE LOCATION datagun dbt powerschool File workspaces teamster src teamster kippcamden dbt init py line 1 in lt module gt from teamster kippcamden dbt import assets File workspaces teamster src teamster kippcamden dbt assets py line 17 in lt module gt dbt assets = load assets from dbt project File workspaces teamster venv lib python3 10 site packages dagster dbt asset defs py line 613 in load assets from dbt project manifest json cli output = load manifest for project File workspaces teamster venv lib python3 10 site packages dagster dbt asset defs py line 59 in load manifest for project cli output = execute cli File workspaces teamster venv lib python3 10 site packages dagster dbt cli utils py line 143 in execute cli raise DagsterDbtCliFatalRuntimeError messages=messages dagster dbt errors DagsterDbtCliFatalRuntimeError Fatal error in the dbt CLI return code 2 Encountered an error cannot import name bigquery from dbt include unknown location Traceback most recent call last File workspaces teamster venv lib python3 10 site packages dbt main py line 135 in main results succeeded = handle and check args File workspaces teamster venv lib python3 10 site packages dbt main py line 198 in handle and check task res = run from args parsed File workspaces teamster venv lib python3 10 site packages dbt main py line 225 in run from args task = parsed cls from args args=parsed File workspaces teamster venv lib python3 10 site packages dbt task base py line 186 in from args return super from args args File workspaces teamster venv lib python3 10 site packages dbt task base py line 108 in from args config = cls ConfigType from args args File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 263 in from args project profile = cls collect parts args File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 207 in collect parts profile = cls collect profile args=args File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 229 in collect profile profile = cls get rendered profile args profile renderer profile name File workspaces teamster venv lib python3 10 site packages dbt config runtime py line 200 in get rendered profile return Profile render from args args profile renderer profile name File workspaces teamster venv lib python3 10 site packages dbt config profile py line 426 in render from args return cls from raw profiles File workspaces teamster venv lib python3 10 site packages dbt config profile py line 392 in from raw profiles return cls from raw profile info File workspaces teamster venv lib python3 10 site packages dbt config profile py line 346 in from raw profile info credentials Credentials = cls credentials from profile File workspaces teamster venv lib python3 10 site packages dbt config profile py line 179 in credentials from profile cls = load plugin typename File workspaces teamster venv lib python3 10 site packages dbt adapters factory py line 201 in load plugin return FACTORY load plugin name File workspaces teamster venv lib python3 10 site packages dbt adapters factory py line 56 in load plugin mod Any = import module + name dbt adapters File usr local lib python3 10 importlib init py line 126 in import module return bootstrap gcd import name level package level File lt frozen importlib bootstrap gt line 1050 in gcd import File lt frozen importlib bootstrap gt line 1027 in find and load File lt frozen importlib bootstrap gt line 1006 in find and load unlocked File lt frozen importlib bootstrap gt line 688 in load unlocked File lt frozen importlib bootstrap external gt line 883 in exec module File lt frozen importlib bootstrap gt line 241 in call with frames removed File workspaces teamster venv lib python3 10 site packages dbt adapters bigquery init py line 8 in lt module gt from dbt include import bigquery ImportError cannot import name bigquery from dbt include unknown location ```

Charlie Bini · Answer

ok reinstalling dbt bigquery solves it

Charlie Bini · Answer

I was having some trouble adding it originally bc of dagster dbt s lt 1 4 0 restriction so it probably got messed up before I figured out that I needed to install a previous version