steampipe plugin install reddit

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.


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.

name = 'steampipeio';
name = 'steampipeio';

Schema for reddit_user

_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
comment_karmabigintKarma from comments.
created_utctextTime when the user was created.
has_verified_emailbooleanTrue if the user email has been verified.
idtextID of the user.
is_employeebooleanTrue if the user is an employee.
is_friendbooleanTrue if the user is a friend.
is_suspendedbooleanTrue if the user has been suspended.
link_karmabigintKarma from links.
nametext=Name of the user.
over_18booleanTrue if the user is over 18.


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 script:

/bin/sh -c "$(curl -fsSL" -- reddit

You can pass the configuration to the command with the --config argument:

steampipe_export_reddit --config '<your_config>' reddit_user