Create views without database reference (Snowflake)

Archive
1

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

2

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

It’s available in 0.16.