Connecting from dbt to Dremio Cloud preview

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

You can use Dremio’s dbt connector dbt-dremio to transform data that is in data sources that are connected to a Dremio project.

Prerequisites

• Download the dbt-dremio package from https://github.com/dremio/dbt-dremio.
• Ensure that Python 3.9.x or later is installed.
• Before connecting from dbt project to Dremio Cloud, follow these prerequisite steps:
  • Ensure that you have the ID of the Dremio project that you want to use. See Obtaining the ID of a Project.
  • Ensure that you have a personal access token (PAT) for authenticating to Dremio Cloud. See Creating a Token.

Installing

Install this package from PyPi by running this command:

pip install dbt-dremio

Initializing a dbt Project

1. Run the command dbt init <project_name>.
2. Select dremio as the database to use.
3. Select one of the dremio_cloud option to generate a profile for your project:

Next, configure the profile for your dbt project.

Profiles

When you initialize a dbt project, you create a profile. For descriptions of the configurations in this profile, see Configurations.

[project name]:
  outputs:
    dev:
      cloud_host: https://api.dremio.cloud
      cloud_project_id: 1ab23456-78c9-01d2-de3f-456g7h890ij1
      object_storage_source: Samples
      object_storage_path: "samples.dremio.com"."Dremio University"
      dremio_space: Space1
      dremio_space_folder: Folder1.Folder2
      pat: A1BCDrE2FwgH3IJkLM4NoPqrsT5uV6WXyza7I8bcDEFgJ9hIj0Kl1MNOPq2Rstu==
      threads: 1
      type: dremio
      use_ssl: true
      user: name@company.com
  target: dev

Configurations

Configuration	Required	Default Value	Description
cloud_host	Yes	https://api.dremio.cloud	US Control Plane: https://api.dremio.cloud EU Control Plane: https://api.eu.dremio.cloud
cloud_project_id	Yes	None	The ID of the Dremio project in which to run transformations.
object_storage_source	No	$scratch	The name of the filesystem in which to create tables, materialized views, tests, and other objects. The dbt alias is datalake. This name corresponds to the name of a source in the Object Storage section of the Datasets page in Dremio:
object_storage_path	No	no_schema	The path in the filesystem in which to create objects. The default is the root level of the filesystem. The dbt alias is root_path. Nested folders in the path are separated with periods. This value corresponds to the path in this location in the Datasets page in Dremio:
dremio_space	No	@<username>	The value of the Dremio space in which to create views. The dbt alias is database. This value corresponds to the name in this location in the Spaces section of the Datasets page in Dremio:
dremio_space_folder	No	no_schema	The folder in the Dremio space in which to create views. The default is the top level in the space. The dbt alias is schema. Nested folders are separated with periods. This value corresponds to the path in this location in the Datasets page in Dremio:
pat	Yes	None	The personal access token to use for authentication. See Personal Access Tokens for instructions about obtaining a token.
threads	Yes	1	The number of threads the dbt project runs on.
type	Yes	dremio	Auto-populated when creating a Dremio project. Do not change this value.
use_ssl	Yes	true	The value must be true.
user	Yes	None	Email address used as a username in Dremio Cloud