Decube
Try for free
  • 🚀Overview
    • Welcome to decube
    • Getting started
      • How to connect data sources
    • Security and Compliance
    • Data Policy
    • Changelog
    • Public Roadmap
  • 🔌Data Warehouses
    • Snowflake
    • Redshift
    • Google Bigquery
    • Databricks
    • Azure Synapse
  • 🔌Relational Databases
    • PostgreSQL
    • MySQL
    • SingleStore
    • Microsoft SQL Server
    • Oracle
  • 🔌Transformation Tools
    • dbt (Cloud Version)
    • dbt Core
    • Fivetran
    • Airflow
    • AWS Glue
    • Azure Data Factory
    • Apache Spark
      • Apache Spark in Azure Synapse
    • OpenLineage (BETA)
    • Additional configurations
  • 🔌Business Intelligence
    • Tableau
    • Looker
    • PowerBI
  • 🔌Data Lake
    • AWS S3
    • Azure Data Lake Storage (ADLS)
      • Azure Function for Metadata
    • Google Cloud Storage (GCS)
  • 🔌Ticketing and Collaboration
    • ServiceNow
    • Jira
  • 🔒Security and Connectivity
    • Enabling VPC Access
    • IP Whitelisting
    • SSH Tunneling
    • AWS Identities
  • ✅Data Quality
    • Incidents Overview
    • Incident model feedback
    • Enable asset monitoring
    • Available Monitor Types
    • Available Monitor Modes
    • Catalog: Add/Modify Monitor
    • Set Up Freshness & Volume Monitors
    • Set Up Field Health Monitors
    • Set Up Custom SQL Monitors
    • Grouped-by Monitors
    • Modify Schema Drift Monitors
    • Modify Job Failure Monitors (Data Job)
    • Custom Scheduling For Monitors
    • Config Settings
  • 📖Catalog
    • Overview of Asset Types
    • Assets Catalog
    • Asset Overview
    • Automated Lineage
      • Lineage Relationship
      • Supported Data Sources and Lineage Types
    • Add lineage relationships manually
    • Add tags and classifications to fields
    • Field Statistcs
    • Preview sample data
  • 📚Glossary
    • Glossary, Category and Terms
    • Adding a new glossary
    • Adding Terms and Linked Assets
  • Moving Terms to Glossary/Category
  • AI Copilot
    • Copilot's Autocomplete
  • 🤝Collaboration
    • Ask Questions
    • Rate an asset
  • 🌐Data Mesh [BETA]
    • Overview on Data Mesh [BETA]
    • Creating and Managing Domains/Sub-domains
    • Adding members to Domain/Sub-domain
    • Linking Entities to Domains/Sub-domains
    • Adding Data Products to Domains/Subdomains
    • Creating a draft Data Asset
    • Adding a Data Contract - Default Settings
    • Adding a Data Contract - Freshness Test
    • Adding a Data Contract - Column Tests
    • Publishing the Data Asset
  • 🏛️Governance
    • Governance module
    • Classification Policies
    • Auto-classify data assets
  • ☑️Approval Workflow
    • What are Change Requests?
    • Initiate a change request
    • What are Access Requests?
    • Initiate an Access Request
  • 📑Data reconciliation
    • Adding a new recon
    • Understand your recon results
    • Supported sources for Recon
  • 📋Reports
    • Overview of Reports
    • Supported sources for Reports
    • Asset Report: Data Quality Scorecard
  • 📊Dashboard
    • Dashboard Overview
    • Incidents
    • Quality
  • ⏰Alert Notifications
    • Get alerts on email
    • Connect your Slack channels
    • Connect to Microsoft Teams
    • Webhooks integration
  • 🏛️Manage Access
    • User Management - Overview
    • Invite users
    • Deactivate or re-activate users
    • Revoke a user invite
  • 🔐Group-based Access Controls
    • Groups Management - Overview
    • Create Groups & Assign Policies
    • Source-based Policies
    • Administrative-based Policies
    • Module-based Policies
    • What is the "Owners" group?
  • 🗄️Org Settings
    • Multi-factor authentication
    • Single Sign-On (SSO) with Microsoft
    • Single Sign-On (SSO) with JumpCloud
  • ❓Support
    • Supported Features by Integration
    • Frequently Asked Questions
    • Supported Browsers and System Requirements
  • Public API (BETA)
    • Overview
      • Data API
        • Glossary
        • Lineage
        • ACL
          • Group
      • Control API
        • Users
    • API Keys
Powered by GitBook
On this page
  • Supported Capabilities
  • Minimum Requirements
  • Adding a dbt connection on decube.
  • Retrieve Service Token from dbt account settings
  1. Transformation Tools

dbt (Cloud Version)

Adding dbt to your decube connections helps you monitor your transformations via our Data Quality model and see metadata on your dbt models and jobs directly synced to the Data Catalog.

PreviousOracleNextdbt Core

Last updated 2 months ago

This documentation is for the cloud version of dbt which is dbt Cloud. To see documentation on how to connect the open source version of dbt, please check out the documentation for dbt core .

Supported Capabilities

Data Quality
Capability

Freshness

Volume

Schema Drift

Field Health

Custom SQL

Job Failure

Catalog
Capability

Data Profiling

Data Preview

Data Recon
Capability

Add Recon

Minimum Requirements

This connection requires to be generated in dbt Cloud, which is only accessible to dbt accounts on Team and Enterprise plans.

  • Service Account API Key

  • Account ID

  • Tenancy Type

  • Access URL (if non DBT multi-tenant)

  • Discovery URL (if non DBT multi-tenant)

Adding a dbt connection on decube.

  • From the My Account page on decube platform, select on the dbt tile to be brought to the dbt connection form.

  1. Account ID

  • To get your Account ID, you can refer to the numbers at the end of the accounts path component of the URL (https://cloud.getdbt.com/settings/accounts/{account_id}).

  1. API Key

  • To get your API Key, please read on to the next section "Retrieve Service Token from dbt account settings" to generate your service token for your dbt account.

  1. DBT Tenancy Type

  • Usually this will be US Multi Tenant for most customers. To verify, check the domain you log in to your DBT with

    • US Multi Tenant - cloud.getdbt.com

    • EMEA Multi Tenant - emea.dbt.com

    • APAC Multi Tenant - au.dbt.com

If your DBT domain contains other URLs, you must choose Other as the tenancy type and provide item 4 and 5 mentioned below:

  1. Access URL (For Other tenancy type)

  1. Discovery URL (For Other tenancy type)

Retrieve Service Token from dbt account settings

  1. Log into your dbt account. From the Dashboard, click on gear icon on the top right corner as shown in image, to navigate to Account Settings.

  1. Within Account Settings, find the setting for Service Tokens on the left sidebar.

  1. Within the Service Tokens section, click on + New Token.

  1. Within the New Service Token page, you can set any token name, such as "decube". Then, click on the + Add button.

  1. Select Job Admin and add all the Projects that you would like to connect decube with. Then, click on Save at the bottom right.

  1. A token will be generated. Use the Copy button to copy the token into your clipboard.

  1. Insert the Service token that you've copied into the "API Key" of the connection form, then test the connection. If it is successful, you can now add the name and submit the connection.

If there is any issues or questions related with connecting your data sources, please reach out to us via our Live chat for support.

Navigate to your DBT Account Settings and below the Account Information pane, you can find the Access URL. You can follow the guide from DBT

Navigate to your DBT Account Settings and below the Account Information pane, you can find the Discovery API URL. You can follow the guide from DBT

🔌
here
Service Account Tokens
here
here
❌
❌
❌
❌
❌
✅
❌
❌
❌
Overview of dbt connection form
Click on the Account Settings on the top right of the dbt Dashboard.
Find Service Tokens in the Account Settings.
Add a new token under the Service Tokens section.
Give a name and add the permissions.
Setting the correct permissions for the Service Token.
Copy the Service Token.