Slack

Slack is a messaging platform for teams and organizations where they can collaborate, share ideas and information.

omniload supports Slack as a source.

URI format

The URI format for Slack is as follows:

slack://?api_key=<api-key-here>

URI parameters:

• api_key: The API key used for authentication with the Slack API.

The URI is used to connect to the Slack API for extracting data.

Setting up a Slack integration

Slack requires a few steps to set up an integration, please follow the guide dltHub has built here.

Once you complete the guide, you should have an API key with the necessary permissions as mentioned in the guide. Let’s say your API key is axb-test-564. Here’s a sample command that will copy the data from Slack into a DuckDB database:

omniload ingest --source-uri 'slack://?api_key=axb-test-564' --source-table 'channels' --dest-uri duckdb:///slack.duckdb --dest-table 'dest.channels'

The result of this command will be a table in the slack.duckdb database.

Tables

Slack source allows ingesting the following sources into separate tables:

Table	PK	Inc Key	Inc Strategy	Details
channels	id	-	replace	Retrieves information about all the channels
users	id	-	replace	Retrieves all the users
messages:chan1,chan2	ts	ts	append/merge	Retrieves messages from specified channels (e.g., general, memes). Multiple channels can be listed separated by commas
access_logs	user_id	-	append	Retrieves access logs

Use these as --source-table parameter in the omniload ingest command.