Database Error in model depin_revenue on local dbt compile

[0xRobin]

I'm getting

09:23:02  Encountered an error:
Runtime Error
  Database Error in model depin_revenue (models/_sector/depin/depin_revenue.sql)
    failed to execute: HTTPConnectionPool(host='trino', port=1234): Max retries exceeded with url: /v1/statement (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7fd5d60afe80>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution'))

When running dbt compile.

I believe this is due the use of dbt_utils.union_relations here:

spellbook/models/_sector/depin/depin_revenue.sql

Lines 9 to 13 in d2efb1f

	dbt_utils.union_relations(
	relations=[
	ref("geodnet_polygon_revenue")
	]
	)

which might require a database connection to work? 🤔

Are we able to rewrite this with a 'vanilla' union loop?

cc: @0xnirmal @Hosuke @jeff-dude

[tomfutago]

Yep, I'm getting this error too, thanks for looking into this!

[Hosuke]

Sorry I forgot dbt_utils.union_relations is not supported locally.

[jeff-dude]

nice catch!