Materialize Views As Tables

[norton120]

Why?

there is a dependency issue with views in a source that have access to resources not available to snowshu. example:
APPLICATION.PROD.ORDERS is a table
WAREHOUSE.ANALYSIS.ORDERS is a view of APPLICATION.PROD.ORDERS.
user snowshu has read access to the WAREHOUSE database but not the APPLICATION database.

When snowshu replicates the view it will fail in the replica, because it is a view of a dataset that does not exist :(

Def of Done

we could have a materialize_views_as_tables: True flag in the replica file. this would perform a select instead.