Snowpipe Creation Error ("Integration" field for Azure) should be required.

[MavrickRody]

Guys for Azure Integration - Snowpipe

"Integration" should be a required field otherwise the creation of snowpipe fails.

[andreasportelliinfinity]

@MavrickRody I have been having issues using snowpipe with Azure. This is my template:

resource "snowflake_pipe" "pipe" {
  provider = snowflake.sys_admin
  integration = "myintegration"
  database = "mydb"
  schema   = "PUBLIC"
  name     = "mypipe"

  comment = "A pipe."


  copy_statement = "copy into \"db\".\"schema\".\"table\" from (select $1,$2,$3,$4,$5, $6, $7, $8, $9, $10, metadata$filename, metadata$file_row_number, current_timestamp  from   @db.PUBLIC.stage (file_format => TEST.PUBLIC.CSV))"
  auto_ingest    = true

}

when I run it I get: An argument named "integration" is not expected here.

if I remove integration I get: Pipe Notifications bind failure "Integration cannot be null for Azure.

have you got around to making this work? thanks

[MavrickRody]

@andreasportelliinfinity Integration should be in the terraform as well, meaning the terraform should have this already imported or created and the settings should be in the state file.

[sfc-gh-asawicki]

We are closing this issue as part of a cleanup described in announcement. If you believe that the issue is still valid in v0.89.0, please open a new ticket.