Table: twitter_tweet - Query Twitter Tweets using SQL

Twitter is a widely used social media platform that allows users to post and interact with messages known as "tweets". The platform provides a robust API, enabling the extraction of vast amounts of public data for analysis. This includes data about tweets, users, hashtags, and more.

Table Usage Guide

The twitter_tweet table gives insights into individual tweets on the Twitter platform. As a data analyst or social media manager, you can delve into tweet-specific details through this table, including content, user, location, and associated metadata. Use it to analyze tweet patterns, user interactions, and trending topics for strategic decision-making and targeted marketing campaigns.

Important Notes

To query lists of tweets see twitter_search_recent or twitter_user_tweet instead.
The id field must be set in the where clause.

Examples

Get tweet by ID

Discover the specific content and details of a particular tweet using its unique identification number. This can be useful for understanding the context, engagement, or user behavior related to that particular tweet.

select
  *
from
  twitter_tweet
where
  id = '1373134228620214275';

select
  *
from
  twitter_tweet
where
  id = '1373134228620214275';

Schema for twitter_tweet

Name	Type	Operators	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.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- twitter

You can pass the configuration to the command with the --config argument:

steampipe_export_twitter --config '<your_config>' twitter_tweet