Update dbt debug to also check that the database and warehouse fields are correct

[sidpatel13]

Is this a new bug in dbt-snowflake?

• I believe this is a new bug in dbt-snowflake
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Currently dbt debug runs select 1 as id (link). And seems like snowflake will allow you to do that without correct database/warehouse. This means that this command will pass regardless of whether the warehouse, database info provided is correct.

Expected Behavior

dbt debug should fail if the warehouse or database info is incorrect.

Steps To Reproduce

Run dbt debug with wrong config values for database and warehouse. It will still pass.

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-snowflake:

Additional Context

No response

[amychen1776]

Taking a look at this - this is expected behavior even in Snowflake

For the debug command that we are running (select 1 as id) - it makes sense that it wouldn't check the database. We aren't selecting an object in the database. For that, I don't see us updating. For warehouse - this would be an enhancement, even on Snowflake's capabilities with that query.

[amychen1776]

At this time, this is not something we intend to change because the behavior is expected on Snowflake.