Address Hashing in NQL

Overview

This reference provides a concise guide to using the ADDRESS_HASH User-Defined Function (UDF) in NQL to generate hash values for addresses. The ADDRESS_HASH UDF is powered by a containerized service that efficiently processes batches of rows, offering significant performance improvements over traditional external services.

Function: ADDRESS_HASH

Arguments

• address (string): The input address for which hash values are to be generated.

What It Does

The ADDRESS_HASH UDF generates a set of hash values for an input address. These hash values can be used for deduplication, similarity checks, or identity resolution in datasets.

Examples

Basic Usage

To generate hashes for a single address:

SELECT
  narrative_data_collaboration_sc39576.code.address_hash('1763 comox st, unit 3105, vancouver bc, canada, v6g 1p5') AS hashes_0,
  narrative_data_collaboration_sc39576.code.address_hash('1763 comox st, #3105 vancouver bc, canada') AS hashes_1;