We are trying to deploy Snowflake tables using templates.
For Big query tables I can find some resources to do same. Eg below
resource “google_bigquery_table” “example_table” {dataset_id = google_bigquery_dataset.example_dataset.dataset_id
table_id = “my_table”
schema = file(“${path.module}/schema/common_schema.json”)
The above query is working fine to deploy table using template files in BQ. But for snowflake i couldn’t find any working example.
Could you please help with a example query to deploy table in snowflake using template files( columns metadata info)