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, bodyfrom reddit_my_commentorder by created_utc desclimit 5;
select created_utc, permalink, bodyfrom reddit_my_commentorder by created_utc desclimit 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, repliesfrom reddit_my_commentorder by score desclimit 5;
select score, permalink, body, repliesfrom reddit_my_commentorder by score desclimit 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_commentgroup by subreddit_name_prefixedorder by count desc;
select subreddit_name_prefixed, count(*)from reddit_my_commentgroup by subreddit_name_prefixedorder 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, bodyfrom reddit_my_commentwhere body ilike '%docs%'order by created_utc;
select created_utc, permalink, bodyfrom reddit_my_commentwhere body like '%docs%'order by created_utc;
Schema for reddit_my_comment
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
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. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
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. | |
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_comment