Skip to content
Book a demoStart free
Connectors

Square connector

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

Square connector pricing, tier and credits on kaivo.io

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

Sync your Square sales data into BigQuery with Kaivo to analyse payments, orders, and customers across your locations.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Square 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
The API key for a Square application.

|

When you set up the connector, you provide:

Field Description
Sandbox
Connect to the Square sandbox environment instead of production.

| | Start Date |

Any data before this date will not be fetched.

| | Include Deleted Objects |

Include deleted objects (Items, Categories, Discounts, Taxes) in applicable streams.

|

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

bank_accounts (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
account_number_suffix STRING
account_type STRING
bank_name STRING
country STRING
creditable BOOL
currency STRING
debitable BOOL
holder_name STRING
id STRING
location_id STRING
primary_bank_identification_number STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
cash_drawers (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
closed_at STRING
closed_cash_money__amount FLOAT64
closed_cash_money__currency STRING
ended_at STRING
expected_cash_money__amount FLOAT64
expected_cash_money__currency STRING
id STRING
opened_at STRING
opened_cash_money__amount FLOAT64
opened_cash_money__currency STRING
state STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
categories (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
type STRING
category_data__name STRING
id STRING
is_deleted BOOL
present_at_all_locations BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
address__address_line_1 STRING
address__address_line_2 STRING
address__administrative_district_level_1 STRING
address__locality STRING
address__postal_code STRING
birthday STRING
company_name STRING
created_at STRING
creation_source STRING
email_address STRING
family_name STRING
given_name STRING
id STRING
phone_number STRING
preferences__email_unsubscribed BOOL
reference_id 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.
billing_address__postal_code STRING
card_brand STRING
cardholder_name STRING
exp_month INT64
exp_year INT64
id STRING
last_4 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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
discounts (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
type STRING
discount_data__amount_money__amount INT64
discount_data__amount_money__currency STRING
discount_data__application_method STRING
discount_data__discount_type STRING
discount_data__modify_tax_basis STRING
discount_data__name STRING
discount_data__percentage STRING
discount_data__pin_required BOOL
id STRING
is_deleted BOOL
present_at_all_locations BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: discounts__present_at_location_ids

Section titled “Subtable: discounts__present_at_location_ids”
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.
inventory (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
calculated_at STRING
catalog_object_id STRING
catalog_object_type STRING
location_id STRING
quantity STRING
state STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
items (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
type STRING
id STRING
image_id STRING
is_deleted BOOL
item_data__description STRING
item_data__category_id STRING
item_data__ecom_visibility STRING
item_data__name STRING
item_data__product_type STRING
item_data__skip_modifier_screen BOOL
item_data__visibility STRING
present_at_all_locations BOOL
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.
item_option_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: items__item_data__modifier_list_info

Section titled “Subtable: items__item_data__modifier_list_info”
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.
enabled BOOL
max_selected_modifiers INT64
min_selected_modifiers INT64
modifier_list_id STRING
visibility 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.
version INT64
type STRING
id STRING
is_deleted BOOL
item_variation_data__item_id STRING
item_variation_data__name STRING
item_variation_data__ordinal INT64
item_variation_data__price_money__amount INT64
item_variation_data__price_money__currency STRING
item_variation_data__pricing_type STRING
item_variation_data__sku STRING
present_at_all_locations BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: items__item_data__variations__item_variation_data__item_option_values

Section titled “Subtable: items__item_data__variations__item_variation_data__item_option_values”
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.
item_option_id STRING
item_option_value_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: items__item_data__variations__item_variation_data__location_overrides

Section titled “Subtable: items__item_data__variations__item_variation_data__location_overrides”
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.
location_id STRING
track_inventory BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: items__item_data__variations__present_at_location_ids

Section titled “Subtable: items__item_data__variations__present_at_location_ids”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
locations (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
address__address_line_1 STRING
address__administrative_district_level_1 STRING
address__country STRING
address__locality STRING
address__postal_code STRING
business_email STRING
business_name STRING
country STRING
created_at STRING
currency STRING
facebook_url STRING
id STRING
instagram_username STRING
language_code STRING
mcc STRING
merchant_id STRING
name STRING
phone_number STRING
status STRING
timezone STRING
twitter_username STRING
website_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.
loyalty (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
balance FLOAT64
created_at STRING
customer_id STRING
id STRING
lifetime_points FLOAT64
mapping__created_at STRING
mapping__id STRING
mapping__phone_number STRING
program_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
modifier_list (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
type STRING
id STRING
is_deleted BOOL
modifier_list_data__name STRING
modifier_list_data__selection_type STRING
present_at_all_locations BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: modifier_list__modifier_list_data__modifiers

Section titled “Subtable: modifier_list__modifier_list_data__modifiers”
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.
version INT64
type STRING
id STRING
is_deleted BOOL
modifier_data__modifier_list_id STRING
modifier_data__name STRING
modifier_data__on_by_default BOOL
modifier_data__ordinal INT64
modifier_data__price_money__amount INT64
modifier_data__price_money__currency STRING
present_at_all_locations BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
orders (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
closed_at STRING
created_at STRING
customer_id STRING
id STRING
location_id STRING
net_amounts__discount_money__amount INT64
net_amounts__discount_money__currency STRING
net_amounts__service_charge_money__amount INT64
net_amounts__service_charge_money__currency STRING
net_amounts__tax_money__amount INT64
net_amounts__tax_money__currency STRING
net_amounts__tip_money__amount INT64
net_amounts__tip_money__currency STRING
net_amounts__total_money__amount INT64
net_amounts__total_money__currency STRING
return_amounts__discount_money__amount INT64
return_amounts__discount_money__currency STRING
return_amounts__service_charge_money__amount INT64
return_amounts__service_charge_money__currency STRING
return_amounts__tax_money__amount INT64
return_amounts__tax_money__currency STRING
return_amounts__tip_money__amount INT64
return_amounts__tip_money__currency STRING
return_amounts__total_money__amount INT64
return_amounts__total_money__currency STRING
source__name STRING
state STRING
total_discount_money__amount INT64
total_discount_money__currency STRING
total_money__amount INT64
total_money__currency STRING
total_service_charge_money__amount INT64
total_service_charge_money__currency STRING
total_tax_money__amount INT64
total_tax_money__currency STRING
total_tip_money__amount INT64
total_tip_money__currency 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.
type STRING
applied_money__amount INT64
applied_money__currency STRING
name STRING
percentage STRING
scope STRING
uid 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
pickup_details__accepted_at STRING
pickup_details__auto_complete_duration STRING
pickup_details__expires_at STRING
pickup_details__note STRING
pickup_details__picked_up_at STRING
pickup_details__pickup_at STRING
pickup_details__placed_at STRING
pickup_details__ready_at STRING
pickup_details__recipient__display_name STRING
pickup_details__recipient__phone_number STRING
pickup_details__schedule_type STRING
shipment_details__carrier STRING
shipment_details__expected_shipped_at STRING
shipment_details__in_progress_at STRING
shipment_details__packaged_at STRING
shipment_details__placed_at STRING
shipment_details__recipient__address__address_line_1 STRING
shipment_details__recipient__address__administrative_district_level_1 STRING
shipment_details__recipient__address__locality STRING
shipment_details__recipient__address__postal_code STRING
shipment_details__recipient__display_name STRING
shipment_details__recipient__phone_number STRING
shipment_details__shipped_at STRING
shipment_details__tracking_number STRING
state STRING
uid 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.
base_price_money__amount INT64
base_price_money__currency STRING
catalog_object_id STRING
gross_sales_money__amount INT64
gross_sales_money__currency STRING
item_type STRING
name STRING
note STRING
quantity STRING
total_discount_money__amount INT64
total_discount_money__currency STRING
total_money__amount INT64
total_money__currency STRING
total_tax_money__amount INT64
total_tax_money__currency STRING
uid STRING
variation_name STRING
variation_total_price_money__amount INT64
variation_total_price_money__currency STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: orders__line_items__applied_discounts

Section titled “Subtable: orders__line_items__applied_discounts”
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.
applied_money__amount INT64
applied_money__currency STRING
discount_uid STRING
uid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: orders__line_items__applied_taxes

Section titled “Subtable: orders__line_items__applied_taxes”
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.
applied_money__amount INT64
applied_money__currency STRING
tax_uid STRING
uid 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.
base_price_money__amount INT64
base_price_money__currency STRING
catalog_object_id STRING
name STRING
total_price_money__amount INT64
total_price_money__currency STRING
uid 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.
amount_money__amount INT64
amount_money__currency STRING
created_at STRING
id STRING
location_id STRING
reason STRING
status STRING
tender_id STRING
transaction_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.
source_order_id STRING
uid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: orders__returns__return_line_items

Section titled “Subtable: orders__returns__return_line_items”
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.
base_price_money__amount INT64
base_price_money__currency STRING
gross_return_money__amount INT64
gross_return_money__currency STRING
item_type STRING
quantity STRING
total_discount_money__amount INT64
total_discount_money__currency STRING
total_money__amount INT64
total_money__currency STRING
total_tax_money__amount INT64
total_tax_money__currency STRING
uid STRING
variation_total_price_money__amount INT64
variation_total_price_money__currency 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.
amount_money__amount INT64
amount_money__currency STRING
applied_money__amount INT64
applied_money__currency STRING
calculation_phase STRING
name STRING
taxable BOOL
total_money__amount INT64
total_money__currency STRING
total_tax_money__amount INT64
total_tax_money__currency STRING
uid 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
applied_money__amount INT64
applied_money__currency STRING
catalog_object_id STRING
name STRING
percentage STRING
scope STRING
uid 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
amount_money__amount INT64
amount_money__currency STRING
card_details__card__card_brand STRING
card_details__card__fingerprint STRING
card_details__card__last_4 STRING
card_details__entry_method STRING
card_details__status STRING
cash_details__buyer_tendered_money__amount INT64
cash_details__buyer_tendered_money__currency STRING
cash_details__change_back_money__amount INT64
cash_details__change_back_money__currency STRING
created_at STRING
id STRING
location_id STRING
note STRING
payment_id STRING
transaction_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payments (44 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_money__amount INT64
amount_money__currency STRING
approved_money__amount INT64
approved_money__currency STRING
card_details__avs_status STRING
card_details__card__bin STRING
card_details__card__card_brand STRING
card_details__card__card_type STRING
card_details__card__exp_month INT64
card_details__card__exp_year INT64
card_details__card__fingerprint STRING
card_details__card__last_4 STRING
card_details__card__prepaid_type STRING
card_details__card_payment_timeline__authorized_at STRING
card_details__card_payment_timeline__captured_at STRING
card_details__card_payment_timeline__voided_at STRING
card_details__cvv_status STRING
card_details__entry_method STRING
card_details__statement_description STRING
card_details__status STRING
created_at STRING
customer_id STRING
delay_action STRING
delay_duration STRING
delayed_until STRING
employee_id STRING
id STRING
location_id STRING
note STRING
order_id STRING
receipt_number STRING
receipt_url STRING
refunded_money__amount INT64
refunded_money__currency STRING
risk_evaluation__created_at STRING
risk_evaluation__risk_level STRING
source_type STRING
status STRING
total_money__amount INT64
total_money__currency STRING
updated_at STRING
version_token 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
amount_money__amount INT64
amount_money__currency STRING
effective_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.
refunds (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_money__amount INT64
amount_money__currency STRING
created_at STRING
id STRING
location_id STRING
order_id STRING
payment_id STRING
reason STRING
status 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.
type STRING
amount_money__amount INT64
amount_money__currency STRING
effective_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shifts (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
created_at STRING
employee_id STRING
end_at STRING
id STRING
location_id STRING
start_at STRING
status STRING
team_member_id STRING
timezone STRING
updated_at STRING
wage__hourly_rate__amount INT64
wage__hourly_rate__currency STRING
wage__title 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.
break_type_id STRING
end_at STRING
expected_duration STRING
id STRING
is_paid BOOL
name STRING
start_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
taxes (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64
type STRING
id STRING
is_deleted BOOL
present_at_all_locations BOOL
tax_data__applies_to_custom_amounts BOOL
tax_data__calculation_phase STRING
tax_data__enabled BOOL
tax_data__inclusion_type STRING
tax_data__name STRING
tax_data__percentage STRING
tax_data__tax_type_id STRING
tax_data__tax_type_name 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.
team_member_wages (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
hourly_rate__amount INT64
hourly_rate__currency STRING
id STRING
team_member_id STRING
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
team_members (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assigned_locations__assignment_type STRING
created_at STRING
email_address STRING
family_name STRING
given_name STRING
id STRING
is_owner BOOL
phone_number STRING
reference_id STRING
status STRING
updated_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 Square 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 Square?

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

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

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

Combine payments and orders to track revenue and average sale over time and by location.

Join orders with items and categories to see best sellers and margin.

Use shifts and team_member_wages to compare labour cost against sales.

Bring customers and loyalty together to measure repeat visits and rewards.

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