Table: reddit_my_info - Query Reddit User Information using SQL

Reddit is a social news aggregation, web content rating, and discussion website. It allows registered members to submit content to the site such as links, text posts, and images, which are then voted up or down by other members. User information on Reddit includes personal attributes and preferences, providing insights into user activity and behavior.

Table Usage Guide

The reddit_my_info table provides insights into user information on Reddit. As a data analyst or social media manager, explore user-specific details through this table, including personal attributes and preferences. Utilize it to uncover information about user activity and behavior, such as content submission, voting patterns, and interaction with other members.

Examples

Search for the user "steampipeio"

Explore which Reddit users have the username 'steampipeio'. This is useful for identifying specific users in the Reddit community for potential engagement or analysis.

select
  *
from
  reddit_user_search
where
  query = 'steampipeio';

select
  *
from
  reddit_my_info;

Schema for reddit_my_info

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.
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_my_info