Reddit + Steampipe

select
  subreddit_name_prefixed,
  name,
  title,
  score,
  upvote_ratio
from
  reddit_my_post
order by
  rank;

+-------------------------+-----------+---------------------------------------+-------+--------------------+
| subreddit_name_prefixed | name      | title                                 | score | upvote_ratio       |
+-------------------------+-----------+---------------------------------------+-------+--------------------+
| r/netsec                | t3_q7llj8 | Open source automated NIST SP 800-53… | 146   | 0.949999988079071  |
| r/aws                   | t3_q1nwoz | What's your oldest S3 bucket?         | 77    | 0.949999988079071  |
| r/netsec                | t3_ot1kwy | Use SQL to query AbuseIPDB deny list… | 55    | 0.8899999856948853 |
| r/gitlab                | t3_ot0tzw | New open source tool to query GitLab… | 31    | 0.9700000286102295 |
| r/blueteamsec           | t3_q7lo6l | Open source automated NIST SP 800-53… | 25    | 0.9200000166893005 |
+-------------------------+-----------+---------------------------------------+-------+--------------------+

steampipe plugin install reddit

connection "reddit" {
  client_id     = "aoxJBaKh9W_wnNLKzJhxSw"
  client_secret = "P51-fNlprSkGcqdkQzogJ_noqcktis"
  username      = "jane"
  password      = "Pa$$w0rd"
}