# Create views without database reference (Snowflake)

**URL:** <https://discourse.getdbt.com/t/create-views-without-database-reference-snowflake/1006>\
**Category:** Archive\
**Created:** [March 31, 2020, 6:10am UTC](https://discourse.getdbt.com/t/create-views-without-database-reference-snowflake/1006 "2020-03-31T06:10:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dan.gooden](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@dan.gooden](https://discourse.getdbt.com/u/dan.gooden)\
**Post date:** [March 31, 2020, 6:10am UTC](https://discourse.getdbt.com/t/create-views-without-database-reference-snowflake/1006/1 "2020-03-31T06:10:09Z")

</div>

Hi! Does anyone know how to have views created without fully referencing the database name? This will allow the contextual database to be used, and more easily enable us to clone databases and views.

e.g. rather than

create view as select \* from production.myschema.tablename

we would prefer…

create view as select \* from myschema.tablename

---

<div class="post-metadata">

**Author:** ![dan.gooden](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@dan.gooden](https://discourse.getdbt.com/u/dan.gooden)\
**Post date:** [March 31, 2020, 10:30pm UTC](https://discourse.getdbt.com/t/create-views-without-database-reference-snowflake/1006/2 "2020-03-31T22:30:29Z")

</div>

Have discovered that someone has done this work recently. Thank you!

It’s available in 0.16.

> <https://github.com/fishtown-analytics/dbt/pull/2028>