No materialization Ephemeral was found for adapter postgres

Archive
1

I’m trying to create Ephemeral model. I use postgres database.
I got below error. Please help to resolve the error

No materialization ‘Ephemeral’ was found for adapter postgres! (searched types ‘default’ and ‘postgres’)

I was table to create view and table model but got above error for Ephemeral. My code is

{{ config(
materialized=‘Ephemeral’
)
}}

WITH RECURSIVE test_model AS (
SELECT 1
Union all
select 2
)

SELECT
*
FROM
test_model

2

issue resolved after changing to lower case ephemeral

{{ config(
materialized=‘ephemeral’
)
}}

1 Like