Slack

Slack is a messaging program designed specifically for the workplace.

Features

Feature Name	Supported	Notes
Capture deletes		All tables
History mode
Custom data		`PROFILE_FIELD` table
Data blocking		Column level
Column hashing
Re-sync		Connection level and table level. A parent table re-sync includes all associated child tables.
API configurable		API configuration
Priority-first sync
Fivetran data models
Private networking
Authorization via API

We support the SaaS and Hybrid deployment models for the connector.

NOTE: You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.

Follow our step-by-step Slack setup guide to connect Slack with your destination using Fivetran connectors.

This schema applies to all Slack connectors created on or after November 1, 2023:

Explore Slack schema ERD

This schema applies to all Slack connectors created before November 1, 2023: ERD

We use Slack Web API's conversations.history and conversations.replies endpoints to sync the MESSAGE table. We re-import the records retrieved from the conversations.history endpoint to capture updates and deletes. We incrementally sync the records retrieved from the conversations.replies endpoint.

NOTE: For connectors created before November 1, 2023, we incrementally sync the MESSAGE_REPLY table.

We do not support Webhooks events.