Slack

Slack is a new way to communicate with your team. It's faster, better organised and more secure than email.

Authentication methods

OAuth (User Created)

This method uses your own Slack App to authorize access, and is the most secure method since your own OAuth credentials are used.

To create an app:

1. Visit https://api.slack.com/apps/

2. Click "Create New App"

3. Click "From an app manifest"

4. Select your workspace

5. Complete the below app manifest template and paste it in:

If you're unsure what value to for the redirect URI, the following Snowflake query will construct it for your account: select 'https://'||t.value:host::varchar||'/oauth/complete-secret' as URI from table(flatten(input => parse_json(system$allowlist()))) as t where t.value:host::varchar LIKE 'apps-api%';

{
    "display_information": {
        "name": "Omnata Sync"
    },
    "features": {
        "bot_user": {
            "display_name": "Omnata Sync",
            "always_online": false
        }
    },
    "oauth_config": {
        "redirect_urls": [
            "redirect URI of the form https://apps-api.c1.<region>.<cloud-vendor>.app.snowflake.com/oauth/complete-secret"
        ],
        "scopes": {
            "bot": [
                "chat:write",
                "users:read.email",
                "users:read"
            ]
        }
    },
    "settings": {
        "org_deploy_enabled": false,
        "socket_mode_enabled": false,
        "token_rotation_enabled": false
    }
}

6. Click Next, then Create

7. Click the "Install to Workspace" button

8. Click "Allow" on the consent screen

9. Note the Client ID and Client Secret so that you can provide them when configuring the Omnata connection
10. For each Slack channel you want to be able to include in syncs, invite the app bot like so: /invite @omnata_sync

Inbound Syncs

The following are available as inbound streams:

• conversations_list (Full Refresh only)

Outbound syncs

Supported Targets

With the Slack app, you can post a message into a designated channel for every source record created in Snowflake.

Supported Sync Strategies

• Create (as an event-based system, this is the only sensible option)