Ivan
03/07/2023, 8:25 PMDatabase Error in model dbt_metrics_custom_calendar (models/dbt_metrics_custom_calendar.sql)
No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
What I’m doing wrong? It seems that the warehouse is already stated in SnowflakeTarget Block (and it shows when I’m running dbt debug
), but when I’m trying to run some models, it gives me this kind of error.
>>> prefect.__version__
'2.8.3'
>>> prefect_dbt.__version__
'0.3.1'
>>> prefect_snowflake.__version__
'0.26.1'
Sean Williams
03/07/2023, 9:06 PMrole: None
, but you might need to specify a role that has access to the warehouse, DEVELOPER_WAREHOUSE
Ivan
03/07/2023, 11:02 PMdbt build --select dbt_metrics_custom_calendar
, it executes successfully but this error with warehouse is keeping to show up 🥲Sean Williams
03/07/2023, 11:05 PMWAREHOSE
-> WAREHOUSE
should do the trickIvan
03/07/2023, 11:09 PM