Table: twitter_user_following
Query which users the specified user follows.
Note: The user_id
field must be set in the where
clause.
Examples
List the follows for a user
select *from twitter_user_followingwhere user_id = '1318177503995985921' -- @steampipeio
List follows by username
Via subselect:
select uf.id, uf.usernamefrom twitter_user_following as ufwhere uf.user_id in ( select id from twitter_user where username = 'steampipeio' )
Find all users followed by both turbothq and nathanwallace
select id, usernamefrom twitter_user_followingwhere user_id in ( select id from twitter_user where username = 'turbothq' )intersectselect id, usernamefrom twitter_user_followingwhere user_id in ( select id from twitter_user where username = 'nathanwallace' )
Find users who follow you, but you don't follow them
with account as ( select id from twitter_user where username = 'turbothq'),following as ( select id, username from twitter_user_following where user_id in ( select id from account )),followers as ( select id, username from twitter_user_follower where user_id in ( select id from account ))select usernamefrom followerswhere username not in ( select username from following )order by username
.inspect twitter_user_following
List of users the specified user ID is following.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
created_at | timestamp with time zone | The UTC datetime that the user account was created on Twitter. |
description | text | The text of this user's profile description (also known as bio), if the user provided one. |
entities | jsonb | Entities are JSON objects that provide additional information about hashtags, urls, user mentions, and cashtags associated with the description. |
id | text | The unique identifier of this user. |
location | text | The location specified in the user's profile, if the user provided one. As this is a freeform value, it may not indicate a valid location, but it may be fuzzily evaluated when performing searches with location queries. |
name | text | The name of the user, as they’ve defined it on their profile. Not necessarily a person’s name. |
pinned_tweet | jsonb | Contains withholding details for withheld content, if applicable. |
pinned_tweet_id | text | Unique identifier of this user's pinned Tweet. |
profile_image_url | text | The URL to the profile image for this user, as shown on the user's profile. |
protected | text | Indicates if this user has chosen to protect their Tweets (in other words, if this user's Tweets are private). |
public_metrics | jsonb | Contains details about activity for this user. |
url | text | The URL specified in the user's profile, if present. |
user_id | text | ID of the user who is followed by these users. |
username | text | The Twitter screen name, handle, or alias that this user identifies themselves with. Usernames are unique but subject to change. |
verified | boolean | Indicates if this user is a verified Twitter User. |
withheld | jsonb | Contains withholding details for withheld content, if applicable. |