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

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
author	text	Author of the comment.
author_flair_template_id	text	ID of the flair template of the author for the comment.
author_flair_text	text	Flair text of the author for the comment.
author_fullname	text	Full name of the author for the comment.
body	text	Body of the comment.
can_gild	boolean
controversiality	bigint	Controversiality score of the comment.
created_utc	timestamp with time zone	Time when the comment was created.
edited	timestamp with time zone	Time when the comment was edited.
id	text	ID of the comment.
is_submitter	boolean	True if the comment is a spoiler.
likes	boolean	True if you've upvoted the comment. False if you've downvoted it. Otherwise null.
link_author	text
link_id	text
link_permalink	text
link_title	text
locked	boolean	True if the comment is locked.
name	text	Slug (full ID) of the comment.
num_comments	bigint
over_18	boolean	True if the comment is not safe for work (over 18).
parent_id	text	Permalink (path only) to the comment.
permalink	text	Permalink (path only) to the comment.
rank	bigint	Rank of the comment among the result rows, use for sorting.
replies	jsonb	Replies to the comment.
saved	boolean	True if the comment has been saved.
score	bigint	Score of the comment.
score_hidden	boolean	True if the score is hidden on this comment.
stickied	boolean	True if the comment has been stickied.
subreddit	text	Name of the subreddit, e.g. aws.
subreddit_id	text	ID of the subreddit.
subreddit_name_prefixed	text	Prefixed name of the subreddit, e.g. /r/aws.

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