Follow these steps to set up a metadata integration from dbt Cloud to Rasgo
These instructions will help you set up the integration to sync metadata from dbt Cloud to Rasgo. If you're just wondering what will be sync'd from dbt Cloud, scroll down to the bottom of this page.
Setup a new job in dbt Cloud to compile the SQL and docs for all dbt models in your project.
The dbt cloud job does not need to run the models, just compile the SQL.
When setting up the new job:
- Choose your
- Check the box for
- In Commands, add this command:
dbt compile --full-refresh
- In Triggers -> Schedule, Choose to run on schedule, and have it run every day at exactly hour 8 (which is midnight PST; 3 AM EST)
- Click Save
- All done! You've made a new job
This job needs to run and generate metadata before Rasgo can import it. To run the job, click the green
Run Nowbutton, and wait until it completes and shows a green
Successstatus for the run.
To set up the integration in Rasgo, you'll need 3 things:
- 1.Read-Only service token for dbt Cloud
- 2.dbt Cloud account ID
- 3.dbt Cloud job ID
To generate the service token, go to your 'Account Settings' page in dbt Cloud and click 'Service Tokens' in the left side nav. Click 'New Token' and for the Permission Set, choose 'Read-Only'.
Create a new Read-Only Service Token in dbt Cloud
Click 'Save' and then make sure to copy the Service Token to your clipboard, because you won't be able to see it again.
Next, to get the IDs, you can pull them directly out of the URL. The URL will be structured like this:
Just save those two numbers, the
job_id, for later and you're ready to go.
- Find the dbt Connect section at the bottom
- Paste in the Service Token, account ID, and job ID
- Click "Connect"
The integration is set up and good to go! Now, you can import your dbt models into Rasgo by clicking the "Import Now" button.
Click this button each time you wish to import or sync your models with Rasgo. By default, Rasgo will detect if a new dbt run has occurred since the last time you synced, and only run an import if it has.
If you need your dbt import to run on a recurring schedule, contact Rasgo support to discuss configuration options
Rasgo only imports metadata from dbt manifest files, it does not move actual data out of your cloud DataWarehouse or edit your dbt project.
Here is the metadata that Rasgo will ingest from dbt Cloud:
- dbt models -> Rasgo datasets
- Column descriptions
- dbt metrics -> Rasgo metrics
- Metric definition