thanks for the reply. got it. so it is not possible to connect two database at same time.
sir, are you familiar with semantic layer feature, wondering if this is something you can help? i have another post and link is below, trying to make semantic feature work on dbt cloud.
how to add time_grants to metrics yml files - Help - dbt Community Forum (getdbt.com)