Table: twitter_tweet
Get information about a public tweet.
To query lists of tweets see twitter_search_recent or twitter_user_tweet instead.
Note: The id
field must be set in the where
clause.
Examples
Get tweet by ID
select *from twitter_tweetwhere id = '1373134228620214275'
.inspect twitter_tweet
Lookup a specific tweet by ID.
Name | Type | Description |
---|---|---|
_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. |
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. |