notification_integrations

Creates, updates, deletes, gets or lists a notification_integrations resource.

Overview

Name	notification_integrations
Type	Resource
Id	snowflake.notification_integration.notification_integrations

Fields

Name	Datatype	Description
name	string	Name of the notification.
comment	string	Comment for the notification integration.
created_on	string	Date and time when the notification was created.
enabled	boolean	Whether the notification integration is enabled.
notification_hook	object

Methods

Name	Accessible by	Required Params	Optional Params	Description
fetch_notification_integration	SELECT	name, endpoint	-	Fetch a notification integration
list_notification_integrations	SELECT	endpoint	like	List notification integrations
create_notification_integration	INSERT	data__name, data__notification_hook, endpoint	createMode	Create a notification integration
delete_notification_integration	DELETE	name, endpoint	ifExists	Delete a notification integration

Optional Parameter Details

Name	Description	Type	Default
createMode	Query parameter allowing support for different modes of resource creation. Possible values include: - errorIfExists: Throws an error if you try to create a resource that already exists. - orReplace: Automatically replaces the existing resource with the current one. - ifNotExists: Creates a new resource when an alter is requested for a non-existent resource.	string	errorIfExists
ifExists	Query parameter that specifies how to handle the request for a resource that does not exist: - true: The endpoint does not throw an error if the resource does not exist. It returns a 200 success response, but does not take any action on the resource. - false: The endpoint throws an error if the resource doesn't exist.	boolean	false
like	Query parameter to filter the command output by resource name. Uses case-insensitive pattern matching, with support for SQL wildcard characters.	string	-

SELECT examples

List notification integrations

SELECT
name,
comment,
created_on,
enabled,
notification_hook
FROM snowflake.notification_integration.notification_integrations
WHERE endpoint = '{{ endpoint }}';

INSERT example

Use the following StackQL query and manifest file to create a new notification_integrations resource.

Required Properties

/*+ create */
INSERT INTO snowflake.notification_integration.notification_integrations (
data__name,
data__enabled,
data__comment,
data__notification_hook,
endpoint
)
SELECT 
'{{ name }}',
'{{ enabled }}',
'{{ comment }}',
'{{ notification_hook }}',
'{{ endpoint }}'
;

All Properties

/*+ create */
INSERT INTO snowflake.notification_integration.notification_integrations (
data__name,
data__notification_hook,
endpoint
)
SELECT 
'{{ name }}',
'{{ notification_hook }}',
'{{ endpoint }}'
;

Manifest

- name: notification_integrations
  props:
    - name: data__name
      value: string
    - name: data__notification_hook
      value: string
    - name: endpoint
      value: string
    - name: name
      value: string
    - name: enabled
      value: boolean
    - name: comment
      value: string
    - name: notification_hook
      props:
        - name: type
          value: string

DELETE example

Deletes the specified notification_integrations resource.

/*+ delete */
DELETE FROM snowflake.notification_integration.notification_integrations
WHERE name = '{{ name }}'
AND endpoint = '{{ endpoint }}';