         -- For each record: upper_bound {{ allow_gaps_operator }} the next lower_bound.
         -- Coalesce it to handle null cases for the last record.
         coalesce(
-            upper_bound <= next_lower_bound,
+            upper_bound = next_lower_bound,
             is_last_record,
             false
-        ) as upper_bound_less_than_or_equal_to_next_lower_bound
+        ) as upper_bound_equal_to_next_lower_bound
 
     from window_functions
 

    where not(
        -- THE FOLLOWING SHOULD BE TRUE --
        lower_bound_less_than_upper_bound
        and upper_bound_less_than_or_equal_to_next_lower_bound
    )
)


{% macro bigquery__get_snapshot_unique_id() -%}
    {%- do return('concat(cast(id as string), "-", first_name)') -%}
{%- endmacro %}

{#
    mostly copy+pasted from dbt_utils, but I removed some parameters and added
