# No materialization Ephemeral was found for adapter postgres

**URL:** <https://discourse.getdbt.com/t/no-materialization-ephemeral-was-found-for-adapter-postgres/4175>\
**Category:** Archive\
**Created:** [April 10, 2022, 4:28pm UTC](https://discourse.getdbt.com/t/no-materialization-ephemeral-was-found-for-adapter-postgres/4175 "2022-04-10T16:28:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hari](https://avatars.discourse-cdn.com/v4/letter/h/cdc98d/32.png) [@Hari](https://discourse.getdbt.com/u/Hari)\
**Post date:** [April 10, 2022, 4:28pm UTC](https://discourse.getdbt.com/t/no-materialization-ephemeral-was-found-for-adapter-postgres/4175/1 "2022-04-10T16:28:14Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hari](https://avatars.discourse-cdn.com/v4/letter/h/cdc98d/32.png) [@Hari](https://discourse.getdbt.com/u/Hari)\
**Post date:** [April 10, 2022, 5:56pm UTC](https://discourse.getdbt.com/t/no-materialization-ephemeral-was-found-for-adapter-postgres/4175/2 "2022-04-10T17:56:25Z")

</div>

issue resolved after changing to lower case ephemeral

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