Slack integration

Create Slack application and obtain auth token

  • Go to https://api.slack.com/apps and login.

  • Press "Create New App" button, choose "From an app manifest".

  • Choose workspace, press "Next".

  • Choose "YAML" tab. Copy-paste settings below. Press "Next".

display_information:
  name: snowflake-monitor
  description: Monitoring of running, queued and blocked queries in Snowflake
  background_color: "#00a5e0"
features:
  bot_user:
    display_name: Snowflake Monitor
    always_online: true
oauth_config:
  scopes:
    bot:
      - chat:write
      - chat:write.public
settings:
  org_deploy_enabled: false
  socket_mode_enabled: false
  token_rotation_enabled: false

  • Press "Create".

  • Press "Install to Workspace" button, press "Allow".

  • Go to "Settings -> Install App" and copy the contents of Bot User OAuth Token field. You will need it to send notifications from Python script.

Here is a video-tutorial which might help you if you're new to Slack Apps: https://www.youtube.com/watch?v=q3SBz_eqOq0

Optionally, you may go to "Settings -> Basic Information", scroll down to "Display Information" section and upload this App Icon:

It will make notification messages look better.

Create a channel for notifications in Slack

The suggested channel name is: #snowflake-monitor

How to create a channel: https://slack.com/intl/en-gb/help/articles/201402297-Create-a-channel

Using Slack integration

This is a basic function which sends notifications to Slack:

https://github.com/littleK0i/SnowKill/blob/master/example/_utils.py#L25-L57

You may consider using official Python Slack SDK instead.

Last updated