Need to replace query.warehouse by query.database_name (Snowflake Database/Datafusion Catalog) in login request, as currently it using warehouse parameter for matching database (Snowflake Database/Datafusion Catalog) in list of databases internally called warehouses.
Such fix removes hidden requirement for having the same name for database and for warehouse, just as of such discrepancy.
After this change and probably some other adjustments we will be able to use snowflake/dbt connection parameters in following most native way:
warehouse = "bucket"
database = "snowplow"
schema = "public"
Following provided as reference as part of our convention:
Datafusion Catalog == Snowflake Database == Our Warehouse
Datafusion Schema == Snowflake Schema == Our namespace
Datafusion Table == Snowflake Table == Our table