Hi Chris, you can go to Integrations > Snowflake Integration > Schema and check which schemas you'd like to import (and uncheck the PR run schema). Hopefully this is what you're looking for
a
adventurous-furniture-1306
09/17/2021, 6:43 PM
I actually set up the dbt connection first, without Snowflake. This is pure dbt API info
e
elegant-house-93198
09/17/2021, 6:47 PM
Oh okay that's interesting. So short answer for dbt is we currently don't allow that. However, if you integrate Snowflake you'll have that option. You're the first to ask about limiting what comes in from dbt so we'll have to add that same functionality to the dbt integration
a
adventurous-furniture-1306
09/17/2021, 6:48 PM
Ah. If I were to remove the dbt data, add Snowflake, and then readd dbt, would it only pull in info related to existing Snowflake tables?
adventurous-furniture-1306
09/17/2021, 6:49 PM
The connector automatically pulled in all environments data, including the PR and Dev environments, which is not useful for cataloging.
e
elegant-house-93198
09/17/2021, 6:52 PM
That's correct, you need to have both the dbt and Snowflake integration to pull in metadata from both sources. When you delete the dbt integration, all of the metadata is also deleted.
You're feedback is 100% correct, we aren't experienced users of dbt so adding an option to limit by env was an oversight. But not a difficult change to implement