Custom dbt Transformation Macro

₹600-1500 INR

Käynnissä

Julkaistu 18 päivää sitten

₹600-1500 INR

Maksettu toimituksen yhteydessä

I need a reusable dbt macro that performs a data-transformation step and plugs neatly into the models already living in my project repo. The macro must follow dbt’s best-practice conventions (Jinja style guide, ref/var usage, proper error handling) and run flawlessly when I execute dbt run + dbt test. Context • Primary purpose: data transformation (not validation or aggregation). • Existing landscape: several models and tests are in place; the macro should slot in without breaking current materializations or naming standards. What I will hand over – Read-only access to the repo and an example model where the macro should be called. – A brief schema description plus sample data so you can reproduce my environment locally. Deliverables • The fully documented macro in its own .sql file. • A sample model illustrating the call signature. • Unit tests that prove the macro behaves as intended across at least two edge cases. • An update to the README explaining setup, invocation, and expected inputs/outputs. Acceptance criteria 1. dbt run completes with zero errors or warnings. 2. All new tests pass on my end. 3. Code adheres to dbt style guidelines and lints cleanly. 4. Macro logic is clear enough that I can tweak parameters without further guidance. I’m happy to answer detailed questions about the transformation logic once you’ve reviewed the repo.

Projektin tunnus (ID): 40249851

Tietoa projektista

1 ehdotus

Etäprojekti

Aktiivinen 18 päivää sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@himantha1

Hi there! I understand that you need a robust, reusable dbt macro that slots into your existing models without disrupting your current materializations. I specialize in writing clean, modular Jinja/SQL code that follows dbt’s core philosophy: DRY (Don't Repeat Yourself). How I Will Build This • Jinja Best Practices: I will use the Jinja style guide, ensuring proper use of ref(), var(), and config() to keep the macro dynamic and environment-agnostic. • Resilient Logic: The macro will include error handling (using exceptions.raise_compiler_error) to catch schema mismatches before the model even runs. • Zero-Break Integration: I will carefully review your existing models to ensure the macro adheres to your current naming conventions and materialization strategies. • Testing-First Approach: I will deliver Unit Tests for the macro using dummy data or dbt-unit-testing to ensure edge cases (like nulls or unexpected data types) are handled perfectly. The "Clean Code" Deliverables 1. The Macro File: A well-commented .sql file in the macros/ folder. 2. Implementation Example: A sample model showing exactly how to call the macro with different parameters. 3. Validation Suite: Custom schema tests or dbt-utils tests to prove the transformation logic is flawless. 4. Documentation: Detailed updates to your [login to view URL] and [login to view URL] for auto-generated dbt docs.

₹1 300 INR 2 päivässä