Can someone please confirm if it is possible to create a snowflake view in Terraform with no reference table?
Here’s an example,
resource "snowflake_view" "view" {
database = "database"
schema = "schema"
name = "view"
comment = "comment"
statement = <<-SQL
SELECT 'BLUE' AS COLOR;
SQL
or_replace = true
is_secure = false
}