Slack + Snowflake

Slack + Snowflake integrations

Execute sql in Snowflake for every new message posted to a Slack channel

With this workflow, every time a new message is posted to a channel in Slack, it will initiate an SQL command in Snowflake. This seamless integration lets you quickly manage and analyze your team's communication data, without needing any manual data input or exports. Increase your productivity by having all your essential data readily available in your Snowflake environment each time a Slack conversation happens.

When this happens...
New Message Posted to ChannelTriggers when a new message is posted to a specific #channel you choose.
TriggerInstant
automatically do this!
Execute SQLExecute SQL and output resulting rows of data.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Slack and Snowflake

Discover other triggers and actions you can use with Slack and Snowflake

- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It
- Channel
  Required
- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It
- Channel
- User Name
- Shared
Trigger
Instant
Try It
- Search Query
  Required
- Optimized data
Trigger
Polling
Try It
- Channel ID
- Reaction
- Member ID
- Message Author ID
Trigger
Instant
Try It

- Zap Identifier
- Access type
Trigger
Instant
Try It
New User
Triggers when a new Slack user is created / first joins your org.
Trigger
Instant
Try It

- Text
  Required
- Remind when?
  Required
- Remind who?
Action
Write
- Conversation ID
  Required
- Scheduled As
  Required
- Scheduled Message ID
  Required
Action
Write
- Channel
  Required
- Add Zapier app to channel automatically?
- Message Text
  Required
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- File
- Thread
- Send Channel Message?
- Zap_id
Action
Write
- Allowed_delete_copy
- Conversation ID
  Required
- Message TS (ID)
  Required
- Posted By
Action
Write
- Canvas ID
  Required
- Operation
  Required
Action
Write
- Channel Name
  Required
Action
Write
- Status_copy
- Approval request message
  Required
- Send message as
  Required
- Approval type
  Required
- Zap_id
- Include a link to this Zap?
- Approve button URL
- Approve button label
- Add decline button
- Add details button
- Require confirmation
Action
Write
- First Name
- Last Name
- Title
- Email
- Display Name
- User
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
Get Message by Timestamp
This action retrieves a specific message from a conversation history in Slack using the message's timestamp.
Action
Write
Retrieve Thread Messages
This action retrieves all the messages sent to a specific thread in a selected channel.
Action
Write
Create Private Channel
This action creates a private channel in Slack.
Action
Write
- Conversation ID
  Required
Action
Search
- Conversation ID
  Required
- Message ID (ts)
  Required
Action
Search
- Conversation ID
  Required
- Message TS (ID)
  Required
Action
Search
- Email
  Required
- Return Raw Results?
Action
Search
- Full Name
  Required
- Return Raw Results?
Action
Search
- The table to look for new columns on.
  Required
Trigger
Polling
Try It
New Table
Triggers when a new table is created.
Trigger
Polling
Try It
- Table
  Required
- Columns to Return
- Updated Date Column
  Required
- Primary Key
Trigger
Polling
Try It
- Disclaimer
- Table
  Required
- Primary Key Column
  Required
- Primary Key Values
  Required
Action
Write
- Table
  Required
- Primary Key Column
  Required
- Primary Key Values
  Required
- Column Name
  Required
Action
Write

New Channel
Triggers when a new #channel is created.
Trigger
Instant
Try It
- Include_alias
Trigger
Instant
Try It
- Username
- Highlight Word
- Trigger for Bot Messages?
- Only Public Channels?
Trigger
Instant
Try It
- Channel
  Required
Trigger
Instant
Try It
- Channel
  Required
- Trigger for Bot Messages?
Trigger
Instant
Try It
New Saved Message
Triggers when you save a message.
Trigger
Instant
Try It
- Channel
  Required
- Message
  Required
- Reaction
  Required
Action
Write
- Conversation ID
  Required
Action
Write
- Channel
  Required
- Users
  Required
Action
Write
- Title
- Content
- Channel ID
Action
Write
- Send Multi Message
- Message Text
  Required
- Send as a bot?
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap_id
Action
Write
- Allowed_edit_copy
- Conversation ID
  Required
- Message TS (ID)
  Required
- Posted By
- Content Type
- Reply Broadcast
Action
Write
- Channel
  Required
- Add Zapier app to channel automatically?
- Message Text
  Required
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap_id
- File
- Thread
- Send Channel Message?
Action
Write
- Channel
  Required
- Topic
  Required
- Topic set by
Action
Write
- Status Text
- Status Emoji
- Expiration Time
Action
Write
Remove User from Channel
This action removes a specified user from a specified channel in Slack.
Action
Write
Edit Message
This action updates a specific message sent by the same Authenticated user on Slack. You need to provide the Channel ID, the Timestamp of the message to be edited, and the new text for the message.
Action
Write
Find Public Channel
This action will find a public channel in Slack using either the channel's ID or name.
Action
Write
Delete Message
This action deletes an existing message in a specific channel on Slack. You need to provide the channel ID and the message timestamp as inputs.
Action
Write
- Conversation ID
  Required
Action
Search
- Conversation ID
  Required
- Message ID (ts)
  Required
Action
Search
- Search Query
  Required
- Sort By
- Sort Direction
- Include Bot Messages in Search Results?
Action
Search
- ID
  Required
- Return Raw Results?
Action
Search
- Username
  Required
- Return Raw Results?
Action
Search
- SQL Statement
  Required
- Primary Key
Trigger
Polling
Try It
New View
Triggers when a new view is created (from yesterday onwards).
Trigger
Polling
Try It
- Table
  Required
- Column Name
  Required
Action
Write
- SQL Statement
  Required
Action
Write
- Table
  Required
- Column Name
- Where Clause
  Required
Action
Search

About Slack

Slack is a platform for team communication: everything in one place, instantly searchable, available wherever you go. Offering instant messaging, document sharing and knowledge search for modern teams.

Learn moreLearn moreHelpHelp

Related categories

Team Chat

Similar apps

Chatwork

Team Chat

Microsoft Teams

Microsoft, Team Chat

Twist

Team Chat

About Snowflake

Snowflake allows corporate users to store and analyze data using cloud-based hardware and software.

Learn moreLearn moreHelpHelp

Related categories

Databases

Premium

Related Zap Templates

Send private channel messages in Slack for new rows in Snowflake