How to use dbt_utils.unique_combination_of_columns on DBT
How could anyone help me how to use this DBT command "dbt_utils.unique_combination_of_columns" I plan to test 2 different column on my DBT unfortunately (user_id & ticker_symbol) I'm encountering an error upon running dbt test. Your response is highly appreciated. Thank you so much.
Screen of my yaml file
Screenshot of my .sql
Error encountered upon running DBT test:
Solution
This dbt_utils generic test is thought to be ran on top of a model, not on a particular column, so you'd need to place it under the model name and not to a certain column.
So, instead of what you did in the screenshot, you could do the following:
# this is your schema.yml
version: 2
models:
- name: mrt_test
description: ""
tests:
- dbt_utils.unique_combination_of_columns:
combination_of_columns:
- user_id
- ticker_symbol
columns:
- name: (...)
- How do I run DBT models from a Python script or program?
- How to add a Jinja function to .sqlfluff config
- Write dbt test for positive values
- Safe selecting non-existent column in SQL (or dbt)
- Extracting ref and source tables from a dbt model
- Declare var in other macro to be used in a different macro for DBT
- Is it a good practice to use update_timestamp for incremental loading in DBT with insert_overwrite strategy?
- How can I run python code after a DBT run (or a specific model) is completed?
- datetime2 insertion in postgresql
- Manipulate string in DBT's macro with Jinja2
- dbt lineage issue with dbt build and tests
- for loop that iterates over a list using dbt
- change column names using a dbt macro
- I want to use the condition union if exists with a table referred with {{this}} in snowflake SQL
- Create a Sql Statement IN DBT macro and use the query in the dbt model
- Is changing date partitionning granularity a breaking change?
- Disable elementary from DBT CLI when running dbt test
- How to get the dependencies of a model in dbt in terms of a table
- Extract JSON array from object (redshift)
- How to replace strings in a column if exist in a list with dbt jinja?
- Set Spark configuration when running python in dbt for BigQuery
- Return specific column from Snowflake `show tables` command
- Cosmos DbtDag running model can not find environment variables used in macros
- Where to find dbt macros when wishing to edit it
- installation pip install dbt-postgres
- Disable DBT models using code or config (not commands)
- Does dbt 0.21.0 on_schema_change requires --full-refresh?
- Whats the best way to design an event table where different event items are provided each time the event updated
- azure pipeline variable to hold return value of DBT core macro
- How to label a dbt project so that I can query the INFORMATION_SCHEMA for all jobs created by this project?