steampipe plugin install reddit

Table: reddit_my_comment - Query Reddit My Comments using SQL

Reddit is a vast network of communities that are created, run, and populated by its users. Each user has the ability to comment on posts, providing their own insights, information, or humor. These comments become a part of the user's activity history and can be queried for analysis or review.

Table Usage Guide

The reddit_my_comment table provides insights into a user's own comments within Reddit. As a data analyst, explore comment-specific details through this table, including the text, score, and associated metadata. Utilize it to uncover information about your comments, such as those with high engagement, the sentiment of your comments, and the overall activity pattern.

Examples

5 most recent comments

Gain insights into your recent activity on Reddit by identifying the five most recent comments you've made. This can help you track your interactions and discussions on the platform.

select
created_utc,
permalink,
body
from
reddit_my_comment
order by
created_utc desc
limit
5;
select
created_utc,
permalink,
body
from
reddit_my_comment
order by
created_utc desc
limit
5;

Top 5 comments by score

Explore the most popular comments on your Reddit account, ranked by score. This can provide insight into which comments resonated most with other users, potentially informing future engagement strategies.

select
score,
permalink,
body,
replies
from
reddit_my_comment
order by
score desc
limit
5;
select
score,
permalink,
body,
replies
from
reddit_my_comment
order by
score desc
limit
5;

Comments by subreddit

Explore which subreddits have the most user comments to understand where the most active discussions are taking place. This can help identify popular topics and trends within specific online communities.

select
subreddit_name_prefixed,
count(*)
from
reddit_my_comment
group by
subreddit_name_prefixed
order by
count desc;
select
subreddit_name_prefixed,
count(*)
from
reddit_my_comment
group by
subreddit_name_prefixed
order by
count(*) desc;

Comments containing the word "docs"

Explore comments that include the term 'docs', organized by the date they were created. This can help identify discussions or questions related to documentation, potentially highlighting areas needing improvement or clarification.

select
created_utc,
permalink,
body
from
reddit_my_comment
where
body ilike '%docs%'
order by
created_utc;
select
created_utc,
permalink,
body
from
reddit_my_comment
where
body like '%docs%'
order by
created_utc;

Schema for reddit_my_comment

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
authortextAuthor of the comment.
author_flair_template_idtextID of the flair template of the author for the comment.
author_flair_texttextFlair text of the author for the comment.
author_fullnametextFull name of the author for the comment.
bodytextBody of the comment.
can_gildboolean
controversialitybigintControversiality score of the comment.
created_utctimestamp with time zoneTime when the comment was created.
editedtimestamp with time zoneTime when the comment was edited.
idtextID of the comment.
is_submitterbooleanTrue if the comment is a spoiler.
likesbooleanTrue if you've upvoted the comment. False if you've downvoted it. Otherwise null.
link_authortext
link_idtext
link_permalinktext
link_titletext
lockedbooleanTrue if the comment is locked.
nametextSlug (full ID) of the comment.
num_commentsbigint
over_18booleanTrue if the comment is not safe for work (over 18).
parent_idtextPermalink (path only) to the comment.
permalinktextPermalink (path only) to the comment.
rankbigintRank of the comment among the result rows, use for sorting.
repliesjsonbReplies to the comment.
savedbooleanTrue if the comment has been saved.
scorebigintScore of the comment.
score_hiddenbooleanTrue if the score is hidden on this comment.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
stickiedbooleanTrue if the comment has been stickied.
subreddittextName of the subreddit, e.g. aws.
subreddit_idtextID of the subreddit.
subreddit_name_prefixedtextPrefixed name of the subreddit, e.g. /r/aws.
usernametext=, !=, ~~, ~~*, !~~, !~~*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_comment