mindsdb_slack
and channels
table automatically.
Here is how to retrieve the 10 messages after specific timestamp:
channel-name
in the WHERE
clause to the channel where, you added the bot in your Slack Workspace.gpt_model
represents our GPT-4 Model.
--
from api_key
argument.prompt_template
where we tell the GPT model, how to respond to the questions asked by the user, feel free to change any values passed in the columns, from our example, {{messages}}
, will be replaced by the WHERE
clause provided in the query. Let’s see how it works:
whizfizz_model
with a prompt template that gives GPT a wild personality that eludes a playful and magical aura. Imagine scientific knowledge with whimsical storytelling to create a unique and enchanting experience. We’ll call him WhizFizz:
channels
table. This table can be used to search for channels
, messages
, and timestamps
, as well as to post messages
into slack channels. These functionalities can also be done by using Slack API or Webhooks.
Let’s query the user’s question and see how our GPT model responds to it, by joining the model with the channels
table:
CREATE JOB
that means the query which we will give, will execute after some interval. Let’s schedule a job every hour. The job will do the following:
jobs
and jobs_history
, we can use the following: