WITH geocoded AS (
    SELECT 
        *,
        {{ address_to_coordinates( 'ADDRESS_LINE_ONE' ) }} AS METADATA

    FROM {{ ref('test_address__mock_data') }}

    WHERE
        ( 
            address_line_one NOT IN {{ var('mask_data_pattern') }} 
            AND
            address_line_two NOT IN {{ var('mask_data_pattern') }} 
        )
        OR
        (
            address_line_one IS NULL 
            AND
            address_line_two IS NULL
        )
)