Table: reddit_user_search - Query Reddit User Profiles using SQL

Reddit is a popular social media platform that allows users to discuss and vote on content that other users have submitted. It provides a platform for communities to discuss, connect, and share in an open environment, home to some of the most authentic content anywhere online. The nature of the platform allows users to remain anonymous and real-time, with the community deciding which discussions and topics get visibility.

Table Usage Guide

The reddit_user_search table provides insights into user profiles within Reddit. As a data analyst or a social media marketer, explore user-specific details through this table, including their activities, preferences, and interactions. Utilize it to uncover information about users, such as their post history, comments, and upvotes, to understand user behavior and trends.

Important Notes

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

Examples

Search users called "jane"

Discover the segments that contain users named 'Jane' on Reddit, allowing you to analyze user data and trends associated with this name. This is particularly useful for market research, user analysis, and trend prediction.

select
  *
from
  reddit_user_search
where
  query = 'jane'
order by
  rank;

select
  *
from
  reddit_user_search
where
  query = 'jane'
order by
  rank;

Schema for reddit_user_search

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
comment_karma	bigint		Karma from comments.
created_utc	text		Time when the user was created.
has_verified_email	boolean		True if the user email has been verified.
id	text		ID of the user.
is_employee	boolean		True if the user is an employee.
is_friend	boolean		True if the user is a friend.
is_suspended	boolean		True if the user has been suspended.
link_karma	bigint		Karma from links.
name	text		Name of the user.
over_18	boolean		True if the user is over 18.
query	text	=	Search query string.
rank	bigint		Rank of the user among the result rows, use for sorting.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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_user_search