- Categories:
Notification functions (Message Construction)
APPLICATION_JSON¶
Returns a JSON object that specifies the JSON message to use for a notification. This is a helper function that you use to construct a message object for the SYSTEM$SEND_SNOWFLAKE_NOTIFICATION stored procedure.
- See also:
Using SYSTEM$SEND_SNOWFLAKE_NOTIFICATION to send notifications to email addresses and cloud provider queues , SYSTEM$SEND_SNOWFLAKE_NOTIFICATION , TEXT_HTML , TEXT_PLAIN
Syntax¶
SNOWFLAKE.NOTIFICATION.APPLICATION_JSON( '<message>' )
Arguments¶
'message'Content of the message to send.
You do not need to escape the double quotes around strings within the message (for example, double quotes around the keys and values). The function escapes these double quotes for you.
Returns¶
A JSON-formatted string that specifies a message for the SYSTEM$SEND_SNOWFLAKE_NOTIFICATION stored procedure to send.
For example, suppose that you call the function and pass in a JSON message:
SELECT SNOWFLAKE.NOTIFICATION.APPLICATION_JSON('{"data": "hello world"}');
The function returns the following JSON-formatted string:
'{"application/json":"{\"data\": \"hello world\"}"}'
Note how the function escapes the double quotes around the keys and values in your message.