Dbt Core Setup Guide

Prerequisites

• A connected data warehouse on Matia

Connection Details

1. Account Identifier

• Click on Create ARN Role to start the creation of the required role.
• Provide a path to an S3 bucket directory that contains two files: catalog.json and manifest.json. Example path: s3://your-bucket-name/dbt
• On your DBT Core instance, run: dbt docs generate The files will be generated in the target/ folder of your DBT Core project.
• Apply the following S3 bucket policy on your provided bucket:

	"Version": "2012-10-17",
	"Statement": [
		{
			"Sid": "AllowListPrefix",
			"Effect": "Allow",
			"Principal": {
				"AWS": "<PROVIDED_ROLE_ARN>"
			},
			"Action": "s3:ListBucket",
			"Resource": "arn:aws:s3:::<BUCKET_NAME>",
			"Condition": {
				"StringLike": {
					"s3:prefix": [
						"<PREFIX>",
						"<PREFIX>/*"
					]
				}
			}
		},
		{
			"Sid": "AllowReadObjectsInPrefix",
			"Effect": "Allow",
			"Principal": {
				"AWS": "<PROVIDED_ROLE_ARN>"
			},
			"Action": "s3:GetObject",
			"Resource": "arn:aws:s3:::<BUCKET_NAME>/<PREFIX>/*"
		}
	]
}

1. Replace <BUCKET_NAME> with the bucket name.
2. Replace <PROVIDED_ROLE_ARN> with the Role ARN we provide.
3. Replace <PREFIX> with prefix to your objects.
4. Confirm that the provided Role ARN can access the bucket and read the catalog.json and manifest.json files.

Final Configuration

1. Select the data warehouse which is defined as part of you DBT project.
2. Enter a Name for the Asset.
3. (Optional) Enter a Description for the Asset.
4. Select the Owner of the Asset.
5. (Optional) Verify that your DBT Cloud account is successfully connected by clicking on Test Connection.
6. Click Connect.