Table: reddit_subreddit_search - Query Reddit Subreddit Search using SQL

Reddit Subreddit Search is a feature within Reddit that allows you to search for subreddits based on a specified query. It provides a way to discover new communities and topics within the Reddit platform. Subreddit Search helps you stay informed about the trending topics and discussions in your areas of interest.

Table Usage Guide

The reddit_subreddit_search table provides insights into Subreddit Search within Reddit. As a data analyst, explore subreddit-specific details through this table, including subreddit names, descriptions, and associated metadata. Utilize it to uncover information about subreddits, such as those with a high number of subscribers, the most discussed topics, and the overall popularity of a subreddit.

Important Notes

You must specify the query in the where clause to query this table.

Examples

Search subreddits with query "aws"

Explore various subreddits related to 'aws' to understand their popularity based on subscriber count, allowing you to identify the most engaged communities for specific topics.

select
  rank,
  display_name_prefixed,
  title,
  subscribers
from
  reddit_subreddit_search
where
  query = 'aws'
order by
  rank;

select
  rank,
  display_name_prefixed,
  title,
  subscribers
from
  reddit_subreddit_search
where
  query = 'aws'
order by
  rank;

Schema for reddit_subreddit_search

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
query	text	=	Search query string.
rank	bigint		Rank of the subreddit among the result rows, use for sorting.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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.
username	text	=, !=, ~~, ~~, !~~, !~~	The authorized username.

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_subreddit_search