Coalesce 2022 challenge:
Are you a dbt ninja?
-- See you
{% set later = 'alligator' %}
WITH coalesce_nola AS (
SELECT
CHR(65) AS you,
COALESCE(null,'ffo','bar') AS speak,
SUBSTR('{{ later }}', -5, 4) AS dbt
)
SELECT you || speak || dbt
FROM coalesce_nola
{% set later = 'alligator' %}
WITH coalesce_nola AS (
SELECT
CHR(65) AS you,
COALESCE(null,'ffo','bar') AS speak,
SUBSTR('{{ later }}', -5, 4) AS dbt
)
SELECT you || speak || dbt
FROM coalesce_nola
