Skip to content
Book a demoStart free
Connectors

Reddit connector

Set up the Reddit connector in Kaivo: authentication, configuration, the 6 BigQuery tables it syncs, and answers to common questions.

Reddit connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Reddit data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

Sync your Reddit data into BigQuery with Kaivo to monitor mentions and subreddit activity relevant to your brand.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Reddit account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key

When you set up the connector, you provide:

Field Description
Query
Search query for posts and subreddits.

| | Include over 18 flag |

Include NSFW (over 18) content in results.

| | Exact |

Match the search query exactly, reducing unrelated results.

| | Subreddits |

List of subreddits to explore.

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 6 tables from Reddit into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

message_inbox (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
dist FLOAT64
geo_filter STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • message_inbox__children (4 columns)
search (1012 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
data__allow_live_comments BOOL
data__archived BOOL
data__author STRING
data__author_cakeday BOOL
data__author_flair_background_color STRING
data__author_flair_css_class STRING
data__author_flair_template_id STRING
data__author_flair_text STRING
data__author_flair_text_color STRING
data__author_flair_type STRING
data__author_fullname STRING
data__author_is_blocked BOOL
data__author_patreon_flair BOOL
data__author_premium BOOL
data__can_gild BOOL
data__can_mod_post BOOL
data__clicked BOOL
data__contest_mode BOOL
data__created FLOAT64
data__created_utc FLOAT64
data__crosspost_parent STRING
data__domain STRING
data__downs FLOAT64
data__edited FLOAT64
data__gilded FLOAT64
data__hidden BOOL
data__hide_score BOOL
data__id STRING
data__is_created_from_ads_ui BOOL
data__is_crosspostable BOOL
data__is_gallery BOOL
data__is_meta BOOL
data__is_original_content BOOL
data__is_reddit_media_domain BOOL
data__is_robot_indexable BOOL
data__is_self BOOL
data__is_video BOOL
data__link_flair_background_color STRING
data__link_flair_css_class STRING
data__link_flair_template_id STRING
data__link_flair_text STRING
data__link_flair_text_color STRING
data__link_flair_type STRING
data__locked BOOL
data__media__type STRING
data__media__oembed__version STRING
data__media__oembed__type STRING
data__media__oembed__author_name STRING
data__media__oembed__author_url STRING
data__media__oembed__height FLOAT64
data__media__oembed__html STRING
data__media__oembed__provider_name STRING
data__media__oembed__provider_url STRING
data__media__oembed__thumbnail_height FLOAT64
data__media__oembed__thumbnail_url STRING
data__media__oembed__thumbnail_width FLOAT64
data__media__oembed__title STRING
data__media__oembed__width FLOAT64
data__media__reddit_video__bitrate_kbps FLOAT64
… and 952 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • search__data__all_awardings (4 columns)
  • search__data__author_flair_richtext (7 columns)
  • search__data__awarders (4 columns)
  • search__data__content_categories (4 columns)
  • search__data__crosspost_parent_list (94 columns)
  • search__data__crosspost_parent_list__all_awardings (4 columns)
  • search__data__crosspost_parent_list__author_flair_richtext (4 columns)
  • search__data__crosspost_parent_list__awarders (4 columns)
  • search__data__crosspost_parent_list__link_flair_richtext (4 columns)
  • search__data__crosspost_parent_list__mod_reports (4 columns)
  • search__data__crosspost_parent_list__treatment_tags (4 columns)
  • search__data__crosspost_parent_list__user_reports (4 columns)
  • search__data__gallery_data__items (7 columns)
  • search__data__link_flair_richtext (7 columns)
  • search__data__media_metadata___011yw4x5994d1__p (6 columns)
  • search__data__media_metadata___03ns5ofn0nlc1__p (6 columns)
  • search__data__media_metadata___07y16xdyz8ua1__p (6 columns)
  • search__data__media_metadata___09z3xsejvh2c1__p (6 columns)
  • search__data__media_metadata___0y3w4tr81nlc1__p (6 columns)
  • search__data__media_metadata___1p3eyw5hbadd1__p (6 columns)
  • search__data__media_metadata___218onixgbadd1__p (6 columns)
  • search__data__media_metadata___22ykvqgsk8ab1__p (6 columns)
  • search__data__media_metadata___33v7vwb2nq6d1__p (6 columns)
  • search__data__media_metadata___38rmo53tpzkc1__p (6 columns)
  • search__data__media_metadata___3e8h1d0l6s6b1__p (6 columns)
  • search__data__media_metadata___3ia6p53tpzkc1__p (6 columns)
  • search__data__media_metadata___3p9pq3o9wwsc1__p (6 columns)
  • search__data__media_metadata___49rq7lkgbadd1__p (6 columns)
  • search__data__media_metadata___4ap62sgsk8ab1__p (6 columns)
  • search__data__media_metadata___4nkps2o9wwsc1__p (6 columns)
  • search__data__media_metadata___4qqpfydyz8ua1__p (6 columns)
  • search__data__media_metadata___4v69gd6byrjc1__p (6 columns)
  • search__data__media_metadata___5262nwdd2uac1__p (6 columns)
  • search__data__media_metadata___57ps4qggbadd1__p (6 columns)
  • search__data__media_metadata___5o5h0e0l6s6b1__p (6 columns)
  • search__data__media_metadata___5uh8n0o9wwsc1__p (6 columns)
  • search__data__media_metadata___636xwzb2nq6d1__p (6 columns)
  • search__data__media_metadata___64kdciqgbadd1__p (6 columns)
  • search__data__media_metadata___67d62rxthyoc1__p (6 columns)
  • search__data__media_metadata___74f5953tpzkc1__p (6 columns)
  • search__data__media_metadata___7l36mp2hbadd1__p (6 columns)
  • search__data__media_metadata___7o22ed0l6s6b1__p (6 columns)
  • search__data__media_metadata___7s9bqwaovsbd1__p (6 columns)
  • search__data__media_metadata___7us53p6r0nlc1__p (6 columns)
  • search__data__media_metadata___7ytjgsxuhyoc1__p (6 columns)
  • search__data__media_metadata___8b7h4eycy8hd1__p (6 columns)
  • search__data__media_metadata___8d3h7607iyoc1__p (6 columns)
  • search__data__media_metadata___8d6s6f0l6s6b1__p (6 columns)
  • search__data__media_metadata___8fc9x7zqhyoc1__p (6 columns)
  • search__data__media_metadata___8ivfrf3kvh2c1__p (6 columns)
  • search__data__media_metadata___8ji5f4ogbadd1__p (6 columns)
  • search__data__media_metadata___8qew9hlmtagd1__p (6 columns)
  • search__data__media_metadata___8wmfb73tpzkc1__p (6 columns)
  • search__data__media_metadata___90bw6c6byrjc1__p (6 columns)
  • search__data__media_metadata___9nj4zb6byrjc1__p (6 columns)
  • search__data__media_metadata__aezjvqgsk8ab1__p (6 columns)
  • search__data__media_metadata__agy59b6byrjc1__p (6 columns)
  • search__data__media_metadata__ani52glmtagd1__p (6 columns)
  • search__data__media_metadata__aqesbs0s0nlc1__p (6 columns)
  • search__data__media_metadata__b4rkym6p894d1__p (6 columns)
  • search__data__media_metadata__b5agp63tpzkc1__p (6 columns)
  • search__data__media_metadata__b96auu9u694d1__p (6 columns)
  • search__data__media_metadata__b9zn42ed2uac1__p (6 columns)
  • search__data__media_metadata__cmhjq2o9wwsc1__p (6 columns)
  • search__data__media_metadata__dimieuo7694d1__p (6 columns)
  • search__data__media_metadata__dlomukwp694d1__p (6 columns)
  • search__data__media_metadata__etdwa0o9wwsc1__p (6 columns)
  • search__data__media_metadata__fhu12oojvh2c1__p (6 columns)
  • search__data__media_metadata__fre1mdmmtagd1__p (6 columns)
  • search__data__media_metadata__fu12t3zjvh2c1__p (6 columns)
  • search__data__media_metadata__fw2i7t9hbadd1__p (6 columns)
  • search__data__media_metadata__g4bzpr7hbadd1__p (6 columns)
  • search__data__media_metadata__g7cmq88jvh2c1__p (6 columns)
  • search__data__media_metadata__gd3wl0cb2uac1__p (6 columns)
  • search__data__media_metadata__gltz973tpzkc1__p (6 columns)
  • search__data__media_metadata__gwsvjzb2nq6d1__p (6 columns)
  • search__data__media_metadata__h050ysgsk8ab1__p (6 columns)
  • search__data__media_metadata__h9ymvpdy694d1__p (6 columns)
  • search__data__media_metadata__hf54j1o9wwsc1__p (6 columns)
  • search__data__media_metadata__hmdpr1uc894d1__p (6 columns)
  • search__data__media_metadata__hnksl22fy8hd1__p (6 columns)
  • search__data__media_metadata__i1de61o9wwsc1__p (6 columns)
  • search__data__media_metadata__i7ag5dq5894d1__p (6 columns)
  • search__data__media_metadata__ibfiie0l6s6b1__p (6 columns)
  • search__data__media_metadata__icp4xi4b694d1__p (6 columns)
  • search__data__media_metadata__ivwcs2o9wwsc1__p (6 columns)
  • search__data__media_metadata__iysvgow1694d1__p (6 columns)
  • search__data__media_metadata__j15elwdd2uac1__p (6 columns)
  • search__data__media_metadata__jl3gzhijvh2c1__p (6 columns)
  • search__data__media_metadata__jt0a14o9wwsc1__p (6 columns)
  • search__data__media_metadata__k0e9y3wp0nlc1__p (6 columns)
  • search__data__media_metadata__kf9rhcxdy8hd1__p (6 columns)
  • search__data__media_metadata__ky0tk51l6s6b1__p (6 columns)
  • search__data__media_metadata__l1d8r63tpzkc1__p (6 columns)
  • search__data__media_metadata__l5022b6byrjc1__p (6 columns)
  • search__data__media_metadata__lb1zpgsjvh2c1__p (6 columns)
  • search__data__media_metadata__lt5zaanshyoc1__p (6 columns)
  • search__data__media_metadata__m2e1db6byrjc1__p (6 columns)
  • search__data__media_metadata__m8ca2rgsk8ab1__p (6 columns)
  • search__data__media_metadata__mgrnjb6byrjc1__p (6 columns)
  • search__data__media_metadata__mr2sldzgbadd1__p (6 columns)
  • search__data__media_metadata__n0fwm3rmdoob1__p (6 columns)
  • search__data__media_metadata__n5olcwd2794d1__p (6 columns)
  • search__data__media_metadata__neh04sbthyoc1__p (6 columns)
  • search__data__media_metadata__nh9z7bsgbadd1__p (6 columns)
  • search__data__media_metadata__o5b73gog694d1__p (6 columns)
  • search__data__media_metadata__o66q0ifg894d1__p (6 columns)
  • search__data__media_metadata__ogtdkc6byrjc1__p (6 columns)
  • search__data__media_metadata__omghqydd2uac1__p (6 columns)
  • search__data__media_metadata__oz9pl41l6s6b1__p (6 columns)
  • search__data__media_metadata__p8mlq3rmdoob1__p (6 columns)
  • search__data__media_metadata__pn3rtnlm694d1__p (6 columns)
  • search__data__media_metadata__pyf2u88x994d1__p (6 columns)
  • search__data__media_metadata__q15ymrgsk8ab1__p (6 columns)
  • search__data__media_metadata__q7n6i0ed2uac1__p (6 columns)
  • search__data__media_metadata__q7y7srgsk8ab1__p (6 columns)
  • search__data__media_metadata__qh0em1o9wwsc1__p (6 columns)
  • search__data__media_metadata__qrfauwfdy8hd1__p (6 columns)
  • search__data__media_metadata__qwrvjd0l6s6b1__p (6 columns)
  • search__data__media_metadata__qyg6qyfcy8hd1__p (6 columns)
  • search__data__media_metadata__rqxlaydd2uac1__p (6 columns)
  • search__data__media_metadata__sai4epnna94d1__p (6 columns)
  • search__data__media_metadata__sbo9envgbadd1__p (6 columns)
  • search__data__media_metadata__sdynasley8hd1__p (6 columns)
  • search__data__media_metadata__spqh22bba94d1__p (6 columns)
  • search__data__media_metadata__tuniwx0m794d1__p (6 columns)
  • search__data__media_metadata__u9kxh9rmdoob1__p (6 columns)
  • search__data__media_metadata__um8wkm3cy8hd1__p (6 columns)
  • search__data__media_metadata__vsb68f0l6s6b1__p (6 columns)
  • search__data__media_metadata__w65aquw1694d1__p (6 columns)
  • search__data__media_metadata__wpmmo53tpzkc1__p (6 columns)
  • search__data__media_metadata__wrawg1o9wwsc1__p (6 columns)
  • search__data__media_metadata__ws6w7f0l6s6b1__p (6 columns)
  • search__data__media_metadata__xtzxa8d2nq6d1__p (6 columns)
  • search__data__media_metadata__yijd9qag794d1__p (6 columns)
  • search__data__media_metadata__zr8qlmeo84sc1__p (6 columns)
  • search__data__media_metadata__zrv15xaovsbd1__p (6 columns)
  • search__data__media_metadata__zyjxsqgsk8ab1__p (6 columns)
  • search__data__mod_reports (4 columns)
  • search__data__preview__images (19 columns)
  • search__data__preview__images__resolutions (6 columns)
  • search__data__preview__images__variants__gif__resolutions (6 columns)
  • search__data__preview__images__variants__mp4__resolutions (6 columns)
  • search__data__preview__images__variants__nsfw__resolutions (6 columns)
  • search__data__preview__images__variants__obfuscated__resolutions (6 columns)
  • search__data__treatment_tags (4 columns)
  • search__data__user_reports (4 columns)
self (134 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accept_followers BOOL
awardee_karma FLOAT64
awarder_karma FLOAT64
can_create_subreddit BOOL
can_edit_name BOOL
coins FLOAT64
comment_karma FLOAT64
created FLOAT64
created_utc FLOAT64
features__awards_on_streams BOOL
features__chat_group_rollout BOOL
features__chat_subreddit BOOL
features__chat_user_settings BOOL
features__cookie_consent_banner BOOL
features__crowd_control_for_post BOOL
features__do_not_track BOOL
features__expensive_coins_package BOOL
features__images_in_comments BOOL
features__is_email_permission_required BOOL
features__mod_awards BOOL
features__mod_service_mute_reads BOOL
features__mod_service_mute_writes BOOL
features__modlog_copyright_removal BOOL
features__modmail_harassment_filter BOOL
features__mweb_nsfw_xpromo__experiment_id FLOAT64
features__mweb_nsfw_xpromo__owner STRING
features__mweb_nsfw_xpromo__variant STRING
features__mweb_sharing_clipboard__experiment_id FLOAT64
features__mweb_sharing_clipboard__owner STRING
features__mweb_sharing_clipboard__variant STRING
features__mweb_xpromo_interstitial_comments_android BOOL
features__mweb_xpromo_interstitial_comments_ios BOOL
features__mweb_xpromo_modal_listing_click_daily_dismissible_android BOOL
features__mweb_xpromo_modal_listing_click_daily_dismissible_ios BOOL
features__mweb_xpromo_revamp_v2__experiment_id FLOAT64
features__mweb_xpromo_revamp_v2__owner STRING
features__mweb_xpromo_revamp_v2__variant STRING
features__mweb_xpromo_revamp_v3__experiment_id FLOAT64
features__mweb_xpromo_revamp_v3__owner STRING
features__mweb_xpromo_revamp_v3__variant STRING
features__noreferrer_to_noopener BOOL
features__premium_subscriptions_table BOOL
features__promoted_trend_blanks BOOL
features__resized_styles_images BOOL
features__show_amp_link BOOL
features__use_pref_account_deployment BOOL
force_password_reset BOOL
gold_creddits FLOAT64
has_android_subscription BOOL
has_external_account BOOL
has_gold_subscription BOOL
has_ios_subscription BOOL
has_mail BOOL
has_mod_mail BOOL
has_paypal_subscription BOOL
has_stripe_subscription BOOL
has_subscribed BOOL
has_subscribed_to_premium BOOL
has_verified_email BOOL
… and 74 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • self__linked_identities (4 columns)
  • self__subreddit__allowed_media_in_comments (4 columns)
  • self__subreddit__icon_size (4 columns)
  • self__subreddit__previous_names (4 columns)
subreddit_explore (344 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
data__allow_live_comments BOOL
data__archived BOOL
data__author STRING
data__author_cakeday BOOL
data__author_flair_background_color STRING
data__author_flair_template_id STRING
data__author_flair_text STRING
data__author_flair_text_color STRING
data__author_flair_type STRING
data__author_fullname STRING
data__author_is_blocked BOOL
data__author_patreon_flair BOOL
data__author_premium BOOL
data__can_gild BOOL
data__can_mod_post BOOL
data__clicked BOOL
data__contest_mode BOOL
data__created FLOAT64
data__created_utc FLOAT64
data__crosspost_parent STRING
data__domain STRING
data__downs FLOAT64
data__edited FLOAT64
data__gilded FLOAT64
data__hidden BOOL
data__hide_score BOOL
data__id STRING
data__is_created_from_ads_ui BOOL
data__is_crosspostable BOOL
data__is_gallery BOOL
data__is_meta BOOL
data__is_original_content BOOL
data__is_reddit_media_domain BOOL
data__is_robot_indexable BOOL
data__is_self BOOL
data__is_video BOOL
data__link_flair_background_color STRING
data__link_flair_css_class STRING
data__link_flair_template_id STRING
data__link_flair_text STRING
data__link_flair_text_color STRING
data__link_flair_type STRING
data__locked BOOL
data__media__type STRING
data__media__oembed__version STRING
data__media__oembed__type STRING
data__media__oembed__description STRING
data__media__oembed__author_name STRING
data__media__oembed__author_url STRING
data__media__oembed__height FLOAT64
data__media__oembed__html STRING
data__media__oembed__provider_name STRING
data__media__oembed__provider_url STRING
data__media__oembed__thumbnail_height FLOAT64
data__media__oembed__thumbnail_url STRING
data__media__oembed__thumbnail_width FLOAT64
data__media__oembed__title STRING
data__media__oembed__url STRING
data__media__oembed__width FLOAT64
… and 284 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • subreddit_explore__data__all_awardings (4 columns)
  • subreddit_explore__data__author_flair_richtext (7 columns)
  • subreddit_explore__data__awarders (4 columns)
  • subreddit_explore__data__crosspost_parent_list (98 columns)
  • subreddit_explore__data__crosspost_parent_list__all_awardings (4 columns)
  • subreddit_explore__data__crosspost_parent_list__author_flair_richtext (4 columns)
  • subreddit_explore__data__crosspost_parent_list__awarders (4 columns)
  • subreddit_explore__data__crosspost_parent_list__link_flair_richtext (4 columns)
  • subreddit_explore__data__crosspost_parent_list__mod_reports (4 columns)
  • subreddit_explore__data__crosspost_parent_list__preview__images (7 columns)
  • subreddit_explore__data__crosspost_parent_list__preview__images__resolutions (6 columns)
  • subreddit_explore__data__crosspost_parent_list__treatment_tags (4 columns)
  • subreddit_explore__data__crosspost_parent_list__user_reports (4 columns)
  • subreddit_explore__data__gallery_data__items (6 columns)
  • subreddit_explore__data__link_flair_richtext (7 columns)
  • subreddit_explore__data__media_metadata___0521osovmfkd1__p (6 columns)
  • subreddit_explore__data__media_metadata___2d1dib6vmfkd1__p (6 columns)
  • subreddit_explore__data__media_metadata___3rhl3xrmwdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata___3uoq3om8ddkd1__p (6 columns)
  • subreddit_explore__data__media_metadata___4ysppojeljkd1__p (6 columns)
  • subreddit_explore__data__media_metadata___5tymkhlvmfkd1__p (6 columns)
  • subreddit_explore__data__media_metadata___857h41hdrikd1__p (6 columns)
  • subreddit_explore__data__media_metadata__anioms3owdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__aqp1w19tcdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__b3nvq6evmfkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__dhnagdtokgkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__f61ecqwvmfkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__g4925io8rikd1__p (6 columns)
  • subreddit_explore__data__media_metadata__iopp0qgbxdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__jiq7b5ecxdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__k1h1kzrbxdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__ls9gt6jt8dkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__mnhdu92wmfkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__qqjus7nnwdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__qutybb4cxdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__tvv022wbxdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__uhqvqfq0iekd1__p (6 columns)
  • subreddit_explore__data__media_metadata__um0tev7kkjkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__wjz5xk8wmfkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__wqjap50cxdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__z8wtfowzcdkd1__p (6 columns)
  • subreddit_explore__data__media_metadata__zyu5ikgbbjkd1__p (6 columns)
  • subreddit_explore__data__mod_reports (4 columns)
  • subreddit_explore__data__preview__images (7 columns)
  • subreddit_explore__data__preview__images__resolutions (6 columns)
  • subreddit_explore__data__treatment_tags (4 columns)
  • subreddit_explore__data__user_reports (4 columns)
subreddit_popular (88 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
data__description STRING
data__accept_followers BOOL
data__accounts_active_is_fuzzed BOOL
data__advertiser_category STRING
data__all_original_content BOOL
data__allow_discovery BOOL
data__allow_galleries BOOL
data__allow_images BOOL
data__allow_polls BOOL
data__allow_prediction_contributors BOOL
data__allow_predictions BOOL
data__allow_predictions_tournament BOOL
data__allow_talks BOOL
data__allow_videogifs BOOL
data__allow_videos BOOL
data__banner_background_color STRING
data__banner_background_image STRING
data__banner_img STRING
data__can_assign_link_flair BOOL
data__can_assign_user_flair BOOL
data__collapse_deleted_comments BOOL
data__comment_score_hide_mins FLOAT64
data__community_icon STRING
data__community_reviewed BOOL
data__content_category STRING
data__created FLOAT64
data__created_utc FLOAT64
data__description_html STRING
data__disable_contributor_requests BOOL
data__display_name STRING
data__display_name_prefixed STRING
data__emojis_enabled BOOL
data__free_form_reports BOOL
data__has_menu_widget BOOL
data__header_img STRING
data__header_title STRING
data__hide_ads BOOL
data__icon_img STRING
data__id STRING
data__is_crosspostable_subreddit BOOL
data__key_color STRING
data__lang STRING
data__link_flair_enabled BOOL
data__link_flair_position STRING
data__mobile_banner_image STRING
data__name STRING
data__original_content_tag_enabled BOOL
data__over18 BOOL
data__prediction_leaderboard_entry_type FLOAT64
data__primary_color STRING
data__public_description STRING
data__public_description_html STRING
data__public_traffic BOOL
data__quarantine BOOL
data__restrict_commenting BOOL
data__restrict_posting BOOL
data__should_archive_posts BOOL
data__should_show_media_in_comments_setting BOOL
data__show_media BOOL
… and 28 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • subreddit_popular__data__allowed_media_in_comments (4 columns)
  • subreddit_popular__data__banner_size (4 columns)
  • subreddit_popular__data__comment_contribution_settings__allowed_media_types (4 columns)
  • subreddit_popular__data__emojis_custom_size (4 columns)
  • subreddit_popular__data__header_size (4 columns)
  • subreddit_popular__data__icon_size (4 columns)
  • subreddit_popular__data__user_flair_richtext (4 columns)
subreddit_search (88 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
data__description STRING
data__accept_followers BOOL
data__accounts_active_is_fuzzed BOOL
data__advertiser_category STRING
data__all_original_content BOOL
data__allow_discovery BOOL
data__allow_galleries BOOL
data__allow_images BOOL
data__allow_polls BOOL
data__allow_prediction_contributors BOOL
data__allow_predictions BOOL
data__allow_predictions_tournament BOOL
data__allow_talks BOOL
data__allow_videogifs BOOL
data__allow_videos BOOL
data__banner_background_color STRING
data__banner_background_image STRING
data__banner_img STRING
data__can_assign_link_flair BOOL
data__can_assign_user_flair BOOL
data__collapse_deleted_comments BOOL
data__comment_score_hide_mins FLOAT64
data__community_icon STRING
data__community_reviewed BOOL
data__content_category STRING
data__created FLOAT64
data__created_utc FLOAT64
data__description_html STRING
data__disable_contributor_requests BOOL
data__display_name STRING
data__display_name_prefixed STRING
data__emojis_enabled BOOL
data__free_form_reports BOOL
data__has_menu_widget BOOL
data__header_img STRING
data__header_title STRING
data__hide_ads BOOL
data__icon_img STRING
data__id STRING
data__is_crosspostable_subreddit BOOL
data__key_color STRING
data__lang STRING
data__link_flair_enabled BOOL
data__link_flair_position STRING
data__mobile_banner_image STRING
data__name STRING
data__original_content_tag_enabled BOOL
data__over18 BOOL
data__prediction_leaderboard_entry_type FLOAT64
data__primary_color STRING
data__public_description STRING
data__public_description_html STRING
data__public_traffic BOOL
data__quarantine BOOL
data__restrict_commenting BOOL
data__restrict_posting BOOL
data__should_archive_posts BOOL
data__should_show_media_in_comments_setting BOOL
data__show_media BOOL
… and 28 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • subreddit_search__data__allowed_media_in_comments (4 columns)
  • subreddit_search__data__banner_size (4 columns)
  • subreddit_search__data__comment_contribution_settings__allowed_media_types (4 columns)
  • subreddit_search__data__emojis_custom_size (4 columns)
  • subreddit_search__data__header_size (4 columns)
  • subreddit_search__data__icon_size (4 columns)
  • subreddit_search__data__user_flair_richtext (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Reddit supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Reddit?

Section titled “How long does the initial sync take for Reddit?”

It depends on how much history is in your Reddit account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Reddit’s schema changes?

Section titled “What happens when Reddit’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Reddit, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Reddit instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Reddit connector in Kaivo and all of its synced data is deleted with it.

Use search and subreddit_search to track conversations relevant to your brand.

Use subreddit_popular and subreddit_explore to understand active communities.

Bring Reddit data into BigQuery to report on social activity next to your other channels.

Once Reddit data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Reddit data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Reddit connector pricing and plan details.