Tweets

Create, delete, and query status updates and tweets from the authenticated user.

Table Specific Information

Select

Tweets posted on Twitter will appear here. Tweets may come from the authenticated user's home page, they may be searched for, or they may come from a specific user or list. Note that some columns will always be null unless the SearchTerms pseudo column is specified.

By default, Tweets will return tweets from the authenticated user's home page. By specifying SearchTerms, tweets that match the terms used in the search will return. Valid search terms may be found under the topic "Standard Search Operators", located here: https://developer.twitter.com/en/docs/tweets/search/guides/standard-operators.

Note:SearchTerms may not be used with Screen_Name, User_Id, List_Id, Slug, Owner_User_Id, or Owner_Screen_Name.

The Screen_Name and User_Id pseudo columns can be used to return tweets made by the specified user. Alternatively, use the From_User_Name and From_User_Id columns to do the same thing.

The List_Id pseudo column may be specified to return tweets made in a specific list. Alternatively, the list may be specified using the Slug and either Owner_User_Id or Owner_Screen_Name.

The Min_Id and Max_Id pseudo columns may be used to narrow down a range of tweets to return, or to return only recent tweets. Ids are created in increasing numerical order on Twitter. Specifying a Min_Id returns only results with a greater Id or tweets that were created more recently than the specified one. Setting a Max_Id will return only tweets that are older than the creation date of the specified Id. Note that while these values must be valid, non-negative numbers, they do not have to be Ids that exist.

Full Archive and 30-day Searches

By default, Twitter only supports returning Tweets from searches that are up to 7 days old. However, customers with premium accounts may retrieve tweets older than this by executing either a 30-day or full archive search.

The EnvType and DevEnvironment pseudo columns may be used to query Premium Search APIs. EnvType specifies the environment type. It can take one of 30day or fullarchive values. The default value is 30day. The DevEnvironment is required in order to query the Premium Search API and must be set to the value of the dev environment label, created in your Twitter Developer Account. You should use a Premium or Enterprise app in your OAuth connection properties to use the feature. A SearchTerms value must be specified in order to use this feature.

Insert

In order to insert a tweet, simply specify the text of the tweet in the INSERT command. For example:

INSERT INTO Tweets (Text) VALUES ('Hello World')

In order to insert a tweet with media, specify the text of the tweet and the media file paths MediaFilePath for every media file in the INSERT command.You may include up to 4 photos or 1 animated GIF or 1 video in a Tweet. For example:

INSERT INTO Tweets (Text, MediaFilePath) VALUES ('Hello World','C:\\myfile.jpg,C:\\myfile2.jpg')

If you already have media ids you can insert them in a tweet by providing media ids MediaId of every media, in INSERT command. For example:

INSERT INTO Tweets (Text, MediaId) VALUES ('Hello World','123456789,123456789')

In order to retweet an existing tweet, specify the Id column when inserting the tweet. For example:

INSERT INTO Tweets (Id) VALUES ('123456789')

Columns


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The Id of the status update or tweet. Set this value when inserting to retweet an existing tweet.
IDLong	String	False	The long type Id of the status update or tweet.
SearchTerms	String	False	The SearchTerms to search against. This cannot be used with the Screen_Name or User_Id inputs. For more information on using the advanced query operators, see the Twitter API documentation here: https://dev.twitter.com/docs/using-search. Roughly 1500 results can be returned using the SearchTerms.
Created_At	Datetime	True	When the tweet was made.
Text	String	False	The text of the tweet.
Lang	String	True	Language code the tweet was made in.
Source	String	True	Source of the tweet.
Favorited	Boolean	True	Boolean indicating if this tweet has been favorited.
Favorite_Count	Integer	True	The approximate number of times this tweet has been favorited.
Retweeted	Boolean	True	Boolean indicating if this tweet has been retweeted.
Retweet_Count	Integer	True	The number of times the tweet has been retweeted.
Retweeted_Status_Id	String	True	Id of the tweet which was retweeted by this one. Empty if the current tweet is not a retweet.
Truncated	Boolean	True	Boolean indicating if this tweet has been truncated.
Filter_Level	String	True	Indicates the maximum value of the Filter_Level parameter that can be used and still stream this tweet.
Possibly_Sensitive	String	True	This field is available only when a tweet contains a link. The meaning of the field does not pertain to the tweet content itself, but instead it is an indicator that the URL contained in the tweet may contain content or media identified as sensitive content.
Withheld_Copyright	Boolean	True	When present and set to true, indicates that this piece of content has been withheld due to a DMCA complaint.
Withheld_Scope	String	True	When present, indicates whether the content being withheld is the status or a user.
Withheld_In_Countries	String	True	A list of uppercase, two-letter country codes this content is withheld from.
Contributors	String	True	An XML collection of user objects (usually only one) indicating users who contributed to the authorship of the tweet, on behalf of the official tweet author.
Coordinates_Coordinates	String	True	The geographic coordinates of this tweet (longitude first, then latitude).
Coordinates_Type	String	True	The type of coordinate, if applicable.
Place_Full_Name	String	True	The full name of the location of this tweet (city and state).
Place_Country	String	True	The country of origin of this tweet.
Current_User_Retweet_Id	String	True	Details the tweet Id of the authenticated user's own retweet (if it exists) of this tweet.
Scopes	String	True	A set of key-value pairs indicating the intended contextual delivery of the containing tweet. Currently used by Twitter's promoted products.
In_Reply_To_Status_Id	String	True	Represents the Id of the original status if this tweet is in reply to another.
From_User_Id	String	True	Id of the user who made the tweet. Use this in the WHERE clause to get tweets for the specified user.
From_User_Screen_Name	String	True	Screen name of the user who made the tweet. Use this in the WHERE clause to get tweets for the specified user.
From_User_Name	String	True	Name of the user who made the tweet.
From_User_Location	String	True	Location of the user who made the tweet.
From_User_Profile_URL	String	True	URL to the user who made the tweet. This is not returned when a SearchTerms is specified.
From_User_Profile_Image_Url	String	True	URL to the profile image for the from user.
To_User_Id	String	True	Id of the user who made the tweet. Use this in the WHERE clause to get tweets for the specified user.
To_User_Screen_Name	String	True	Screen name of the user who made the tweet.
User_Mentions	String	True	Mentions of other users in the tweet, returned as an XML aggregate.
URLs	String	True	URLs in the tweet, returned as an XML aggregate. If SearchTerms is specified, set Include_Entities=true to retrieve URLs.
Hashtags	String	True	Hashtags in the tweet, returned as an XML aggregate. If SearchTerms is specified, set Include_Entities=true to retrieve Hashtags.
Media	String	True	Media in the tweet, returned as an XML aggregate. If SearchTerms is specified, set Include_Entities=true to retrieve Media.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
NextPageToken	String	An identifier to retrieve the next page of results. Specify only if an error occurs during the original request. Make sure any criteria specified in the original request are still specified when using the NextPageToken.
Min_ID	String	Specifies the lowest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only tweets that are equal to or newer than the creation date of the specified Id will be returned. The Min_Id must be a valid number but does not need to be a valid tweet Id.
Max_ID	String	Specifies the highest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only tweets that are equal to or older than the creation date of the specified Id will be returned. The Max_Id must be a valid number but does not need to be a valid tweet Id.
Include_Entities	Boolean	Boolean indicating whether or not to include entities such as URLs, hashtags, and user mentions in the response. The default value is false.
Include_Retweets	Boolean	Boolean indicating whether or not to include retweets in the result set. Only useful when no filters are specified (listing own tweets), From_User_Id, From_User_Screen_Name are specified (listing a user's tweets) or when List_Id is specified (listing the tweets from a list of User ids). Has no effect when used with SearchTerms. By default twitter includes retweets. The default value is true.
Result_Type	String	Indicates the type of results to return when using a SearchTerms. Currently Twitter has only popular and recent results. The allowed values are popular, recent.
List_Id	String	Used to specify the list Id to retrieve tweets from. This value does not work with SearchTerms, Screen_Name, or User_Id.
Slug	String	Alternative method of specifying a list. Use this in with an Owner_User_Id and Owner_Screen_Name to specify a list without a List_Id.
Owner_User_Id	String	Alternative method of specifying a list. Use this with a Slug to specify a list without the list Id.
Owner_Screen_Name	String	Alternative method of specifying a list. Use this with a Slug to specify a list without the List_Id.
Geocode	String	If this parameter is used with a SearchTerms, the query will return tweets from the specified geographical location. The geocode is specified in this manner: Lat,Long,Radius. For example: 37.781157,-122.398720,25mi
RetweetId	String	When making a new tweet, specify this value to retweet the specified tweet.
MediaId	String	A comma-separated value of media Ids to associate with the tweet. You may include up to 4 photos or 1 animated GIF or 1 video in a tweet.
MediaFilePath	String	A comma-separated value of media file paths to associate with the tweet. You may include up to 4 photos or 1 animated GIF or 1 video in a tweet.
EnvType	String	The environment type you want to use. The allowed values are 30day, fullarchive. The default value is 30day.
DevEnvironment	String	To begin using the new Premium APIs, you need to setup one or more dev environments for the endpoint and connect it to an app.