Skip to content
Book a demoStart free
Connectors

100ms connector

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

100ms connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your 100ms 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 data from 100ms instead of moving it.

Sync your 100ms video sessions, rooms, and recordings into BigQuery with Kaivo to analyse usage, participation, and quality across your live audio and video.

CategoryTech
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your 100ms 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 Management Token.

Field Description
Management Token
Your 100ms management token. Find or generate it in the API section of your 100ms dashboard.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

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

active_room_peers (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_683e5a05_10ff_4b43_80ff_8a6234025500__metadata STRING
_683e5a05_10ff_4b43_80ff_8a6234025500__id STRING
_683e5a05_10ff_4b43_80ff_8a6234025500__joined_at STRING
_683e5a05_10ff_4b43_80ff_8a6234025500__name STRING
_683e5a05_10ff_4b43_80ff_8a6234025500__role STRING
_683e5a05_10ff_4b43_80ff_8a6234025500__user_id STRING
_968e8a17_c6c1_43a5_bfdf_afae57872485__metadata STRING
_968e8a17_c6c1_43a5_bfdf_afae57872485__id STRING
_968e8a17_c6c1_43a5_bfdf_afae57872485__joined_at STRING
_968e8a17_c6c1_43a5_bfdf_afae57872485__name STRING
_968e8a17_c6c1_43a5_bfdf_afae57872485__role STRING
_968e8a17_c6c1_43a5_bfdf_afae57872485__user_id STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_events (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version STRING
type STRING
data__type STRING
data__account_id STRING
data__action STRING
data__agent__device_model STRING
data__agent__domain STRING
data__agent__framework STRING
data__agent__framework_sdk_version STRING
data__agent__framework_version STRING
data__agent__is_prebuilt BOOL
data__agent__os STRING
data__agent__os_version STRING
data__agent__sdk STRING
data__agent__sdk_version STRING
data__agent__string STRING
data__audio__codec STRING
data__audio__device_id STRING
data__audio__max_bitrate FLOAT64
data__audio__volume FLOAT64
data__domain STRING
data__error_code FLOAT64
data__error_description STRING
data__error_message STRING
data__error_name STRING
data__is_terminal BOOL
data__joined_at STRING
data__mute BOOL
data__peer_id STRING
data__role STRING
data__room_id STRING
data__room_name STRING
data__session_id STRING
data__source STRING
data__started_at STRING
data__stopped_at STRING
data__stream_id STRING
data__template_id STRING
data__track_id STRING
data__user_id STRING
data__user_name STRING
data__video__codec STRING
data__video__device_id STRING
data__video__height FLOAT64
data__video__max_bitrate FLOAT64
data__video__max_framerate FLOAT64
data__video__width FLOAT64
id STRING
timestamp STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: analytics_events__data__devices__audio_input

Section titled “Subtable: analytics_events__data__devices__audio_input”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: analytics_events__data__devices__audio_output

Section titled “Subtable: analytics_events__data__devices__audio_output”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
device_id STRING
group_id STRING
kind STRING
label STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: analytics_events__data__devices__video_input

Section titled “Subtable: analytics_events__data__devices__video_input”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
recordings (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
destination STRING
id STRING
meeting_url STRING
room_id STRING
session_id STRING
started_at STRING
started_by STRING
status STRING
stopped_by STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
rooms (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_id STRING
created_at STRING
customer STRING
customer_id STRING
enabled BOOL
id STRING
large_room BOOL
name STRING
region STRING
template STRING
template_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sessions (43 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
active BOOL
app_id STRING
created_at STRING
customer_id STRING
ended_at STRING
id STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__id STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__joined_at STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__left_at STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__name STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__role STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__session_id STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__user STRING
peers___4b9dd7c7_8173_4e95_99fb_3a39f04dfff8__user_id STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__id STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__joined_at STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__left_at STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__name STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__role STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__session_id STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__user STRING
peers___62bc19d6_bdf2_4ae3_96dd_39c2af9fc4f2__user_id STRING
peers___66bccaef_6b7b_4db1_9544_94be372080ab__id STRING
peers___66bccaef_6b7b_4db1_9544_94be372080ab__joined_at STRING
peers___66bccaef_6b7b_4db1_9544_94be372080ab__name STRING
peers___66bccaef_6b7b_4db1_9544_94be372080ab__role STRING
peers___66bccaef_6b7b_4db1_9544_94be372080ab__session_id STRING
peers___66bccaef_6b7b_4db1_9544_94be372080ab__user STRING
peers___66bccaef_6b7b_4db1_9544_94be372080ab__user_id STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__id STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__joined_at STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__left_at STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__name STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__role STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__session_id STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__user STRING
peers___770201f7_a4b3_4858_b195_ca4ccc441a64__user_id STRING
room_id STRING
updated_at STRING
user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
template_settings (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
region STRING
room_state__enabled BOOL
room_state__message_interval FLOAT64
room_state__send_peer_list BOOL
room_state__stop_room_state_on_join BOOL
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
templates (139 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
app_id STRING
created_at STRING
customer STRING
customer_id STRING
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__auto_stop_timeout FLOAT64
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__height FLOAT64
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__max_duration FLOAT64
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__name STRING
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__presign_duration FLOAT64
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__role STRING
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__thumbnails__height FLOAT64
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__thumbnails__width FLOAT64
destinations__browser_recordings___6708fd34_1814_4721_91ab_ff8df9bc5eec__width FLOAT64
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__enable_metadata_insertion BOOL
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__enable_static_url BOOL
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__max_duration FLOAT64
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__name STRING
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__num_playlist_segments FLOAT64
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__playlist_type STRING
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__preset STRING
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__hls_vod BOOL
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__presign_duration FLOAT64
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__single_file_per_layer BOOL
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__thumbnails__height FLOAT64
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__thumbnails__width FLOAT64
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__role STRING
destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__video_frame_rate FLOAT64
id STRING
name STRING
roles__internal_recorder__max_peer_count FLOAT64
roles__internal_recorder__name STRING
roles__internal_recorder__permissions__browser_recording BOOL
roles__internal_recorder__permissions__hls_streaming BOOL
roles__internal_recorder__permissions__rtmp_streaming BOOL
roles__internal_recorder__permissions__send_room_state BOOL
roles__internal_recorder__priority FLOAT64
roles__internal_recorder__publish_params__audio__bit_rate FLOAT64
roles__internal_recorder__publish_params__audio__codec STRING
roles__internal_recorder__publish_params__screen__codec STRING
roles__internal_recorder__publish_params__screen__frame_rate FLOAT64
roles__internal_recorder__publish_params__screen__height FLOAT64
roles__internal_recorder__publish_params__screen__width FLOAT64
roles__internal_recorder__publish_params__video__bit_rate FLOAT64
roles__internal_recorder__publish_params__video__codec STRING
roles__internal_recorder__publish_params__video__frame_rate FLOAT64
roles__internal_recorder__publish_params__video__height FLOAT64
roles__internal_recorder__publish_params__video__width FLOAT64
roles__internal_recorder__role_id STRING
roles__internal_recorder__subscribe_params__max_subs_bit_rate FLOAT64
roles__internal_recorder__subscribe_params__subscribe_degradation__degrade_grace_period_seconds FLOAT64
roles__internal_recorder__subscribe_params__subscribe_degradation__packet_loss_threshold FLOAT64
roles__internal_recorder__subscribe_params__subscribe_degradation__recover_grace_period_seconds FLOAT64
roles__guest__max_peer_count FLOAT64
roles__guest__name STRING
roles__guest__permissions__browser_recording BOOL
roles__guest__permissions__hls_streaming BOOL
roles__guest__permissions__poll_read BOOL
roles__guest__permissions__poll_write BOOL
roles__guest__permissions__rtmp_streaming BOOL
roles__guest__permissions__send_room_state BOOL
roles__guest__priority FLOAT64
roles__guest__publish_params__audio__bit_rate FLOAT64
roles__guest__publish_params__audio__codec STRING
roles__guest__publish_params__screen__codec STRING
roles__guest__publish_params__screen__frame_rate FLOAT64
roles__guest__publish_params__screen__height FLOAT64
roles__guest__publish_params__screen__width FLOAT64
roles__guest__publish_params__video__bit_rate FLOAT64
roles__guest__publish_params__video__codec STRING
roles__guest__publish_params__video__frame_rate FLOAT64
roles__guest__publish_params__video__height FLOAT64
roles__guest__publish_params__video__width FLOAT64
roles__guest__role_id STRING
roles__guest__subscribe_params__max_subs_bit_rate FLOAT64
roles__guest__subscribe_params__subscribe_degradation__degrade_grace_period_seconds FLOAT64
roles__guest__subscribe_params__subscribe_degradation__packet_loss_threshold FLOAT64
roles__guest__subscribe_params__subscribe_degradation__recover_grace_period_seconds FLOAT64
roles__host__max_peer_count FLOAT64
roles__host__name STRING
roles__host__permissions__browser_recording BOOL
roles__host__permissions__change_role BOOL
roles__host__permissions__end_room BOOL
roles__host__permissions__hls_streaming BOOL
roles__host__permissions__mute BOOL
roles__host__permissions__poll_read BOOL
roles__host__permissions__poll_write BOOL
roles__host__permissions__remove_others BOOL
roles__host__permissions__rtmp_streaming BOOL
roles__host__permissions__send_room_state BOOL
roles__host__permissions__unmute BOOL
roles__host__priority FLOAT64
roles__host__publish_params__audio__bit_rate FLOAT64
roles__host__publish_params__audio__codec STRING
roles__host__publish_params__screen__codec STRING
roles__host__publish_params__screen__frame_rate FLOAT64
roles__host__publish_params__screen__height FLOAT64
roles__host__publish_params__screen__width FLOAT64
roles__host__publish_params__video__bit_rate FLOAT64
roles__host__publish_params__video__codec STRING
roles__host__publish_params__video__frame_rate FLOAT64
roles__host__publish_params__video__height FLOAT64
roles__host__publish_params__video__width FLOAT64
roles__host__role_id STRING
roles__host__subscribe_params__max_subs_bit_rate FLOAT64
roles__host__subscribe_params__subscribe_degradation__degrade_grace_period_seconds FLOAT64
roles__host__subscribe_params__subscribe_degradation__packet_loss_threshold FLOAT64
roles__host__subscribe_params__subscribe_degradation__recover_grace_period_seconds FLOAT64
roles__viewer_near_realtime__max_peer_count FLOAT64
roles__viewer_near_realtime__name STRING
roles__viewer_near_realtime__permissions__browser_recording BOOL
roles__viewer_near_realtime__permissions__hls_streaming BOOL
roles__viewer_near_realtime__permissions__rtmp_streaming BOOL
roles__viewer_near_realtime__permissions__send_room_state BOOL
roles__viewer_near_realtime__priority FLOAT64
roles__viewer_near_realtime__publish_params__audio__bit_rate FLOAT64
roles__viewer_near_realtime__publish_params__audio__codec STRING
roles__viewer_near_realtime__publish_params__screen__codec STRING
roles__viewer_near_realtime__publish_params__screen__frame_rate FLOAT64
roles__viewer_near_realtime__publish_params__screen__height FLOAT64
roles__viewer_near_realtime__publish_params__screen__width FLOAT64
roles__viewer_near_realtime__publish_params__video__bit_rate FLOAT64
roles__viewer_near_realtime__publish_params__video__codec STRING
roles__viewer_near_realtime__publish_params__video__frame_rate FLOAT64
roles__viewer_near_realtime__publish_params__video__height FLOAT64
roles__viewer_near_realtime__publish_params__video__width FLOAT64
roles__viewer_near_realtime__role_id STRING
roles__viewer_near_realtime__subscribe_params__max_subs_bit_rate FLOAT64
roles__viewer_near_realtime__subscribe_params__subscribe_degradation__degrade_grace_period_seconds FLOAT64
roles__viewer_near_realtime__subscribe_params__subscribe_degradation__packet_loss_threshold FLOAT64
roles__viewer_near_realtime__subscribe_params__subscribe_degradation__recover_grace_period_seconds FLOAT64
settings__region STRING
settings__room_state__enabled BOOL
settings__room_state__message_interval FLOAT64
settings__room_state__send_peer_list BOOL
settings__room_state__stop_room_state_on_join BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__layers

Section titled “Subtable: templates__destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__layers”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
audio_bitrate FLOAT64
height FLOAT64
video_bitrate FLOAT64
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__layers

Section titled “Subtable: templates__destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__layers”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
audio_bitrate FLOAT64
height FLOAT64
video_bitrate FLOAT64
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__thumbnails__offsets

Section titled “Subtable: templates__destinations__hls_destinations___4a2a1131_35b4_4d42_a02b_b4f213c778b2__recording__thumbnails__offsets”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__internal_recorder__publish_params__allowed

Section titled “Subtable: templates__roles__internal_recorder__publish_params__allowed”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__internal_recorder__subscribe_params__subscribe_to_roles

Section titled “Subtable: templates__roles__internal_recorder__subscribe_params__subscribe_to_roles”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__guest__publish_params__allowed

Section titled “Subtable: templates__roles__guest__publish_params__allowed”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__guest__publish_params__simulcast__video__layers

Section titled “Subtable: templates__roles__guest__publish_params__simulcast__video__layers”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
max_bitrate FLOAT64
max_framerate FLOAT64
rid STRING
scale_resolution_down_by FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__guest__subscribe_params__subscribe_to_roles

Section titled “Subtable: templates__roles__guest__subscribe_params__subscribe_to_roles”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__host__publish_params__allowed

Section titled “Subtable: templates__roles__host__publish_params__allowed”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__host__publish_params__simulcast__video__layers

Section titled “Subtable: templates__roles__host__publish_params__simulcast__video__layers”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
max_bitrate FLOAT64
max_framerate FLOAT64
rid STRING
scale_resolution_down_by FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__host__subscribe_params__subscribe_to_roles

Section titled “Subtable: templates__roles__host__subscribe_params__subscribe_to_roles”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: templates__roles__viewer_near_realtime__publish_params__allowed

Section titled “Subtable: templates__roles__viewer_near_realtime__publish_params__allowed”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
templates_destinations (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_6708fd34_1814_4721_91ab_ff8df9bc5eec__auto_stop_timeout FLOAT64
_6708fd34_1814_4721_91ab_ff8df9bc5eec__height FLOAT64
_6708fd34_1814_4721_91ab_ff8df9bc5eec__max_duration FLOAT64
_6708fd34_1814_4721_91ab_ff8df9bc5eec__name STRING
_6708fd34_1814_4721_91ab_ff8df9bc5eec__presign_duration FLOAT64
_6708fd34_1814_4721_91ab_ff8df9bc5eec__role STRING
_6708fd34_1814_4721_91ab_ff8df9bc5eec__thumbnails__height FLOAT64
_6708fd34_1814_4721_91ab_ff8df9bc5eec__thumbnails__width FLOAT64
_6708fd34_1814_4721_91ab_ff8df9bc5eec__width FLOAT64
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where 100ms 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 100ms?

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

It depends on how much history is in your 100ms 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 100ms’s schema changes?

Section titled “What happens when 100ms’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 100ms, 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 100ms 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 100ms connector in Kaivo and all of its synced data is deleted with it.

Aggregate sessions by app and time to track how many live sessions run and how long they last.

Use active_room_peers and peers on sessions to see how many people join each room and where drop-offs happen.

Join rooms with templates to see which configurations are used most and how they perform.

Track recordings by room and session to monitor how much content you capture and store.

Once 100ms 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 100ms 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 100ms connector pricing and plan details.

  • Adform: Sync Adform to BigQuery.
  • Amplitude: Sync Amplitude to BigQuery.
  • Auth0: Sync Auth0 to BigQuery.
  • Convex: Sync Convex to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.