Search the last 7 days of public tweets using the Twitter search syntax and operators.
queryfield must be set in the
- To prevent excess API quota use, results are limited to
Tweets matching a hashtag
select*fromtwitter_search_recentwherequery = '#rowscoloredglasses'
Tweets mentioning a user
select*fromtwitter_search_recentwherequery = '@steampipeio'
Tweets by a given author
select*fromtwitter_search_recentwherequery = 'from:steampipeio'
Tweets in reply to a user
select*fromtwitter_search_recentwherequery = 'to:steampipeio'
Tweets using a URL (matches expanded form inside short links)
select*fromtwitter_search_recentwherequery = 'url:steampipe.io'
Place, author, and text for tweets about the weather in Vermont
selectplace ->> 'full_name' as place,author ->> 'username' as author,textfromtwitter_search_recentwherequery = 'weather'and place ->> 'full_name' ~* ' vt$' -- regex matches 'Barre VT' etc
Tweets about weather within 10 miles of a lat/lon location
point_radius and related operators are not available with a basic ("Essential") account, see operators by product.
select*fromtwitter_search_recentwherequery = 'weather point_radius:[-105.292778 40.019444 10mi]'
Search public Tweets posted over the last 7 days.
|_ctx||jsonb||Steampipe context in JSON form, e.g. connection_name.|
|attachment_polls||jsonb||Polls attached to the Tweet.|
|attachments||jsonb||Specifies the type of attachments (if any) present in this Tweet.|
|author||jsonb||Author of the Tweet.|
|author_id||text||Unique identifier of the author of the Tweet.|
|cashtags||jsonb||List of cashtags (e.g. $TWTR) mentioned in the Tweet.|
|context_annotations||jsonb||Contains context annotations for the Tweet.|
|conversation_id||text||The Tweet ID of the original Tweet of the conversation (which includes direct replies, replies of replies).|
|created_at||timestamp with time zone||Creation time of the Tweet.|
|entities||jsonb||Contains details about text that has a special meaning in a Tweet.|
|geo||jsonb||Contains details about the location tagged by the user in this Tweet, if they specified one.|
|hashtags||jsonb||List of hashtags (e.g. #sql) mentioned in the Tweet.|
|id||text||Unique identifier of this Tweet.|
|in_reply_to_user_id||text||If this Tweet is a Reply, indicates the user ID of the parent Tweet's author.|
|in_reply_user||jsonb||User the Tweet was in reply to.|
|lang||text||Language of the Tweet, if detected by Twitter. Returned as a BCP47 language tag.|
|mentions||jsonb||List of users (e.g. steampipeio) mentioned in the Tweet.|
|mentions_obj||jsonb||Users mentioned in the Tweet.|
|place||jsonb||Place where the Tweet was created.|
|possibly_sensitive||boolean||Indicates if this Tweet contains URLs marked as sensitive, for example content suitable for mature audiences.|
|public_metrics||jsonb||Engagement metrics for the Tweet at the time of the request.|
|query||text||Query string for the exploit search.|
|quoted||text||If this Tweet is a Quote Tweet, indicates the ID of the original Tweet.|
|referenced_tweets||jsonb||Tweets referenced in this Tweet.|
|replied_to||text||If this Tweet is a Reply, indicates the ID of the Tweet it is a reply to.|
|retweeted||text||If this Tweet is a Retweet, indicates the ID of the orginal Tweet.|
|source||text||The name of the app the user Tweeted from.|
|text||text||The content of the Tweet.|
|urls||jsonb||List of URLs (e.g. https://steampipe.io) mentioned in the Tweet.|
|withheld||jsonb||Contains withholding details for withheld content.|