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. |