meltanolabs/dbt-kustomer

Kustomer Meltano tap data transformation for dbt

This package is designed to work alongside the Kustomer Meltano tap to transform the data into an easy-to-use format.

Supported warehouses:

• Snowflake
• Bigquery
• PostgreSQL
• Redshift

Installation and use

1. Include the following package version in your packages.yml file. Check dbt Hub for the latest version to use.

packages:
    - package: meltano/kustomer # TBC
      version: 0.1.0 # TBC

2. Install the package by running dbt deps

3. In your dbt_project.yml file, include the location where the tap data is expected to load from:

vars:
  kustomer_schema: your_database_schema # By default this is `tap_kustomer`

4. Choose which schemas you want to build the tables in by including this in your dbt_project.yml file:

models:
  dbt_kustomer:
    marts:
      +schema: your_marts_schema # By default this is `kustomer`
    staging:
      +schema: your_staging_schema # By default this is `stg_kustomer`

5. Build the tables by running

dbt run --select package:dbt_kustomer

Tables

These are the tables that will be built with this project.

TODO - Add ERD of tables once all created

Contributing

Want to get involved? Please do! Feel free to create your own fork and create PRs with updates. If you aren't sure how to get started, then please reach out to one of the maintainers, and we'd be happy to help.

Spot something amiss? Please create an issue on GitHub.

dbt-kustomer's Issues

Remove `target.type` references

Similar comment to MeltanoLabs/dbt-klaviyo#5

I saw a few target type references in this repo. It sounds like these were used during testing or arent needed in the final package. I'm not sure if theres more or not but heres one I found https://github.com/brooklyn-data/dbt-kustomer/blob/a0f77f06eeb6b25c2279d76527f1c583bd1608bc/models/staging/_sources.yml#L5.

Add a README to the repo

Hey @jared-rimmer @glsdown! This is looking great, just one request to add a README to the repo with some basic info.

I see https://github.com/fivetran/dbt_klaviyo/blob/main/README.md and https://github.com/fivetran/dbt_klaviyo_source/blob/main/README.md. I'm not necessarily requesting that level of detail but enough for someone to know what the repo is for and how to use it would be great.