dbt Partner ConnectorConnect dbt Without Constraints
IntelliPaaS seamlessly connects dbt with your core business systems, enabling no-code integration for governed metrics, transformation orchestration and data platform reporting across cloud, on-prem and hybrid environments.
dbt ships both a hosted remote server and a self-hosted one, and the split matters: the remote server covers the semantic layer, discovery metadata, the administrative API, SQL including text-to-SQL, Fusion tools and product documentation, while dbt CLI commands and local project access are self-hosted only. Authentication is OAuth for the remote path, with dynamic client registration, or token headers where a service token and a personal token differ in one important way — service tokens cannot execute SQL. OAuth scopes act as a filter on existing permissions rather than granting anything new, and access can be limited to named projects. The endpoint follows your dbt account's region, which spans the US, Europe, Australia and Japan across three clouds, so residency is genuine. Toolsets can also be trimmed per connection with header flags.
dbt integration capabilities
- Query the semantic layer for governed metrics and dimensions.
- Read discovery metadata — models, sources, tests and lineage.
- Read administrative API data for jobs, runs and environments.
- Generate SQL from natural language and execute it where the token permits.
- Use Fusion tools for project-aware development workflows.
- Run dbt CLI commands and code generation on the self-hosted server.
These capabilities let governed metric definitions and transformation state reach the systems that report and act on them, so numbers agreed in dbt travel intact. IntelliPaaS handles field mapping, pagination and data type transformation automatically.
Common integration scenarios
- Serve governed metric values to reporting and operational systems on a schedule.
- Alert Slack or PagerDuty when a dbt job or test fails.
- Raise a ticket with lineage context when a source freshness check breaks.
- Trigger downstream refreshes in Power BI or the warehouse when a run completes.
- Publish model and test metadata into a data catalogue.
These scenarios address the most common friction in analytics engineering — metric definitions duplicated downstream, failures noticed by the people who read the dashboard — by automating the flows between dbt and the platforms around it.
Deployment & security
Flexible deployment is essential for organisations operating in regulated industries or jurisdictions with strict data residency requirements. IntelliPaaS supports private cloud and on-premise deployments with full regional data sovereignty, and the dbt endpoint follows your account's own region across the US, Europe, Australia and Japan. All deployment modes receive the same feature set, connector library and support tier, with no capability trade-offs based on deployment choice.
Why IntelliPaaS
- No-code to pro-code flexibility for all integration needs.
- End-to-end security with OAuth scopes that filter rather than expand existing permissions.
- Region-scoped endpoints across the US, Europe, Australia and Japan.
- Enterprise-grade observability with monitoring, alerting and audit logging.
Frequently connected apps
Snowflake
Databricks
Google BigQuery
Amazon Web Services
Microsoft Azure
Power BI
Elasticsearch
MySQL
Oracle
GitHubFrequently asked questions
What authentication does the connector use?
OAuth is recommended on the remote server, with dynamic client registration and PKCE, or token headers with a personal or service token. One important difference: service tokens cannot execute SQL. OAuth scopes filter existing permissions rather than granting new ones.
What can the remote server not do?
dbt CLI commands and local project access — those are self-hosted only. If a workflow needs to run dbt build or test against a project, that goes through the self-hosted server, which IntelliPaaS can run in any deployment mode.
Are there rate limits or costs?
The remote server allows 5,000 requests a minute per IP; self-hosted is bounded by the public admin and discovery API limits. Text-to-SQL consumes the dbt Copilot action allotment; the other tools do not. AI features must be enabled on the account.
Can I deploy on-premise or in a private cloud?
Yes. Cloud (SaaS), private cloud in your own VPC, and fully on-premise or air-gapped deployments are all supported, with full feature parity across every mode.
Is my data secure?
Data is encrypted in transit and at rest, and IntelliPaaS is GDPR-ready. dbt describes MCP as an access layer that stores no data, the endpoint stays in your account's region, and on-prem modes keep warehouse queries inside your own boundary.