I am not able to run function ‘word_similarity’ from an extension “pg_trgm”:
function word_similarity(text, text) does not exist
function_is_reachable
postgres
dbt_1.4
SELECT
{% for merge_seed_column_name in merge_seed_column_name_lst%}
{% set merge_seed_column_name = merge_seed_column_name[0] %}
{% if loop.first %}
word_similarity ({{merge_seed_column_name}}, {{merge_seed_column_name_v}} )
{% endif %}
{% endfor %}
The versions:
dbt 1.4 and after till 1.7.4 with same result
Postgres version 12
pg_trgm version 1.4