zuora_assert_slug_names.sql 342 Bytes
Newer Older
emilie's avatar
emilie committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14
-- Validates that the slugify function is properly maintaining unique subscription names

WITH slugs AS (

    SELECT
      count(DISTINCT subscription_name)         AS original_name,
      count(DISTINCT subscription_name_slugify) AS slug_name
    FROM {{ ref("zuora_subscription") }}

)

SELECT *
FROM slugs
WHERE original_name != slug_name