it turns out that after we've created 10 notification integrations, we are unable to create more and getting following error. Is it a hard limit? Is it on snowflake's or is it on azure's side? Can it be changed?
Maximum number of notification integrations in cloud AZURE exceeded.
Code:
create notification integration xxx
enabled = true
type = queue
notification_provider = azure_storage_queue
azure_storage_queue_primary_uri = 'https://xxx'
azure_tenant_id = 'xxx';
Reach out to Snowflake support. Have you created multiple queues for per storage account?