Table: reddit_my_subscribed_subreddit - Query Reddit Subscribed Subreddits using SQL
Reddit is a network of communities where people can dive into their interests, hobbies, and passions. It allows users to subscribe to various subreddits, which are essentially topic-based communities. Each subreddit is dedicated to a specific topic, and users can participate in these communities by posting, commenting, and voting on content.
Table Usage Guide
The reddit_my_subscribed_subreddit
table provides insights into the subreddits that a user is subscribed to on Reddit. As a Reddit user or a social media analyst, explore subreddit-specific details through this table, including subreddit names, descriptions, and subscriber counts. Utilize it to uncover information about your subscriptions, such as identifying popular subreddits, analyzing the type of content in different subreddits, and understanding the demographics of subscribers.
Examples
List subscribed subreddits
Explore your Reddit subscriptions to understand the popularity and reach of your subscribed subreddits. This can help identify which communities are largest and most active, providing insight into where your interests align with larger Reddit trends.
select display_name_prefixed, subscribers, urlfrom reddit_my_subscribed_subredditorder by display_name_prefixed;
select display_name_prefixed, subscribers, urlfrom reddit_my_subscribed_subredditorder by display_name_prefixed;
Top 5 subscribed subreddits by popularity
Discover the segments that are most popular among your subscribed subreddits. This helps in identifying the top 5 subreddits you are subscribed to, based on the number of subscribers, for a better understanding of popular trends.
select display_name_prefixed, subscribers, urlfrom reddit_my_subscribed_subredditorder by subscribers desclimit 5;
select display_name_prefixed, subscribers, urlfrom reddit_my_subscribed_subredditorder by subscribers desclimit 5;
Schema for reddit_my_subscribed_subreddit
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
active_user_count | bigint | Active user count for the subreddit. | |
created_utc | timestamp with time zone | Time when the subreddit was created. | |
display_name | text | Name of the subreddit, e.g. aws. | |
display_name_prefixed | text | Prefixed name of the subreddit, e.g. /r/aws. | |
id | text | ID of the subreddit. | |
name | text | Name (full ID) of the subreddit. | |
over18 | boolean | True if the post is not safe for work (over 18). | |
public_description | text | Public description of the subreddit. | |
subreddit_type | text | Type of subreddit. | |
subscribers | bigint | Number of subscribers to the subreddit. | |
suggested_comment_sort | text | Suggested sort order for comments. | |
title | text | Title of the subreddit. | |
url | text | URL of the subreddit. | |
user_has_favorited | boolean | True if the caller has favorited the subreddit. | |
user_is_moderator | boolean | True if the caller is a moderator of the subreddit. | |
user_is_subscriber | boolean | True if the caller is a subscriber of the subreddit. |
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)" -- reddit
You can pass the configuration to the command with the --config
argument:
steampipe_export_reddit --config '<your_config>' reddit_my_subscribed_subreddit