Is the Snowflake Connector supported for Fabric dbt Jobs when using a Data Gateway?

Based on the current capabilities, On-premises Data Gateway connectivity is not supported for Microsoft Fabric dbt Jobs with the Snowflake connector.

The key distinction is that the Snowflake connector may support Gateway connectivity for workloads such as:

• Dataflow Gen2

• Pipeline Copy activities

• Other supported Fabric data movement scenarios

However, Fabric dbt Jobs use their own execution environment and connection handling, and they currently support Snowflake Authentication rather than routing through an On-premises Data Gateway.

Your testing results are consistent with this behavior:

• ✅ Microsoft Account Authentication + Gateway works because that path supports Gateway-based connectivity.

• ❌ Snowflake Authentication + Gateway fails because dbt Jobs do not currently use the Gateway connection path for Snowflake credentials.

• ❌ Using service account credentials with Snowflake Authentication will not change this limitation.

For a Snowflake environment that is only reachable through an On-premises Data Gateway, the recommended alternatives are:

• Use a supported Fabric ingestion option (for example, Pipeline Copy activity or Dataflow Gen2 through the Gateway) to land the data into Fabric storage, then run dbt transformations on the Fabric-managed data.

• If direct dbt execution against Snowflake is a requirement, ensure the Snowflake endpoint is reachable from the Fabric dbt execution environment without relying on the On-premises Data Gateway.

• Review your network architecture with your security team to determine whether private connectivity or another supported integration pattern is possible.

At this time, I am not aware of a supported workaround that enables Fabric dbt Jobs → Snowflake → On-premises Data Gateway connectivity.

It would also be helpful to submit this as a Fabric feature request if Gateway support for dbt Jobs is an important requirement for your architecture.

For more information:

• Microsoft Fabric dbt jobs: https://learn.microsoft.com/fabric/data-engineering/dbt-job

• On-premises Data Gateway overview: https://learn.microsoft.com/data-integration/gateway/service-gateway-install

• Snowflake connector in Microsoft Fabric: https://learn.microsoft.com/fabric/data-factory/connector-snowflake

💡 Helpful? Give a Kudos 👍 — keep the community growing.

✅ Solved your issue? Mark this as the Accepted Solution ✔️

Best regards, Prince Singh | Data Science & Microsoft Fabric Enthusiast