Skip to content
Book a demoStart free
Connectors

Ticketmaster connector

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

Ticketmaster connector pricing, tier and credits on kaivo.io

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

Sync your Ticketmaster data into BigQuery with Kaivo to analyse events, venues, attractions, and demand across your markets.

CategoryOther
AuthenticationAPI key
SetupSelf-service

Getting started with the Ticketmaster connector

Section titled “Getting started with the Ticketmaster connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Ticketmaster 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
Your Ticketmaster API key — the Consumer Key of your app in the Ticketmaster Developer Portal (developer.ticketmaster.com).

|

Tables and columns synced from Ticketmaster

Section titled “Tables and columns synced from Ticketmaster”

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

attractions (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self__href STRING
draft_status STRING
id STRING
locale STRING
name STRING
test BOOL
upcoming_events___filtered FLOAT64
upcoming_events___total FLOAT64
upcoming_events__crowder FLOAT64
upcoming_events__mfx_ae FLOAT64
upcoming_events__mfx_at FLOAT64
upcoming_events__mfx_be FLOAT64
upcoming_events__mfx_ch FLOAT64
upcoming_events__mfx_cz FLOAT64
upcoming_events__mfx_de FLOAT64
upcoming_events__mfx_dk FLOAT64
upcoming_events__mfx_es FLOAT64
upcoming_events__mfx_fi FLOAT64
upcoming_events__mfx_it FLOAT64
upcoming_events__mfx_nl FLOAT64
upcoming_events__mfx_no FLOAT64
upcoming_events__mfx_pl FLOAT64
upcoming_events__mfx_se FLOAT64
upcoming_events__mfx_za FLOAT64
upcoming_events__moshtix FLOAT64
upcoming_events__ticketmaster FLOAT64
upcoming_events__ticketnet FLOAT64
upcoming_events__ticketweb FLOAT64
upcoming_events__tmc FLOAT64
upcoming_events__tmr FLOAT64
upcoming_events__universe FLOAT64
upcoming_events__veeps FLOAT64
url 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.
type__id STRING
type__name STRING
family BOOL
genre__id STRING
genre__name STRING
primary BOOL
segment__id STRING
segment__name STRING
sub_genre__id STRING
sub_genre__name STRING
sub_type__id STRING
sub_type__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__facebook”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__homepage”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__instagram”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__itunes”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__lastfm”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__musicbrainz”
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.
id STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__spotify”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__twitter”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__wiki”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: attractions__external_links__youtube”
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.
url 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.
attribution STRING
fallback BOOL
height FLOAT64
ratio STRING
url STRING
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
event_images (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self__href STRING
id 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.
fallback BOOL
height FLOAT64
ratio STRING
url STRING
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self__href STRING
accessibility__id STRING
accessibility__info STRING
accessibility__ticket_limit FLOAT64
accessibility__url STRING
accessibility__url_text STRING
age_restrictions__age_rule_description STRING
age_restrictions__id STRING
age_restrictions__legal_age_enforced BOOL
dates__initial_start_date__date_time STRING
dates__initial_start_date__local_date STRING
dates__initial_start_date__local_time STRING
dates__span_multiple_days BOOL
dates__start__date_tba BOOL
dates__start__date_tbd BOOL
dates__start__date_time STRING
dates__start__local_date STRING
dates__start__local_time STRING
dates__start__no_specific_time BOOL
dates__start__time_tba BOOL
dates__status__code STRING
dates__timezone STRING
doors_times__date_time STRING
doors_times__id STRING
doors_times__local_date STRING
doors_times__local_time STRING
id STRING
info STRING
locale STRING
name STRING
please_note STRING
promoter__description STRING
promoter__id STRING
promoter__name STRING
sales__public__end_date_time STRING
sales__public__start_date_time STRING
sales__public__start_tba BOOL
sales__public__start_tbd BOOL
seatmap__id STRING
seatmap__static_url STRING
test BOOL
ticket_limit__id STRING
ticket_limit__info STRING
ticketing__all_inclusive_pricing__enabled BOOL
ticketing__id STRING
ticketing__safe_tix__enabled BOOL
ticketing__safe_tix__in_app_only_enabled BOOL
url 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.
type STRING
_links__self__href STRING
id STRING
locale STRING
name STRING
test BOOL
upcoming_events___filtered FLOAT64
upcoming_events___total FLOAT64
upcoming_events__mfx_be FLOAT64
upcoming_events__mfx_cz FLOAT64
upcoming_events__mfx_de FLOAT64
upcoming_events__mfx_dk FLOAT64
upcoming_events__mfx_es FLOAT64
upcoming_events__mfx_fi FLOAT64
upcoming_events__mfx_it FLOAT64
upcoming_events__mfx_nl FLOAT64
upcoming_events__mfx_no FLOAT64
upcoming_events__mfx_pl FLOAT64
upcoming_events__mfx_se FLOAT64
upcoming_events__ticketmaster FLOAT64
upcoming_events__ticketnet FLOAT64
upcoming_events__tmr FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events___embedded__attractions__aliases

Section titled “Subtable: events___embedded__attractions__aliases”
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: events___embedded__attractions__classifications

Section titled “Subtable: events___embedded__attractions__classifications”
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.
type__id STRING
type__name STRING
family BOOL
genre__id STRING
genre__name STRING
primary BOOL
segment__id STRING
segment__name STRING
sub_genre__id STRING
sub_genre__name STRING
sub_type__id STRING
sub_type__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__facebook”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__homepage”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__instagram”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__itunes”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__lastfm”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__musicbrainz”
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.
id STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__spotify”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__twitter”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__wiki”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__attractions__external_links__youtube”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events___embedded__attractions__images

Section titled “Subtable: events___embedded__attractions__images”
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.
attribution STRING
fallback BOOL
height FLOAT64
ratio STRING
url STRING
width FLOAT64
_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.
type STRING
_links__self__href STRING
accessible_seating_detail STRING
ada__ada_custom_copy STRING
ada__ada_hours STRING
ada__ada_phones STRING
address__line1 STRING
address__line2 STRING
box_office_info__accepted_payment_detail STRING
box_office_info__open_hours_detail STRING
box_office_info__phone_number_detail STRING
box_office_info__will_call_detail STRING
city__name STRING
country__country_code STRING
country__name STRING
general_info__child_rule STRING
general_info__general_rule STRING
id STRING
locale STRING
location__latitude STRING
location__longitude STRING
name STRING
parking_detail STRING
postal_code STRING
social__twitter__handle STRING
state__name STRING
state__state_code STRING
test BOOL
timezone STRING
upcoming_events___filtered FLOAT64
upcoming_events___total FLOAT64
upcoming_events__archtics FLOAT64
upcoming_events__ticketmaster FLOAT64
upcoming_events__tmr FLOAT64
upcoming_events__universe FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events___embedded__venues__aliases

Section titled “Subtable: events___embedded__venues__aliases”
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.
id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: events___embedded__venues__external_links__app_deep_link”
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.
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events___embedded__venues__images

Section titled “Subtable: events___embedded__venues__images”
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.
fallback BOOL
height FLOAT64
ratio STRING
url STRING
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events___embedded__venues__markets

Section titled “Subtable: events___embedded__venues__markets”
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.
id STRING
name 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.
href 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.
href 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.
type__id STRING
type__name STRING
family BOOL
genre__id STRING
genre__name STRING
primary BOOL
segment__id STRING
segment__name STRING
sub_genre__id STRING
sub_genre__name STRING
sub_type__id STRING
sub_type__name 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.
attribution STRING
fallback BOOL
height FLOAT64
ratio STRING
url STRING
width FLOAT64
_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.
type STRING
url 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.
type STRING
currency STRING
max FLOAT64
min FLOAT64
_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.
type STRING
id STRING
name STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__products__classifications

Section titled “Subtable: events__products__classifications”
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.
type__id STRING
type__name STRING
family BOOL
genre__id STRING
genre__name STRING
primary BOOL
segment__id STRING
segment__name STRING
sub_genre__id STRING
sub_genre__name STRING
sub_type__id STRING
sub_type__name 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.
description STRING
id STRING
name 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.
description STRING
end_date_time STRING
link_descriptions__en_au STRING
link_descriptions__en_ca STRING
link_descriptions__en_mx STRING
link_descriptions__en_nz STRING
link_descriptions__en_us STRING
link_descriptions__es_br STRING
link_descriptions__es_mx STRING
link_descriptions__es_us STRING
link_descriptions__fr_ca STRING
link_descriptions__pt_br STRING
name STRING
start_date_time STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
suggest (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self__href STRING
city__name STRING
country__country_code STRING
country__name STRING
id STRING
locale STRING
location__latitude STRING
location__longitude STRING
name STRING
state__name STRING
state__state_code STRING
timezone STRING
upcoming_events___filtered FLOAT64
upcoming_events___total FLOAT64
upcoming_events__archtics FLOAT64
upcoming_events__ticketmaster FLOAT64
upcoming_events__tmr FLOAT64
url 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.
fallback BOOL
height FLOAT64
ratio STRING
url STRING
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
venues (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self__href STRING
accessible_seating_detail STRING
ada__ada_custom_copy STRING
ada__ada_hours STRING
ada__ada_phones STRING
address__line1 STRING
address__line2 STRING
box_office_info__accepted_payment_detail STRING
box_office_info__open_hours_detail STRING
box_office_info__phone_number_detail STRING
box_office_info__will_call_detail STRING
city__name STRING
country__country_code STRING
country__name STRING
general_info__child_rule STRING
general_info__general_rule STRING
id STRING
locale STRING
location__latitude STRING
location__longitude STRING
name STRING
parking_detail STRING
postal_code STRING
social__twitter__handle STRING
state__name STRING
state__state_code STRING
test BOOL
timezone STRING
upcoming_events___filtered FLOAT64
upcoming_events___total FLOAT64
upcoming_events__archtics FLOAT64
upcoming_events__mfx_it FLOAT64
upcoming_events__ticketmaster FLOAT64
upcoming_events__ticketweb FLOAT64
upcoming_events__tmr FLOAT64
upcoming_events__universe FLOAT64
upcoming_events__veeps FLOAT64
url 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.
id FLOAT64
_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.
fallback BOOL
height FLOAT64
ratio STRING
url STRING
width FLOAT64
_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.
id STRING
name 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 Ticketmaster 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 Ticketmaster?

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

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

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

Use events and attractions to study what is on sale and where.

Join events with venues to compare activity across locations.

Bring event data into BigQuery to analyse the market alongside your own data.

Use Ticketmaster data in your AI and BI tools

Section titled “Use Ticketmaster data in your AI and BI tools”

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