CODEWITHSUNDEEP
snowflake-cloud-data-platformservicenow-rest-api
Sayantan Mandal
Sayantan Mandal

Reputation: 53

Is there a way to raise SNOW ticket as notification for query failures in snowflake?

I was going through the integration documents available for snowflake & service now. But, all documents are oddly focussed on sf consuming snow data for analytics. Didn't find anything related to creating tickets for failures at snowflake. Is it possible?

It's not about the monitoring & notification aspect of snowflake but connecting with service now and raise a ticket for query failures (tasks,sp etc.)

Any ideas?

Upvotes: 0

Views: 540

Answers (3)

JockTheKiwi
JockTheKiwi

Reputation: 3

Email is a simple way. You need to determine how your ServiceNow instance is processing emails. We implemented incident creation from Azure App Insights based on emails.

In ServiceNow find the Inbound Action you need to process the email or make one. ServiceNow provides every instance with an email account Refer to enter link description here

The instance email is usually [email protected]. If your instance url is "audi.service-now.com", the email would be "[email protected]".

For a PDI [email protected], e.g.; [email protected]

Upvotes: 0

Minh-Long Luu
Minh-Long Luu

Reputation: 2731

For the Snowpipe, we found a way to use it. We send the error message to SNS and then we can do a Lambda function to call the Rest API of ServiceNow to create a ticket.

For Task, we find that it is possible to use External Functions to notify to AWS whenever the Task fails, but we haven’t implemented it.

Upvotes: 1

Sergiu
Sergiu

Reputation: 4578

There's no functionality like that as of now. I can recommend you open an Idea for it and if enough customers want it our Product Management will review it.

Upvotes: 2

Related Questions