Custom dbt Transformation Macro

₹600-1500 INR

Igangværende

Slået op 15 dage siden

₹600-1500 INR

Betales ved levering

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.

Projekt-ID: 40249851

Om projektet

1 forslag

Projekt på afstand

Aktiv 15 dage siden

Leder du efter muligheder for at tjene penge?

E-mailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@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 på 2 dage