We're looking to leverage Fivetran’s SaaS platform to orchestrate dbt transformations. We've successfully integrated our existing Fivetran instance with our dbt Core setup, which runs queries directly on Snowflake. This approach would enables us to maintain a seamless end-to-end data lineage across our pipelines.

With Snowflake's recent announcement that dbt projects can now run natively within its platform, our Spark team is excited about the potential this brings. We're interested in exploring this capability further.

Currently, we've been using Fivetran integrated with dbt Core, which operates outside of Snowflake. As we evaluate a potential shift to running dbt directly within Snowflake, our key question is:

can Fivetran still invoke and orchestrate dbt projects that are hosted and executed on Snowflake natively . I guess at the moment this is not possible but can Fivetran team look into this