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	Description
fetch_notification_integration	SELECT	name, endpoint	Fetch a notification integration
list_notification_integrations	SELECT	endpoint	List notification integrations
create_notification_integration	INSERT	data__name, data__notification_hook, endpoint	Create a notification integration
delete_notification_integration	DELETE	name, endpoint	Delete a notification integration

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 }}';