DaveFlynn

<?php

/**
 * Enhance ACF Relationship field search to include title, a specific custom field, and publish date.
 *
 * Replace 'your_relationship_field_name' with the ACF field name you're targeting.
 * Replace 'your_post_type' with the ACF CPT you are targeting.
 * Replace 'custom_field_key' with the meta_key you want to search.
 */
 

DaveFlynn

About the Author

Dave Flynn

I work at the intersection of devrel, data, and marketing - creating technical content, shaping product messaging, and building tools and dashboards that support outreach and strategy.

LinkedIn | Bluesky

DaveFlynn

Ready for collaborative dbt Data PR Review?

Recce is the data validation toolkit for data engineers and non-technical stakeholders to review and interpret data change together

Validate data modeling work, review data change, and work as a team to speed up the QA process on data project pull requests, and significantly reduce time-to-merge.

Find Out More

• Sign up for Recce Cloud Early Access

DaveFlynn

Impact validations

• The scope of impact as has been checked (no unintentional modifications)
• I have validated my modeling change (Show examples of how data change expectation was validated)
• I have checked for critical downstream models
• I have checked the data integrity of critical models (and attached holistic check results)
• I have spot checked rows from critical models against prod to ensure data consistency (examples attached)

DaveFlynn

include .env
export

# Phony targets
.PHONY: build seed test snapshot run debug clean help

# Environment variables
TARGET 	?= $(TARGET)
PROFILE ?= $(PROFILE)

DaveFlynn

	old	new
# pr	1043	128
# closed pr	34 (3.6%)	16 (12.5%)
# merged pr	1009	112
# model changed	3455	366
avg model changed	3.42	3.27
max model changed	30	29
avg merge time (seconds)	44016	292329
avg commits	15.3	9.1

DaveFlynn

Read In the Pipeline for more articles from Dave

Dave is Senior Technical Advocate for Recce, the cross-env data validation tool for dbt data projects. To understand more about Recce, or for help getting set up, get in touch at one of the links below:

• Contact Dave on LinkedIn
• Book a Calendly meeting to chat about Recce

DaveFlynn

Ready to improve your data project PR review process?

Recce is your data validation toolkit

Recce is a cross-environment data-modeling validation tool for dbt projects.

Validate your work and create an all signal, no noise PR comment by curating a list of validation checks to speed up the QA process on data project pull requests, and significantly reduce time-to-merge.

DaveFlynn

DaveFlynn

class AssertAllowedNulls(BaseAssertionType):
    def name(self):
        return "assert_allowed_nulls"

    def execute(self, context: AssertionContext, table: str, column: str, metrics: dict) -> AssertionResult:
        column_metrics = metrics.get('tables', {}).get(table, {}).get('columns', {}).get(column)
        if column_metrics is None:
            # column could not be found
            return context.result.fail('column does not exist')