tf-snowflake-s3-backups-stage.tf

resource "snowflake_stage" "snowflake_s3_backup" {
  provider    = snowflake.account_admin
  name        = "SNOWFLAKE_S3_BACKUP"
  url         = "s3://${aws_s3_bucket.snowflake_backups_bucket.bucket}/"
  database    = snowflake_database.sandbox.name
  schema      = snowflake_schema.sandbox_tools.name
  file_format = "TYPE=CSV COMPRESSION=GZIP FIELD_OPTIONALLY_ENCLOSED_BY= '\"' SKIP_HEADER=1"
  storage_integration = snowflake_storage_integration.snowflake_s3_backup.name
}

resource "snowflake_stage_grant" "snowflake_s3_backup" {
  provider      = snowflake.security_admin
  database_name = snowflake_stage.snowflake_s3_backup.database
  schema_name   = snowflake_stage.snowflake_s3_backup.schema
  roles         = [
    snowflake_role.sandbox_rw.name,
  ]
  privilege     = "USAGE"
  stage_name    = snowflake_stage.snowflake_s3_backup.name
}