Skip to content
Book a demoStart free
Connectors

Clazar connector

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

Clazar connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Clazar 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 Clazar cloud marketplace data into BigQuery with Kaivo to analyse marketplace revenue and co-sell across AWS, Azure, and GCP.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Clazar 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 Client Secret.

Field Description
Client Secret
Your Clazar API client secret.

|

Prerequisites

Clazar uses OAuth client credentials, so you need API credentials from your Clazar account:

  1. In your Clazar account, open Settings and find the API credentials section (see Clazar’s developer docs if you can’t locate it).
  2. Create an API client and copy the Client ID and Client Secret.

Then enter those values below.

Need help? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Client ID
Your Clazar API client ID.

|

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

analytics_aws_cosell_opportunities (66 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
geo STRING
uuid STRING
state STRING
region STRING
status STRING
country STRING
segment STRING
industry STRING
use_case STRING
accept_by STRING
aws_stage STRING
next_step STRING
sale_stage STRING
postal_code STRING
business_unit STRING
campaign_name JSON
is_greenfield BOOL
aws_close_date STRING
customer_email STRING
customer_phone STRING
customer_website STRING
opportunity_type STRING
procurement_type STRING
rejection_reason STRING
contract_end_date STRING
target_close_date STRING
aws_sales_rep_name STRING
closed_lost_reason STRING
cloud_created_date STRING
customer_last_name STRING
last_modified_date STRING
additional_comments STRING
aws_sales_rep_email STRING
contract_start_date STRING
customer_first_name STRING
project_description STRING
apn_reviewer_comments STRING
customer_company_name STRING
opportunity_ownership STRING
partner_project_title STRING
primary_contact_email STRING
primary_contact_phone STRING
aws_account_owner_name STRING
other_solution_offered STRING
apn_disqualified_reason STRING
aws_account_owner_email STRING
customer_software_value FLOAT64
opportunity_owner_email STRING
apn_crm_unique_identifier STRING
partner_acceptance_status STRING
primary_contact_last_name STRING
primary_contact_first_name STRING
aws_isv_success_manager_name STRING
expected_monthly_aws_revenue FLOAT64
aws_isv_success_manager_email STRING
partner_primary_need_from_aws JSON
recommended_next_best_actions STRING
is_opp_from_marketing_activity BOOL
partner_developer_manager_name STRING
is_marketing_development_funded BOOL
partner_developer_manager_email STRING
aws_marketplace_engagement_score STRING
aws_partner_success_manager_name STRING
aws_partner_success_manager_email STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: analytics_aws_cosell_opportunities__offers

Section titled “Subtable: analytics_aws_cosell_opportunities__offers”
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: analytics_aws_cosell_opportunities__aws_products

Section titled “Subtable: analytics_aws_cosell_opportunities__aws_products”
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: analytics_aws_cosell_opportunities__delivery_model

Section titled “Subtable: analytics_aws_cosell_opportunities__delivery_model”
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: analytics_aws_cosell_opportunities__sales_activities

Section titled “Subtable: analytics_aws_cosell_opportunities__sales_activities”
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: analytics_aws_cosell_opportunities__solution_offered

Section titled “Subtable: analytics_aws_cosell_opportunities__solution_offered”
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: analytics_aws_cosell_opportunities__next_step_details

Section titled “Subtable: analytics_aws_cosell_opportunities__next_step_details”
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.
analytics_aws_marketplace_disbursements (65 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
currency STRING
offer_id STRING
invoice_id STRING
offer_name STRING
payer_city STRING
product_id STRING
listing_fee FLOAT64
agreement_id STRING
gross_refund FLOAT64
invoice_date STRING
product_code STRING
gross_revenue FLOAT64
payer_country STRING
payment_terms STRING
product_title STRING
isv_account_id STRING
wholesale_cost FLOAT64
subscriber_city STRING
isv_company_name STRING
offer_visibility STRING
payer_address_id STRING
payment_due_date STRING
seller_tax_share FLOAT64
disbursement_date STRING
payer_postal_code STRING
agreement_end_date STRING
listing_fee_refund FLOAT64
payer_company_name STRING
payer_email_domain STRING
seller_net_revenue FLOAT64
subscriber_country STRING
disbursement_period STRING
disbursement_status STRING
agreement_start_date STRING
aws_seller_of_record STRING
payer_aws_account_id STRING
customer_reference_id STRING
disbursed_net_revenue FLOAT64
payer_state_or_region STRING
reseller_company_name STRING
subscriber_address_id STRING
usage_period_end_date STRING
wholesale_cost_refund FLOAT64
disburse_bank_trace_id STRING
listing_fee_invoice_id STRING
listing_fee_percentage FLOAT64
subscriber_postal_code STRING
resale_authorization_id STRING
reseller_aws_account_id STRING
seller_tax_share_refund FLOAT64
subscriber_company_name STRING
subscriber_email_domain STRING
undisbursed_net_revenue FLOAT64
usage_period_start_date STRING
transaction_reference_id STRING
agreement_acceptance_date STRING
aws_tax_share_listing_fee FLOAT64
disbursement_time_in_days FLOAT64
resale_authorization_name STRING
subscriber_aws_account_id STRING
subscriber_state_or_region STRING
aws_tax_share_refund_listing_fee FLOAT64
resale_authorization_description STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_aws_marketplace_revenue (63 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
currency STRING
offer_id STRING
invoice_id STRING
offer_name STRING
payer_city STRING
product_id STRING
listing_fee FLOAT64
agreement_id STRING
gross_refund FLOAT64
invoice_date STRING
product_code STRING
aws_tax_share FLOAT64
gross_revenue FLOAT64
payer_country STRING
payment_terms STRING
product_title STRING
isv_account_id STRING
wholesale_cost FLOAT64
subscriber_city STRING
isv_company_name STRING
offer_visibility STRING
payer_address_id STRING
payment_due_date STRING
seller_tax_share FLOAT64
disbursement_date STRING
payer_postal_code STRING
agreement_end_date STRING
listing_fee_refund FLOAT64
payer_company_name STRING
payer_email_domain STRING
seller_net_revenue FLOAT64
subscriber_country STRING
disbursement_status STRING
agreement_start_date STRING
aws_seller_of_record STRING
aws_tax_share_refund FLOAT64
payer_aws_account_id STRING
customer_reference_id STRING
payer_state_or_region STRING
reseller_company_name STRING
subscriber_address_id STRING
usage_period_end_date STRING
wholesale_cost_refund FLOAT64
disburse_bank_trace_id STRING
listing_fee_invoice_id STRING
listing_fee_percentage FLOAT64
subscriber_postal_code STRING
resale_authorization_id STRING
reseller_aws_account_id STRING
seller_tax_share_refund FLOAT64
subscriber_company_name STRING
subscriber_email_domain STRING
usage_period_start_date STRING
transaction_reference_id STRING
agreement_acceptance_date STRING
aws_tax_share_listing_fee FLOAT64
resale_authorization_name STRING
subscriber_aws_account_id STRING
subscriber_state_or_region STRING
aws_tax_share_refund_listing_fee FLOAT64
resale_authorization_description STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_azure_cosell_opportunities (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
city STRING
uuid STRING
cloud STRING
notes STRING
state STRING
status STRING
address STRING
country STRING
is_spam BOOL
currency STRING
deal_name STRING
deal_type STRING
direction STRING
created_at STRING
deal_value FLOAT64
deleted_at STRING
row_number FLOAT64
sub_status STRING
updated_at STRING
external_id STRING
postal_code STRING
referral_id STRING
sales_stage STRING
cloud_status STRING
created_by_id FLOAT64
engagement_id STRING
qualification STRING
status_reason STRING
assistance_type STRING
azure_seller_id FLOAT64
external_status STRING
organization_id STRING
referral_source STRING
closed_date_time STRING
cloud_created_at STRING
customer_website STRING
is_macc_eligible BOOL
closing_date_time STRING
created_date_time STRING
organization_name STRING
seller_created_at STRING
updated_date_time STRING
accepted_date_time STRING
consent_to_contact BOOL
customer_duns_number STRING
domain_info_category STRING
expiration_date_time STRING
is_matching_complete BOOL
microsoft_account_id STRING
customer_company_name STRING
consent_to_to_share_info_with_others BOOL
consent_to_share_referral_with_microsoft_sellers BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: analytics_azure_cosell_opportunities__tags

Section titled “Subtable: analytics_azure_cosell_opportunities__tags”
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: analytics_azure_cosell_opportunities__target

Section titled “Subtable: analytics_azure_cosell_opportunities__target”
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_azure_cosell_opportunities__solutions

Section titled “Subtable: analytics_azure_cosell_opportunities__solutions”
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_azure_cosell_opportunities__partner_contacts

Section titled “Subtable: analytics_azure_cosell_opportunities__partner_contacts”
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_azure_cosell_opportunities__customer_contacts

Section titled “Subtable: analytics_azure_cosell_opportunities__customer_contacts”
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_azure_cosell_opportunities__microsoft_sales_reps

Section titled “Subtable: analytics_azure_cosell_opportunities__microsoft_sales_reps”
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.
analytics_azure_marketplace_customers (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku STRING
email STRING
plan_id STRING
offer_id STRING
date_lost STRING
is_active FLOAT64
last_name STRING
billing_id STRING
first_name STRING
offer_name STRING
offer_type STRING
customer_id STRING
multi_party FLOAT64
reference_id STRING
customer_city STRING
customer_type STRING
dataset_month STRING
date_acquired STRING
provider_name STRING
address_line_1 STRING
customer_state STRING
provider_email STRING
is_private_plan FLOAT64
plan_visibility STRING
purchaser_email STRING
last_modified_at STRING
private_offer_id STRING
azure_license_type STRING
billing_account_id STRING
private_offer_name STRING
customer_postal_code STRING
customer_company_name STRING
promotional_customers FLOAT64
commerce_root_customer STRING
customer_country_region STRING
marketplace_subscription_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_azure_marketplace_metered_usage (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku STRING
vmsize STRING
plan_id STRING
asset_id STRING
meter_id STRING
offer_id STRING
price_cc FLOAT64
core_size FLOAT64
raw_usage FLOAT64
billing_id STRING
offer_name STRING
offer_type STRING
usage_date STRING
usage_unit STRING
customer_id STRING
multi_party FLOAT64
reference_id STRING
customer_name STRING
dataset_month STRING
metered_usage FLOAT64
is_preview_sku FLOAT64
list_price_usd FLOAT64
vmsubscription FLOAT64
is_custom_meter FLOAT64
is_new_customer FLOAT64
is_private_plan FLOAT64
meter_dimension STRING
plan_visibility STRING
skubilling_type STRING
usage_reference STRING
customer_country STRING
is_multisolution FLOAT64
is_private_offer FLOAT64
month_start_date STRING
normalized_usage FLOAT64
offer_visibility STRING
private_offer_id STRING
deployment_method STRING
azure_license_type STRING
billing_account_id STRING
estimated_price_pc FLOAT64
payout_currency_pc STRING
private_offer_name STRING
cloud_instance_name STRING
customer_currency_cc STRING
discounted_price_usd FLOAT64
customer_company_name STRING
marketplace_license_type STRING
marketplace_subscription_id STRING
estimated_extended_charge_cc FLOAT64
estimated_extended_charge_pc FLOAT64
estimated_financial_impact_usd FLOAT64
partner_center_detected_anomaly FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_azure_marketplace_orders (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
sku STRING
plan_id STRING
asset_id STRING
currency STRING
is_trial FLOAT64
offer_id STRING
quantity FLOAT64
has_trial FLOAT64
auto_renew BOOL
billing_id STRING
offer_name STRING
offer_type STRING
customer_id STRING
multi_party FLOAT64
billing_plan STRING
billing_term STRING
order_action STRING
order_status STRING
reference_id STRING
dataset_month STRING
order_version STRING
term_end_date STRING
billed_revenue FLOAT64
is_preview_sku FLOAT64
list_price_usd STRING
trial_end_date STRING
event_timestamp STRING
is_new_customer FLOAT64
is_private_plan FLOAT64
plan_visibility STRING
term_start_date STRING
customer_country STRING
is_private_offer FLOAT64
month_start_date STRING
offer_visibility STRING
private_offer_id STRING
quantity_changed FLOAT64
order_cancel_date STRING
azure_license_type STRING
billing_account_id STRING
discount_price_usd FLOAT64
private_offer_name STRING
purchase_record_id STRING
cloud_instance_name STRING
order_purchase_date STRING
customer_company_name STRING
marketplace_license_type STRING
marketplace_subscription_id STRING
purchase_record_line_item_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_azure_marketplace_revenue (75 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku STRING
units STRING
plan_id STRING
revenue FLOAT64
asset_id STRING
offer_id STRING
quantity FLOAT64
billing_id STRING
earning_id STRING
invoice_id STRING
offer_name STRING
offer_type STRING
customer_id STRING
is_invoiced FLOAT64
multi_party FLOAT64
reseller_id STRING
invoice_date STRING
line_item_id STRING
billing_model STRING
customer_city STRING
customer_name STRING
dataset_month STRING
payout_status STRING
reseller_city STRING
sales_channel STRING
term_end_date STRING
customer_email STRING
customer_state STRING
incentive_rate FLOAT64
list_price_usd FLOAT64
reseller_email STRING
reseller_state STRING
adjustment_type STRING
is_private_plan FLOAT64
payout_currency STRING
plan_visibility STRING
term_start_date STRING
customer_country STRING
days_uncollected STRING
event_time_stamp STRING
exchange_rate_pc FLOAT64
invoice_due_date STRING
is_private_offer FLOAT64
month_start_date STRING
offer_visibility STRING
private_offer_id STRING
reseller_company STRING
reseller_country STRING
trial_deployment FLOAT64
earning_amount_cc FLOAT64
earning_amount_pc FLOAT64
exchange_rate_usd FLOAT64
payment_sent_date STRING
billing_account_id STRING
earning_amount_usd FLOAT64
exchange_rate_date STRING
private_offer_name STRING
purchase_record_id STRING
customer_postal_code STRING
discounted_price_usd FLOAT64
estimated_revenue_pc FLOAT64
reseller_postal_code STRING
transaction_currency STRING
customer_company_name STRING
earning_currency_code STRING
estimated_revenue_usd FLOAT64
transaction_amount_cc FLOAT64
transaction_amount_pc FLOAT64
adjustment_reason_code STRING
estimated_payout_month STRING
transaction_amount_usd FLOAT64
payment_instrument_type STRING
earning_exchange_rate_pc FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_gcp_marketplace_charges_and_usage (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ds STRING
sku STRING
units STRING
usage FLOAT64
charges FLOAT64
used_by STRING
currency STRING
location STRING
released FLOAT64
resource STRING
withheld FLOAT64
abandoned FLOAT64
trial_use FLOAT64
account_id STRING
due_partner FLOAT64
payment_type STRING
google_entity STRING
probation_end STRING
refund_reason STRING
prepay_credits FLOAT64
postpay_credits FLOAT64
probation_start STRING
payment_schedule STRING
billing_frequency STRING
refund_period_end STRING
insights_account_id STRING
refund_period_start STRING
refund_balance_outstanding FLOAT64
refund_balance_deducted_this_month FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_gcp_marketplace_daily_insights (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ds STRING
date STRING
unit STRING
usage FLOAT64
domain STRING
latest STRING
ram_mb FLOAT64
sku_id STRING
channel STRING
charges FLOAT64
company STRING
country STRING
num_vms FLOAT64
currency STRING
earliest STRING
end_date STRING
num_cpus FLOAT64
num_gpus FLOAT64
quote_id STRING
released FLOAT64
withheld FLOAT64
abandoned FLOAT64
gpu_types STRING
trial_use FLOAT64
account_id STRING
due_vendor FLOAT64
start_date STRING
offer_title STRING
postal_code STRING
payment_type STRING
internal_note STRING
probation_end STRING
quote_creator STRING
solution_name STRING
entitlement_id STRING
order_end_date STRING
prepay_credits FLOAT64
postpay_credits FLOAT64
probation_start STRING
sku_description STRING
machine_spec_sum STRING
order_start_date STRING
payment_schedule STRING
transaction_type STRING
billing_frequency STRING
installment_count FLOAT64
parent_account_id STRING
reseller_discount FLOAT64
state_or_province STRING
wholesale_charges FLOAT64
external_account_id STRING
final_installment_date STRING
first_installment_date STRING
term_total_contract_value FLOAT64
private_offer_acceptance_date STRING
private_offer_total_contract_value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_gcp_marketplace_disbursements (64 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ds STRING
domain STRING
sku_id STRING
channel STRING
country STRING
account_id STRING
usage_unit STRING
offer_title STRING
postal_code STRING
solution_id STRING
cust_charges FLOAT64
cust_identity STRING
refund_reason STRING
solution_name STRING
c_u_account_id STRING
entitlement_id STRING
order_end_date STRING
usage_quantity FLOAT64
organization_id STRING
released_amount FLOAT64
report_timezone FLOAT64
sku_description STRING
withheld_amount FLOAT64
abandoned_amount FLOAT64
cud_credits_used FLOAT64
discount_offered FLOAT64
last_refund_date STRING
order_start_date STRING
payment_schedule STRING
private_offer_id STRING
total_deductions FLOAT64
transaction_type STRING
aggregated_payout FLOAT64
billing_frequency STRING
cust_organization STRING
first_refund_date STRING
installment_count FLOAT64
reseller_discount FLOAT64
state_or_province STRING
wholesale_charges FLOAT64
trial_credits_used FLOAT64
disbursement_entity STRING
insights_account_id STRING
private_offer_notes STRING
entitlement_end_date STRING
max_usage_start_time STRING
min_usage_start_time STRING
probation_start_date STRING
report_creation_date STRING
total_contract_value FLOAT64
cust_remaining_commit STRING
private_offer_creator STRING
refund_processed_date STRING
entitlement_start_date STRING
final_installment_date STRING
first_installment_date STRING
marketplace_fee_amount FLOAT64
partner_testing_credit FLOAT64
marketplace_fee_percent STRING
replaced_private_offer_id STRING
term_total_contract_value FLOAT64
private_offer_acceptance_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_gcp_marketplace_disbursements_summary (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ds STRING
notes STRING
total FLOAT64
amount FLOAT64
entity STRING
currency STRING
withholding STRING
payment_type STRING
customer_refund FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_gcp_marketplace_incremental_daily_insights (59 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ds STRING
date STRING
unit STRING
usage FLOAT64
domain STRING
latest STRING
ram_mb FLOAT64
sku_id STRING
channel STRING
charges FLOAT64
company STRING
country STRING
num_vms FLOAT64
currency STRING
earliest STRING
end_date STRING
num_cpus FLOAT64
num_gpus FLOAT64
quote_id STRING
released FLOAT64
withheld FLOAT64
abandoned FLOAT64
gpu_types STRING
trial_use FLOAT64
account_id STRING
due_vendor FLOAT64
start_date STRING
offer_title STRING
postal_code STRING
report_date STRING
payment_type STRING
internal_note STRING
probation_end STRING
quote_creator STRING
solution_name STRING
entitlement_id STRING
order_end_date STRING
prepay_credits FLOAT64
postpay_credits FLOAT64
probation_start STRING
sku_description STRING
machine_spec_sum STRING
order_start_date STRING
payment_schedule STRING
transaction_type STRING
billing_frequency STRING
installment_count FLOAT64
parent_account_id STRING
reseller_discount FLOAT64
state_or_province STRING
wholesale_charges FLOAT64
external_account_id STRING
final_installment_date STRING
first_installment_date STRING
term_total_contract_value FLOAT64
private_offer_acceptance_date STRING
private_offer_total_contract_value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_gcp_marketplace_incremental_monthly_insights (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ds STRING
date STRING
unit STRING
usage FLOAT64
domain STRING
latest FLOAT64
ram_mb FLOAT64
sku_id STRING
channel STRING
charges FLOAT64
company STRING
country STRING
num_vms FLOAT64
currency STRING
earliest STRING
end_date STRING
num_cpus FLOAT64
num_gpus FLOAT64
quote_id STRING
released FLOAT64
withheld FLOAT64
abandoned FLOAT64
gpu_types STRING
trial_use FLOAT64
account_id STRING
due_vendor FLOAT64
start_date STRING
offer_title STRING
postal_code STRING
report_date STRING
payment_type STRING
internal_note STRING
probation_end STRING
quote_creator STRING
solution_name STRING
entitlement_id STRING
order_end_date STRING
prepay_credits FLOAT64
postpay_credits FLOAT64
probation_start FLOAT64
sku_description STRING
machine_spec_sum STRING
order_start_date STRING
payment_schedule STRING
transaction_type STRING
billing_frequency STRING
installment_count FLOAT64
parent_account_id STRING
reseller_discount FLOAT64
state_or_province STRING
wholesale_charges FLOAT64
external_account_id STRING
final_installment_date STRING
first_installment_date STRING
private_offer_acceptance_date STRING
private_offer_total_contract_value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
analytics_gcp_marketplace_monthly_insights (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ds STRING
date STRING
unit STRING
usage FLOAT64
domain STRING
latest STRING
ram_mb FLOAT64
sku_id STRING
channel STRING
charges FLOAT64
company STRING
country STRING
num_vms FLOAT64
currency STRING
earliest STRING
end_date STRING
num_cpus FLOAT64
num_gpus FLOAT64
quote_id STRING
released FLOAT64
withheld FLOAT64
abandoned FLOAT64
gpu_types STRING
trial_use FLOAT64
account_id STRING
due_vendor FLOAT64
start_date STRING
offer_title STRING
postal_code STRING
payment_type STRING
internal_note STRING
probation_end STRING
quote_creator STRING
solution_name STRING
entitlement_id STRING
order_end_date STRING
prepay_credits FLOAT64
postpay_credits FLOAT64
probation_start STRING
sku_description STRING
machine_spec_sum STRING
order_start_date STRING
payment_schedule STRING
transaction_type STRING
billing_frequency STRING
installment_count FLOAT64
parent_account_id STRING
reseller_discount FLOAT64
state_or_province STRING
wholesale_charges FLOAT64
external_account_id STRING
final_installment_date STRING
first_installment_date STRING
private_offer_acceptance_date STRING
private_offer_total_contract_value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
buyers (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
cloud STRING
domain STRING
status STRING
listing_id STRING
cloud_account_id STRING
last_modified_at STRING
latest_contract_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contracts (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
cloud STRING
end_at STRING
status STRING
buyer_id STRING
cloud_id STRING
duration STRING
start_at STRING
cloud_url STRING
auto_renew BOOL
listing_id STRING
offer_type STRING
accepted_at STRING
latest_offer_id STRING
last_modified_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
listings (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
cloud STRING
title STRING
status STRING
cloud_id STRING
eula_url STRING
cloud_url STRING
eula_type STRING
last_modified_at STRING
long_description STRING
short_description STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
opportunities (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
cloud STRING
stage STRING
title STRING
status STRING
cloud_id STRING
accept_by STRING
cloud_url STRING
created_at STRING
customer_company STRING
customer_website STRING
last_modified_at STRING
target_close_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
private_offers (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
cloud STRING
status STRING
archived STRING
cloud_id STRING
duration STRING
cloud_url STRING
eula_type STRING
listing_id STRING
offer_type STRING
accepted_at STRING
published_at STRING
expiration_at STRING
last_modified_at 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 Clazar 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 Clazar?

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

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

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

Use the marketplace revenue and disbursement tables to track income across clouds.

Join opportunities and private_offers to follow co-sell deals to close.

Use listings and contracts to see which offers drive the most revenue.

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