Skip to main content

cube_dbt

cube_dbt is the dbt integration for Cube that helps define the data model of the semantic layer on top of dbt models.

Installation

pip install cube_dbt

Usage

manifest_url = 'https://bucket.s3.amazonaws.com/manifest.json'
dbt = (
  Dbt
  .from_url(manifest_url)
  .filter(
    paths=['marts/'],
    tags=['cube'],
    names=['my_table', 'my_table_2']
  )
)
print(dbt.models)

# For use in Jinja templates:
print(dbt.model('name').as_cube())
print(dbt.model('name').as_dimensions(skip=['id']))
print(dbt.model('name').column('name').as_dimension())

Development

Run tests:

pdm run test

Preprocessing the manifest.json file

In case of a massive manifest file, it can be preprocessed for optimal performance. The cube_dbt package only reads the nodes dictionary where resource_type is model. Here's a list of all keys used by the cube_dbt package:

- nodes
  - name
  - path
  - description
  - config
    - materialized
    - tags
  - resource_type
  - database
  - schema
  - alias
  - relation_name
  - columns
    - name
    - description
    - data_type
    - meta
    - tags

Release files for cube_dbt 0.6.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for cube_dbt 0.6.3
File Size Uploaded
cube_dbt-0.6.3.tar.gz 818.1 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for cube_dbt 0.6.3
File Interpreter ABI Platform
cube_dbt-0.6.3-py3-none-any.whl Python 3 none any Details

Total release size: 825.2 kB

Release files / cube_dbt-0.6.3.tar.gz

Download URL cube_dbt-0.6.3.tar.gz
Size 818.1 kB
Tags Source
SHA-256 checksum
How to use checksums
fea8b926363eddc0a99c226716a36e426f493ce1ac94278c89d6ae18e057c374
BLAKE2b-256 checksum
How to use checksums
dea619d079000b6808ddc37ae96d41e9da749905ed284500665be11cd32c5d25
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via pdm/2.25.4 CPython/3.10.6 Darwin/24.5.0

Release files / cube_dbt-0.6.3-py3-none-any.whl

Download URL cube_dbt-0.6.3-py3-none-any.whl
Size 7.1 kB
Tags Python 3
SHA-256 checksum
How to use checksums
69c80c4252839ff6784ae9d4653763c7551628263a0927934e0ac8e38e39e4df
BLAKE2b-256 checksum
How to use checksums
600a8f3f89920c195865ae8313d4a39f0bea72589f0157ef439b6d2fad76c284
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via pdm/2.25.4 CPython/3.10.6 Darwin/24.5.0

Release history Release notifications | RSS feed

This release

0.6.3 This release

2 release files

0.6.2

2 release files

0.6.1

2 release files

0.6.0

2 release files

0.5.4

2 release files

0.5.2

2 release files

0.5.1

2 release files

0.5.0

2 release files

0.4.0

2 release files

0.3.1

2 release files

0.3.0

2 release files

0.2.2

2 release files

0.2.1

2 release files

0.2.0

2 release files

0.1.0

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page