In this section, we present how to integrate a Twitter account with MindsDB.
Connection
To connect a Twitter account to MindsDB, you need a Twitter developer account.
We recommend you use the Elevated access allowing you to pull 2m tweets and to avoid parameters or authentication issue error you might get sometimes. You can check this step-by-step guide describing how to apply for the Elevated access.
If you don’t already have a Twitter developer account, follow the steps in the video below to apply for one.
If you already have a Twitter developer account, you need to generate API keys following the instructions below or heading to the Twitter developer website.
Once you have all the tokens and keys, here is how to connect your Twitter account to MindsDB:
CREATE DATABASE my_twitter
WITH
ENGINE = 'twitter',
PARAMETERS = {
"bearer_token": "twitter bearer token",
"consumer_key": "twitter consumer key",
"consumer_secret": "twitter consumer key secret",
"access_token": "twitter access token",
"access_token_secret": "twitter access token secret"
};
Usage
The my_twitter database contains a table called tweets by default.
Here is how to search tweets containing mindsdb keyword:
SELECT id, created_at, author_username, text
FROM my_twitter.tweets
WHERE query = '(mindsdb OR #mindsdb) -is:retweet -is:reply'
AND created_at > '2023-02-16'
LIMIT 20;
Alternatively, you can use a Twitter native query, as below:
SELECT * FROM my_twitter (
search_recent_tweets(
query = '(mindsdb OR #mindsdb) -is:retweet -is:reply',
start_time = '2023-03-16T00:00:00.000Z',
max_results = 2
)
);
To learn more about native queries in MindsDB, visit our docs here.
Here is how to write tweets:
INSERT INTO my_twitter.tweets (reply_to_tweet_id, text)
VALUES
(1626198053446369280, 'MindsDB is great! now its super simple to build ML powered apps'),
(1626198053446369280, 'Holy!! MindsDB is the best thing they have invented for developers doing ML');
What’s next?
Check out the tutorial on how to create a Twitter chatbot to see one of the interesting applications of this integration.