Table: reddit_user - Query Reddit User using SQL

Reddit is a social news aggregation, web content rating, and discussion website. Users register on the platform and then participate in various communities, known as 'subreddits'. These users can post content, comment, and vote on other user's posts.

Table Usage Guide

The reddit_user table provides insights into user profiles within Reddit. As a data analyst, explore user-specific details through this table, including their id, name, and created timestamp. Utilize it to uncover information about users, such as their activity patterns, engagement levels, and overall contribution to the platform.

Important Notes

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

Examples

Get a user

Explore which Reddit user is associated with the username 'steampipeio'. This can help in identifying the user's activity and interactions on the platform.

select
  *
from
  reddit_user
where
  name = 'steampipeio';

select
  *
from
  reddit_user
where
  name = 'steampipeio';

Schema for reddit_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
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.

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