Younium connector

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

Written By Lauri Raivio

Last updated 16 days ago

Kaivo is a fully managed data platform that syncs your Younium 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.

What is the Younium connector

Sync your Younium subscription data into BigQuery with Kaivo to analyse subscriptions, invoices, and recurring revenue.

Category	Finance & Payments
Authentication	API key
Setup	Self-service

Getting started with the Younium connector

Sign up for Kaivo and create a workspace.
Connect your Younium account.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Younium

Authenticate with your Secret Key.

Field	Description
Secret Key	The Secret Key shown alongside the Client ID when you create the Younium personal token. Copy it immediately — it is only shown once.

Configuring the Younium connector

When you set up the connector, you provide:

Field	Description
Client ID	The Client ID of your Younium API credentials. Generate a client token under your Younium profile → Privacy & Security → Personal Tokens. A dedicated integration user is recommended.
Legal Entity	The Younium legal entity (ID or name) to pull data from. Sent as the 'legal-entity' request header.

Tables and columns synced from Younium

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

account (46 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`account_number`	`STRING`	The unique identifier for the account.
`account_type`	`STRING`	The type of the account.
`accounts_receivable`	`STRING`	The total accounts receivable amount.
`acv__amount`	`FLOAT64`	ACV amount.
`acv__base_currency_amount`	`FLOAT64`	ACV amount in base currency.
`acv__base_currency_code`	`STRING`	Base currency code for ACV.
`acv__currency_code`	`STRING`	Currency code for ACV.
`cmrr__amount`	`FLOAT64`	CMRR amount.
`cmrr__base_currency_amount`	`FLOAT64`	CMRR amount in base currency.
`cmrr__base_currency_code`	`STRING`	Base currency code for CMRR.
`cmrr__currency_code`	`STRING`	Currency code for CMRR.
`created`	`STRING`	Date and time when the account was created.
`currency_code`	`STRING`	Currency code used for transactions.
`default_delivery_address__country`	`STRING`	Country of the default delivery address.
`default_delivery_address__id`	`STRING`	Unique identifier for the default delivery address.
`default_invoice_address__city`	`STRING`	City of the default invoice address.
`default_invoice_address__country`	`STRING`	Country of the default invoice address.
`default_invoice_address__description`	`STRING`	Description of the default invoice address.
`default_invoice_address__id`	`STRING`	Unique identifier for the default invoice address.
`default_invoice_address__street`	`STRING`	Street of the default invoice address.
`default_invoice_address__zip`	`STRING`	ZIP or postal code of the default invoice address.
`default_payment_term`	`STRING`	Default payment term for the account.
`emrr__amount`	`FLOAT64`	EMRR amount.
`emrr__base_currency_amount`	`FLOAT64`	EMRR amount in base currency.
`emrr__base_currency_code`	`STRING`	Base currency code for EMRR.
`emrr__currency_code`	`STRING`	Currency code for EMRR.
`id`	`STRING`	Unique identifier for the account.
`inactive`	`BOOL`	Indicates if the account is inactive.
`invoice_delivery_method`	`STRING`	Preferred method of delivery for invoices.
`invoice_template_id`	`STRING`	Unique identifier for the invoice template used.
`modified`	`STRING`	Date and time when the account was last modified.
`name`	`STRING`	Name of the account.
`one_time_fees__amount`	`FLOAT64`	One-time fees amount.
`one_time_fees__base_currency_amount`	`FLOAT64`	One-time fees amount in base currency.
`one_time_fees__base_currency_code`	`STRING`	Base currency code for one-time fees.
`one_time_fees__currency_code`	`STRING`	Currency code for one-time fees.
`organization_number`	`STRING`	The organization number associated with the account.
`our_reference`	`STRING`	Our reference for the account.
`tax_registration_number`	`STRING`	Tax registration number for the account.
`tax_template`	`STRING`	Tax template applied to the account.
`tcv__amount`	`FLOAT64`	TCV amount.
`tcv__base_currency_amount`	`FLOAT64`	TCV amount in base currency.
`tcv__base_currency_code`	`STRING`	Base currency code for TCV.
`tcv__currency_code`	`STRING`	Currency code for TCV.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: account__addresses

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.
`city`	`STRING`	City of the address.
`country`	`STRING`	Country of the address.
`description`	`STRING`	Description of the address.
`id`	`STRING`	Unique identifier for the address.
`street`	`STRING`	Street of the address.
`zip`	`STRING`	ZIP or postal code of the address.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

booking (28 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`account_category`	`STRING`	Category of the account
`acv__amount`	`FLOAT64`	ACV amount
`acv__amount_in_base_currency`	`FLOAT64`	ACV amount in base currency
`booking_type`	`STRING`	Type of booking
`change_type`	`STRING`	Type of change
`classification__chart_color`	`STRING`	Color for classification in a chart
`classification__classification_type`	`STRING`	Type of classification
`classification__description`	`STRING`	Classification description
`classification__is_system_classification`	`BOOL`	Flag indicating if the classification is a system classification
`classification__name`	`STRING`	Classification name
`cmrr__amount`	`FLOAT64`	CMRR amount
`cmrr__amount_in_base_currency`	`FLOAT64`	CMRR amount in base currency
`created`	`STRING`	Date of creation
`effective_date`	`STRING`	Effective date of the booking
`emrr__amount`	`FLOAT64`	EMRR amount
`emrr__amount_in_base_currency`	`FLOAT64`	EMRR amount in base currency
`fmrr__amount`	`FLOAT64`	FMRR amount
`fmrr__amount_in_base_currency`	`FLOAT64`	FMRR amount in base currency
`id`	`STRING`	Unique identifier for the booking
`modified`	`STRING`	Date of modification
`one_time_fees__amount`	`FLOAT64`	One-time fees amount
`one_time_fees__amount_in_base_currency`	`FLOAT64`	One-time fees amount in base currency
`order__id`	`STRING`	Order ID
`order__order_number`	`STRING`	Order number
`tcv__amount`	`FLOAT64`	TCV amount
`tcv__amount_in_base_currency`	`FLOAT64`	TCV amount in base currency
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: booking__booking_lines

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.
`acv__amount`	`FLOAT64`	ACV amount
`acv__base_currency_amount`	`FLOAT64`	ACV amount in base currency
`acv__base_currency_code`	`STRING`	Base currency code for ACV
`acv__currency_code`	`STRING`	Currency code for ACV
`acv__currency_conversion_date`	`STRING`	Date of currency conversion for ACV
`charge__charge_number`	`STRING`	Charge number
`charge__description`	`STRING`	Charge description
`charge__id`	`STRING`	Charge ID
`charge__name`	`STRING`	Charge name
`cmrr__amount`	`FLOAT64`	CMRR amount
`cmrr__base_currency_amount`	`FLOAT64`	CMRR amount in base currency
`cmrr__base_currency_code`	`STRING`	Base currency code for CMRR
`cmrr__currency_code`	`STRING`	Currency code for CMRR
`cmrr__currency_conversion_date`	`STRING`	Date of currency conversion for CMRR
`created`	`STRING`	Date of creation
`emrr__amount`	`FLOAT64`	EMRR amount
`emrr__base_currency_amount`	`FLOAT64`	EMRR amount in base currency
`emrr__base_currency_code`	`STRING`	Base currency code for EMRR
`emrr__currency_code`	`STRING`	Currency code for EMRR
`emrr__currency_conversion_date`	`STRING`	Date of currency conversion for EMRR
`fmrr__amount`	`FLOAT64`	FMRR amount
`fmrr__base_currency_amount`	`FLOAT64`	FMRR amount in base currency
`fmrr__base_currency_code`	`STRING`	Base currency code for FMRR
`fmrr__currency_code`	`STRING`	Currency code for FMRR
`fmrr__currency_conversion_date`	`STRING`	Date of currency conversion for FMRR
`modified`	`STRING`	Date of modification
`one_time_fees__amount`	`FLOAT64`	One-time fees amount
`one_time_fees__base_currency_amount`	`FLOAT64`	One-time fees amount in base currency
`one_time_fees__base_currency_code`	`STRING`	Base currency code for one-time fees
`one_time_fees__currency_code`	`STRING`	Currency code for one-time fees
`one_time_fees__currency_conversion_date`	`STRING`	Date of currency conversion for one-time fees
`tcv__amount`	`FLOAT64`	TCV amount
`tcv__base_currency_amount`	`FLOAT64`	TCV amount in base currency
`tcv__base_currency_code`	`STRING`	Base currency code for TCV
`tcv__currency_code`	`STRING`	Currency code for TCV
`tcv__currency_conversion_date`	`STRING`	Date of currency conversion for TCV
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

invoice (69 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`STRING`	Unique identifier for the invoice
`invoice_number`	`STRING`	Unique invoice number
`status`	`STRING`	Current status of the invoice
`created`	`STRING`	Timestamp for when the invoice was created
`invoice_delivery_method`	`STRING`	Delivery method for sending the invoice
`modified`	`STRING`	Timestamp for when the invoice was last modified
`account__name`	`STRING`	Name of the account
`account__account_number`	`STRING`	The account number
`account__id`	`STRING`	Unique identifier for the account
`account__external_erp_id`	`STRING`	External ERP ID for the account
`account__external_crm_id`	`STRING`	External CRM ID for the account
`notes`	`STRING`	Additional notes or comments related to the invoice
`invoice_date`	`STRING`	Date when the invoice was issued
`due_date`	`STRING`	Due date for the invoice payment
`days_past_due`	`FLOAT64`	Number of days past due for the invoice payment
`nr_of_reminders`	`FLOAT64`	Number of reminders sent for the invoice
`payment_term__id`	`STRING`	Unique identifier for the payment term
`payment_term__days`	`FLOAT64`	Number of days for the payment term
`payment_term__name`	`STRING`	Name of the payment term
`currency`	`STRING`	Currency used in the invoice
`subtotal`	`FLOAT64`	Subtotal amount of the invoice
`tax`	`FLOAT64`	Total tax amount for the invoice
`total_amount`	`FLOAT64`	Total amount of the invoice including tax
`total_rounding_amount`	`FLOAT64`	Rounded amount in the total calculation
`settled_amount`	`FLOAT64`	Amount that has been settled for the invoice
`balanced_amount`	`FLOAT64`	The total balanced amount in the invoice
`tax_included`	`BOOL`	Flag to indicate if tax is included in the total amount
`invoice_address__id`	`STRING`	Unique identifier for the invoice address
`invoice_address__description`	`STRING`	Additional description for the invoice address
`invoice_address__name`	`STRING`	Name associated with the invoice address
`invoice_address__street`	`STRING`	Street address in the invoice address
`invoice_address__street2`	`STRING`	Additional street details in the invoice address
`invoice_address__city`	`STRING`	City in the invoice address
`invoice_address__county`	`STRING`	County in the invoice address
`invoice_address__state`	`STRING`	State in the invoice address
`invoice_address__zip`	`STRING`	Zip code in the invoice address
`invoice_address__country`	`STRING`	Country in the invoice address
`delivery_address__id`	`STRING`	Unique identifier for the delivery address
`delivery_address__description`	`STRING`	Additional description for the delivery address
`delivery_address__name`	`STRING`	Name associated with the delivery address
`delivery_address__street`	`STRING`	Street address in the delivery address
`delivery_address__street2`	`STRING`	Additional street details in the delivery address
`delivery_address__city`	`STRING`	City in the delivery address
`delivery_address__county`	`STRING`	County in the delivery address
`delivery_address__state`	`STRING`	State in the delivery address
`delivery_address__zip`	`STRING`	Zip code in the delivery address
`delivery_address__country`	`STRING`	Country in the delivery address
`invoice_batch_id`	`STRING`	Identifier for the batch of invoices
`your_reference`	`STRING`	Reference provided by the buyer
`our_reference`	`STRING`	Reference provided by the company
`your_order_number`	`STRING`	Order number specified by the buyer
`buyer_reference`	`STRING`	Reference information provided by the buyer
`invoice_type`	`STRING`	Type of the invoice
`send_method`	`STRING`	Method used for sending the invoice
`exchange_rate`	`FLOAT64`	Exchange rate used in the invoice
`settled_notes`	`STRING`	Notes related to the settled amount
`invoice_template_id`	`STRING`	Identifier for the invoice template used
`disable_automatic_invoice_reminder`	`BOOL`	Flag to indicate if automatic invoice reminders are disabled
`online_payment_link`	`STRING`	Link for online payment of the invoice
`accounts_receivable__id`	`STRING`	Unique identifier for the accounts receivable
`accounts_receivable__code`	`STRING`	Code for the accounts receivable
`accounts_receivable__name`	`STRING`	Name of the accounts receivable
`accounts_receivable__description`	`STRING`	Description of the accounts receivable
`accounts_receivable__external_erp_id`	`STRING`	External ERP ID for the accounts receivable
`accounts_receivable__external_crm_id`	`STRING`	External CRM ID for the accounts receivable
`external_erp_id`	`STRING`	External ERP ID for the invoice
`external_crm_id`	`STRING`	External CRM ID for the invoice
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoice__invoice_lines

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`	Unique identifier for the line item
`invoice_line_number`	`FLOAT64`	Line number in the invoice for the item
`product_number`	`STRING`	Product number for the line item
`product_name`	`STRING`	Name of the product for the line item
`charge_description`	`STRING`	Description of the charge for the line item
`charge_number`	`STRING`	Charge number for the line item
`quantity`	`FLOAT64`	Quantity of the product in the line item
`unit_of_measure__id`	`STRING`	Unique identifier for the unit of measure
`unit_of_measure__unit_code`	`STRING`	Code representing the unit of measure
`unit_of_measure__name`	`STRING`	Name of the unit of measure
`unit_of_measure__display_name`	`STRING`	Display name of the unit of measure
`price`	`FLOAT64`	Price of the line item
`subtotal`	`FLOAT64`	Subtotal amount for the line item
`total`	`FLOAT64`	Total amount for the line item
`tax`	`FLOAT64`	Tax amount for the line item
`service_period_start_date`	`STRING`	Start date of the service period for the line item
`service_period_end_date`	`STRING`	End date of the service period for the line item
`notes`	`STRING`	Additional notes for the line item
`order_charge_id`	`STRING`	Identifier for the order charge related to the line item
`order_id`	`STRING`	Identifier for the order related to the line item
`account_id`	`STRING`	Unique identifier for the account associated with the line item
`accounts_receivable__id`	`STRING`	Unique identifier for the accounts receivable
`accounts_receivable__code`	`STRING`	Code for the accounts receivable
`accounts_receivable__name`	`STRING`	Name of the accounts receivable
`accounts_receivable__description`	`STRING`	Description of the accounts receivable
`accounts_receivable__external_erp_id`	`STRING`	External ERP ID for the accounts receivable
`accounts_receivable__external_crm_id`	`STRING`	External CRM ID for the accounts receivable
`deferred_revenue__id`	`STRING`	Unique identifier for the deferred revenue
`deferred_revenue__code`	`STRING`	Code for the deferred revenue
`deferred_revenue__name`	`STRING`	Name of the deferred revenue
`deferred_revenue__description`	`STRING`	Description of the deferred revenue
`deferred_revenue__external_erp_id`	`STRING`	External ERP ID for the deferred revenue
`deferred_revenue__external_crm_id`	`STRING`	External CRM ID for the deferred revenue
`recognized_revenue__id`	`STRING`	Unique identifier for the recognized revenue
`recognized_revenue__code`	`STRING`	Code for the recognized revenue
`recognized_revenue__name`	`STRING`	Name of the recognized revenue
`recognized_revenue__description`	`STRING`	Description of the recognized revenue
`recognized_revenue__external_erp_id`	`STRING`	External ERP ID for the recognized revenue
`recognized_revenue__external_crm_id`	`STRING`	External CRM ID for the recognized revenue
`external_erp_id`	`STRING`	External ERP ID for the line item
`external_crm_id`	`STRING`	External CRM ID for the line item
`tax_category_name`	`STRING`	Name of the tax category
`tax_rate`	`FLOAT64`	Tax rate applied to the line item
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

product (16 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`STRING`	The unique identifier for the product.
`product_number`	`STRING`	The unique number associated with the product.
`name`	`STRING`	The name of the product.
`created`	`STRING`	The date when the product was created.
`modified`	`STRING`	The date when the product was last modified.
`product_type`	`STRING`	The type of product.
`category`	`STRING`	The category the product belongs to.
`activation_date`	`STRING`	The date when the product is activated.
`end_of_new_sales_date`	`STRING`	The end date for new sales of the product.
`end_of_renewal_date`	`STRING`	The end date for product renewals.
`end_of_life_date`	`STRING`	The end of life date for the product.
`is_framework_product`	`BOOL`	Indicates if the product is a framework product.
`external_erp_id`	`STRING`	The ID from an external ERP system.
`external_crm_id`	`STRING`	The ID from an external CRM system.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: product__charge_plans

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`	The unique identifier for the charge plan.
`charge_plan_number`	`STRING`	The number associated with the charge plan.
`name`	`STRING`	The name of the charge plan.
`effective_start_date`	`STRING`	The date when the charge plan becomes effective.
`end_of_new_sales_date`	`STRING`	The end date for new sales of the charge plan.
`effective_end_date`	`STRING`	The date when the charge plan is no longer effective.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: product__charge_plans__charges

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`	The unique identifier for the charge.
`charge_number`	`STRING`	The number associated with the charge.
`name`	`STRING`	The name of the charge.
`model`	`STRING`	The model associated with the charge.
`charge_type`	`STRING`	The type of charge.
`unit_code`	`STRING`	The unit code for the charge.
`default_quantity`	`FLOAT64`	The default quantity for the charge.
`price_period`	`STRING`	The period for pricing.
`usage_rating`	`STRING`	The rating for usage.
`create_invoice_lines_per_tier`	`BOOL`	Whether to create invoice lines per tier.
`billing_day`	`STRING`	The day of the month when billing occurs.
`specific_billing_day`	`FLOAT64`	A specific day for billing.
`billing_period`	`STRING`	The period for billing.
`period_alignment`	`STRING`	The alignment of the billing period.
`billing_timing`	`STRING`	The timing of billing.
`tax_template`	`STRING`	The tax template used for the charge.
`tax_included`	`BOOL`	Indicates if tax is included in the charge.
`external_erp_id`	`STRING`	The ID from an external ERP system.
`external_crm_id`	`STRING`	The ID from an external CRM system.
`deferred_revenue_account`	`STRING`	The account used for deferred revenue.
`recognized_revenue_account`	`STRING`	The account used for recognized revenue.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: product__charge_planschargesprice_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.
`currency`	`STRING`	The currency for pricing.
`price`	`FLOAT64`	The price for the quantity range.
`tier`	`FLOAT64`	The tier level for pricing.
`description`	`STRING`	A description of the price details.
`from_quantity`	`FLOAT64`	The minimum quantity for the price tier.
`to_quantity`	`FLOAT64`	The maximum quantity for the price tier.
`price_base`	`STRING`	The base price for the tier.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

subscription (95 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`id`	`STRING`	Unique identifier for the subscription
`order_number`	`STRING`	Order number associated with the subscription
`created`	`STRING`	Date of subscription creation
`modified`	`STRING`	Date of the last modification to the subscription
`order_billing_period`	`STRING`	Billing period for the order
`set_order_billing_period`	`BOOL`	Setup billing period for the order
`version`	`FLOAT64`	Version of the data
`is_last_version`	`BOOL`	Flag indicating if the subscription is the last version
`status`	`STRING`	Status of the subscription
`description`	`STRING`	Description of the subscription
`remarks`	`STRING`	Additional remarks or notes
`effective_start_date`	`STRING`	Effective start date of the subscription
`effective_end_date`	`STRING`	Effective end date of the subscription
`cancellation_date`	`STRING`	Date of subscription cancellation
`effective_change_date`	`STRING`	Effective date of subscription change
`order_date`	`STRING`	Date of the order
`notice_period_date`	`STRING`	Date when notice period starts
`last_renewal_date`	`STRING`	Date of the last renewal
`notice_period`	`FLOAT64`	Notice period for subscription cancellation
`term`	`FLOAT64`	Term of the subscription
`renewal_term`	`FLOAT64`	Renewal term for the subscription
`is_auto_renewed`	`BOOL`	Flag indicating if the subscription is set to auto-renew
`order_type`	`STRING`	Type of the order
`term_type`	`STRING`	Type of the subscription term
`order_payment_method`	`STRING`	Payment method used for the order
`invoice_separatly`	`BOOL`	Flag indicating if the subscription is invoiced separately
`your_reference`	`STRING`	Reference provided by user
`our_reference`	`STRING`	Our reference for the subscription
`your_order_number`	`STRING`	Order number specified by user
`invoice_address__id`	`STRING`	Unique identifier for the address
`invoice_address__description`	`STRING`	Description of invoice address
`invoice_address__name`	`STRING`	Name of the invoice address
`invoice_address__street`	`STRING`	Street of invoice address
`invoice_address__street2`	`STRING`	Additional street information
`invoice_address__city`	`STRING`	City of invoice address
`invoice_address__county`	`STRING`	County of invoice address
`invoice_address__state`	`STRING`	State of invoice address
`invoice_address__zip`	`STRING`	Zip code of invoice address
`invoice_address__country`	`STRING`	Country of invoice address
`delivery_address__id`	`STRING`	Unique identifier for the address
`delivery_address__description`	`STRING`	Description of delivery address
`delivery_address__name`	`STRING`	Name of the delivery address
`delivery_address__street`	`STRING`	Street of delivery address
`delivery_address__street2`	`STRING`	Additional street information
`delivery_address__city`	`STRING`	City of delivery address
`delivery_address__county`	`STRING`	County of delivery address
`delivery_address__state`	`STRING`	State of delivery address
`delivery_address__zip`	`STRING`	Zip code of delivery address
`delivery_address__country`	`STRING`	Country of delivery address
`invoice_batch_group__id`	`STRING`	Unique identifier for the invoice batch group
`invoice_batch_group__code`	`STRING`	Code of the invoice batch group
`invoice_batch_group__description`	`STRING`	Description of the invoice batch group
`payment_term`	`STRING`	Payment term for the subscription
`use_account_invoice_batch_group`	`BOOL`	Flag indicating if account invoice batch group is used
`account__name`	`STRING`	Name of the account
`account__account_number`	`STRING`	Unique identifier for the account
`account__id`	`STRING`	Unique identifier for the account
`account__external_erp_id`	`STRING`	External ERP system ID associated with the account
`account__external_crm_id`	`STRING`	External CRM system ID associated with the account
`invoice_account__name`	`STRING`	Name of the invoice account
`invoice_account__account_number`	`STRING`	Account number linked to the invoice
`invoice_account__id`	`STRING`	Unique identifier for the invoice account
`invoice_account__external_erp_id`	`STRING`	External ERP system ID associated with the invoice account
`invoice_account__external_crm_id`	`STRING`	External CRM system ID associated with the invoice account
`currency`	`STRING`	Currency used for the subscription
`external_erp_id`	`STRING`	External ERP system ID associated with the subscription
`external_crm_id`	`STRING`	External CRM system ID associated with the subscription
`currency_code_to_use_when_invoice`	`STRING`	Currency code used for invoicing
`cmrr__amount`	`FLOAT64`	Amount of Committed Monthly Recurring Revenue
`cmrr__currency_code`	`STRING`	Currency code
`cmrr__currency_conversion_date`	`STRING`	Date of currency conversion
`cmrr__base_currency_amount`	`FLOAT64`	Amount in base currency
`cmrr__base_currency_code`	`STRING`	Base currency code
`acv__amount`	`FLOAT64`	Amount of Annual Contract Value
`acv__currency_code`	`STRING`	Currency code
`acv__currency_conversion_date`	`STRING`	Date of currency conversion
`acv__base_currency_amount`	`FLOAT64`	Amount in base currency
`acv__base_currency_code`	`STRING`	Base currency code
`emrr__amount`	`FLOAT64`	Amount of Estimated Monthly Recurring Revenue
`emrr__currency_code`	`STRING`	Currency code
`emrr__currency_conversion_date`	`STRING`	Date of currency conversion
`emrr__base_currency_amount`	`FLOAT64`	Amount in base currency
`emrr__base_currency_code`	`STRING`	Base currency code
`one_time_fees__amount`	`FLOAT64`	Total amount of one-time fees
`one_time_fees__currency_code`	`STRING`	Currency code
`one_time_fees__currency_conversion_date`	`STRING`	Date of currency conversion
`one_time_fees__base_currency_amount`	`FLOAT64`	Amount in base currency
`one_time_fees__base_currency_code`	`STRING`	Base currency code
`tcv__amount`	`FLOAT64`	Total Contract Value amount
`tcv__currency_code`	`STRING`	Currency code
`tcv__currency_conversion_date`	`STRING`	Date of currency conversion
`tcv__base_currency_amount`	`FLOAT64`	Amount in base currency
`tcv__base_currency_code`	`STRING`	Base currency code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__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.
`id`	`STRING`	Unique identifier for the product
`product_number`	`STRING`	Number of the product
`charge_plan_id`	`STRING`	ID of the charge plan
`charge_plan_name`	`STRING`	Name of the charge plan
`charge_plan_number`	`STRING`	Number of the charge plan
`product_line_number`	`FLOAT64`	Line number for the product
`name`	`STRING`	Name of the product
`external_erp_id`	`STRING`	External ERP system ID associated with the product
`external_crm_id`	`STRING`	External CRM system ID associated with the product
`cmrr__amount`	`FLOAT64`	Amount of Committed Monthly Recurring Revenue
`cmrr__currency_code`	`STRING`	Currency code
`cmrr__currency_conversion_date`	`STRING`	Date of currency conversion
`cmrr__base_currency_amount`	`FLOAT64`	Amount in base currency
`cmrr__base_currency_code`	`STRING`	Base currency code
`acv__amount`	`FLOAT64`	Amount of Annual Contract Value
`acv__currency_code`	`STRING`	Currency code
`acv__currency_conversion_date`	`STRING`	Date of currency conversion
`acv__base_currency_amount`	`FLOAT64`	Amount in base currency
`acv__base_currency_code`	`STRING`	Base currency code
`emrr__amount`	`FLOAT64`	Amount of Estimated Monthly Recurring Revenue
`emrr__currency_code`	`STRING`	Currency code
`emrr__currency_conversion_date`	`STRING`	Date of currency conversion
`emrr__base_currency_amount`	`FLOAT64`	Amount in base currency
`emrr__base_currency_code`	`STRING`	Base currency code
`one_time_fees__amount`	`FLOAT64`	Total amount of one-time fees
`one_time_fees__currency_code`	`STRING`	Currency code
`one_time_fees__currency_conversion_date`	`STRING`	Date of currency conversion
`one_time_fees__base_currency_amount`	`FLOAT64`	Amount in base currency
`one_time_fees__base_currency_code`	`STRING`	Base currency code
`tcv__amount`	`FLOAT64`	Total Contract Value amount
`tcv__currency_code`	`STRING`	Currency code
`tcv__currency_conversion_date`	`STRING`	Date of currency conversion
`tcv__base_currency_amount`	`FLOAT64`	Amount in base currency
`tcv__base_currency_code`	`STRING`	Base currency code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptionproductscharges

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`	Unique identifier for the charge
`charge_number`	`STRING`	Number of the charge
`version`	`FLOAT64`	Version of the charge
`is_last_version`	`BOOL`	Flag indicating if the charge is the last version
`name`	`STRING`	Name of the charge
`charge_type`	`STRING`	Type of charge
`price_model`	`STRING`	Pricing model for the charge
`effective_start_date`	`STRING`	Effective start date of the charge
`effective_end_date`	`STRING`	Effective end date of the charge
`quantity`	`FLOAT64`	Quantity of the charge
`unit_code`	`STRING`	Unit code for the charge
`start_on`	`STRING`	Start date for the charge
`end_on`	`STRING`	End date for the charge
`charged_through_date`	`STRING`	Date charges are accounted for
`last_renewal_date`	`STRING`	Date of the last renewal
`last_price_adjustment_date`	`STRING`	Date of the last price adjustment
`price_period`	`STRING`	Pricing period for the charge
`usage_rating`	`STRING`	Usage rating for the charge
`revenue_recognition_rule`	`STRING`	Rule for revenue recognition
`billing_day`	`STRING`	Billing day for the charge
`specific_billing_day`	`FLOAT64`	Specific billing day for the charge
`billing_period`	`STRING`	Billing period for the charge
`billing_timing`	`STRING`	Billing timing for the charge
`period_alignment`	`STRING`	Period alignment for the charge
`tax_template`	`STRING`	Tax template applied to the charge
`tax_included`	`BOOL`	Flag indicating if tax is included in the charge
`create_invoice_lines_per_tier`	`BOOL`	Flag indicating if invoice lines are created per tier
`estimated_usage`	`FLOAT64`	Estimated usage for the charge
`estimated_quantity`	`FLOAT64`	Estimated quantity for the charge
`remarks`	`STRING`	Remarks or notes for the charge
`accounts_receivable_account`	`STRING`	Account for accounts receivable
`deferred_revenue_account`	`STRING`	Account for deferred revenue
`recognized_revenue_account`	`STRING`	Account for recognized revenue
`change_state`	`STRING`	Change state for the charge
`display_price`	`FLOAT64`	Price displayed for the charge
`recurring_monthly_amount`	`FLOAT64`	Recurring monthly amount for the charge
`recurring_monthly_amount_base`	`FLOAT64`	Base recurring monthly amount for the charge
`external_erp_id`	`STRING`	External ERP system ID associated with the charge
`external_crm_id`	`STRING`	External CRM system ID associated with the charge
`cmrr__amount`	`FLOAT64`	Amount of Committed Monthly Recurring Revenue
`cmrr__currency_code`	`STRING`	Currency code
`cmrr__currency_conversion_date`	`STRING`	Date of currency conversion
`cmrr__base_currency_amount`	`FLOAT64`	Amount in base currency
`cmrr__base_currency_code`	`STRING`	Base currency code
`acv__amount`	`FLOAT64`	Amount of Annual Contract Value
`acv__currency_code`	`STRING`	Currency code
`acv__currency_conversion_date`	`STRING`	Date of currency conversion
`acv__base_currency_amount`	`FLOAT64`	Amount in base currency
`acv__base_currency_code`	`STRING`	Base currency code
`tcv__amount`	`FLOAT64`	Total Contract Value amount
`tcv__currency_code`	`STRING`	Currency code
`tcv__currency_conversion_date`	`STRING`	Date of currency conversion
`tcv__base_currency_amount`	`FLOAT64`	Amount in base currency
`tcv__base_currency_code`	`STRING`	Base currency code
`emrr__amount`	`FLOAT64`	Amount of Estimated Monthly Recurring Revenue
`emrr__currency_code`	`STRING`	Currency code
`emrr__currency_conversion_date`	`STRING`	Date of currency conversion
`emrr__base_currency_amount`	`FLOAT64`	Amount in base currency
`emrr__base_currency_code`	`STRING`	Base currency code
`one_time_fees__amount`	`FLOAT64`	Total amount of one-time fees
`one_time_fees__currency_code`	`STRING`	Currency code
`one_time_fees__currency_conversion_date`	`STRING`	Date of currency conversion
`one_time_fees__base_currency_amount`	`FLOAT64`	Amount in base currency
`one_time_fees__base_currency_code`	`STRING`	Base currency code
`order_product_id`	`STRING`	Product ID linked to the order
`order_id`	`STRING`	Order ID linked to the charge
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptionproductscharges__price_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.
`tier`	`FLOAT64`	Pricing tier of the charge
`price`	`FLOAT64`	Price of the charge
`list_price`	`FLOAT64`	List price of the charge
`description`	`STRING`	Description of the price
`from_quantity`	`FLOAT64`	Quantity from which the price applies
`to_quantity`	`FLOAT64`	Quantity up to which the price applies
`price_base`	`STRING`	Base price of the charge
`line_discount_percent`	`FLOAT64`	Percentage of line discount
`line_discount_amount`	`FLOAT64`	Amount of line discount
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptionproductscharges__features

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.
`code`	`STRING`	Feature code
`description`	`STRING`	Description of the feature
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptionproductscharges__order_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.
`order_discount_id`	`STRING`	Discount ID linked to the order
`charge_id`	`STRING`	Charge ID linked to the order
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__milestones

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`	Unique identifier for the milestone
`order_id`	`STRING`	Order ID linked to the milestone
`name`	`STRING`	Name of the milestone
`description`	`STRING`	Description of the milestone
`milestone_date`	`STRING`	Date of the milestone
`planned_date`	`STRING`	Planned date for the milestone
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__order_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.
`id`	`STRING`	Unique identifier for the discount
`order_id`	`STRING`	Order ID linked to the discount
`start_on`	`STRING`	Start date for the discount
`end_on`	`STRING`	End date for the discount
`start_date`	`STRING`	Start date of the discount
`end_date`	`STRING`	End date of the discount
`percent`	`FLOAT64`	Percentage of the discount
`discount_type`	`STRING`	Type of discount applied to the order
`on_specific_charges`	`BOOL`	Flag indicating if the discount is applied to specific charges
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__order_discounts__order_product_charges

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.
`order_discount_id`	`STRING`	Discount ID linked to the order
`charge_id`	`STRING`	Charge ID linked to the order
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Younium sync works

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

Frequently asked questions

How long does the initial sync take for Younium?

It depends on how much history is in your Younium 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.

Can I sync only some tables or columns?

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 Younium'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 Younium, 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.

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 Younium 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 Younium connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Younium data

Recurring revenue

Use subscription and invoice to track recurring revenue and churn over time.

Billing reporting

Join invoice with account to reconcile billing and outstanding balances.

Product analysis

Use product to see which products drive revenue.

Use Younium data in your AI and BI tools

Once Younium 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 Younium data.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

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

Chargebee: Sync Chargebee to BigQuery.
ChartMogul: Sync ChartMogul to BigQuery.
Fennoa: Sync Fennoa to BigQuery.
Fortnox: Sync Fortnox to BigQuery.
FreshBooks: Sync FreshBooks to BigQuery.
PayPal Enterprise Payments: Sync PayPal Enterprise Payments to BigQuery.

Was this helpful?

Still need help? Share an idea