Skip to content
Book a demoStart free
Connectors

Persona connector

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

Persona connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Persona data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your data from Persona instead of moving it.

Sync your Persona identity verification data into BigQuery with Kaivo to analyse inquiries and verification outcomes.

CategoryTech
AuthenticationAPI key
SetupSelf-service

Getting started with the Persona connector

Section titled “Getting started with the Persona connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Persona 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
API key or access token

|

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

accounts (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__created_at STRING
attributes__fields__address__type STRING
attributes__fields__address__value__city__type STRING
attributes__fields__address__value__country_code__type STRING
attributes__fields__address__value__postal_code__type STRING
attributes__fields__address__value__street_1__type STRING
attributes__fields__address__value__street_2__type STRING
attributes__fields__address__value__subdivision__type STRING
attributes__fields__birthdate__type STRING
attributes__fields__email_address__type STRING
attributes__fields__identification_numbers__type STRING
attributes__fields__name__type STRING
attributes__fields__name__value__first__type STRING
attributes__fields__name__value__last__type STRING
attributes__fields__name__value__middle__type STRING
attributes__fields__phone_number__type STRING
attributes__fields__selfie_photo__type STRING
attributes__reference_id STRING
attributes__updated_at STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: accounts__attributes__fields__identification_numbers__value

Section titled “Subtable: accounts__attributes__fields__identification_numbers__value”
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.
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.
api-keys (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__api_key_inflection STRING
attributes__api_version STRING
attributes__created_at STRING
attributes__file_access_token_expires_in FLOAT64
attributes__last_used_at STRING
attributes__name STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: api-keys__attributes__api_attributes_blocklist

Section titled “Subtable: api-keys__attributes__api_attributes_blocklist”
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: api-keys__attributes__ip_address_allowlist

Section titled “Subtable: api-keys__attributes__ip_address_allowlist”
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: api-keys__attributes__permissions

Section titled “Subtable: api-keys__attributes__permissions”
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.
api-logs (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__created_at STRING
attributes__request__get_params__page__after STRING
attributes__request__get_params__page__size STRING
attributes__request__headers__accept STRING
attributes__request__headers__host STRING
attributes__request__headers__persona_version STRING
attributes__request__headers__user_agent STRING
attributes__request__ip_address STRING
attributes__request__method STRING
attributes__request__path STRING
attributes__request__post_params__data__attributes__inquiry_id STRING
attributes__response__headers__cache_control STRING
attributes__response__headers__content_type STRING
attributes__response__headers__expires STRING
attributes__response__headers__persona_host STRING
attributes__response__headers__pragma STRING
attributes__response__headers__rate_limit_limit FLOAT64
attributes__response__headers__rate_limit_remaining FLOAT64
attributes__response__headers__rate_limit_reset FLOAT64
attributes__response__headers__request_id STRING
attributes__response__headers__vary STRING
attributes__response__status FLOAT64
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
cases (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__created_at STRING
attributes__creator_id STRING
attributes__creator_type STRING
attributes__name STRING
attributes__status STRING
attributes__updated_at STRING
id STRING
relationships__case_template__data__type STRING
relationships__case_template__data__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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: cases__relationships__accounts__data

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

Subtable: cases__relationships__case_comments__data

Section titled “Subtable: cases__relationships__case_comments__data”
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: cases__relationships__inquiries__data

Section titled “Subtable: cases__relationships__inquiries__data”
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: cases__relationships__reports__data

Section titled “Subtable: cases__relationships__reports__data”
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: cases__relationships__txns__data

Section titled “Subtable: cases__relationships__txns__data”
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: cases__relationships__verifications__data

Section titled “Subtable: cases__relationships__verifications__data”
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.
events (73 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__created_at STRING
attributes__name STRING
attributes__payload__data__type STRING
attributes__payload__data__attributes__completed_at STRING
attributes__payload__data__attributes__created_at STRING
attributes__payload__data__attributes__creator STRING
attributes__payload__data__attributes__creator_id STRING
attributes__payload__data__attributes__creator_type STRING
attributes__payload__data__attributes__expired_at STRING
attributes__payload__data__attributes__fields__address__type STRING
attributes__payload__data__attributes__fields__address__value__city__type STRING
attributes__payload__data__attributes__fields__address__value__country_code__type STRING
attributes__payload__data__attributes__fields__address__value__postal_code__type STRING
attributes__payload__data__attributes__fields__address__value__street_1__type STRING
attributes__payload__data__attributes__fields__address__value__street_2__type STRING
attributes__payload__data__attributes__fields__address__value__subdivision__type STRING
attributes__payload__data__attributes__fields__address_city__type STRING
attributes__payload__data__attributes__fields__address_country_code__type STRING
attributes__payload__data__attributes__fields__address_postal_code__type STRING
attributes__payload__data__attributes__fields__address_street_1__type STRING
attributes__payload__data__attributes__fields__address_street_2__type STRING
attributes__payload__data__attributes__fields__address_subdivision__type STRING
attributes__payload__data__attributes__fields__birthdate__type STRING
attributes__payload__data__attributes__fields__current_government_id__type STRING
attributes__payload__data__attributes__fields__current_selfie__type STRING
attributes__payload__data__attributes__fields__email_address__type STRING
attributes__payload__data__attributes__fields__email_address__type STRING
attributes__payload__data__attributes__fields__expiration_date__type STRING
attributes__payload__data__attributes__fields__government_identification_number_map__type STRING
attributes__payload__data__attributes__fields__identification_class__type STRING
attributes__payload__data__attributes__fields__identification_number__type STRING
attributes__payload__data__attributes__fields__identification_numbers__type STRING
attributes__payload__data__attributes__fields__issue_date__type STRING
attributes__payload__data__attributes__fields__issuing_authority__type STRING
attributes__payload__data__attributes__fields__name__type STRING
attributes__payload__data__attributes__fields__name__value__first__type STRING
attributes__payload__data__attributes__fields__name__value__last__type STRING
attributes__payload__data__attributes__fields__name__value__middle__type STRING
attributes__payload__data__attributes__fields__name_first__type STRING
attributes__payload__data__attributes__fields__name_last__type STRING
attributes__payload__data__attributes__fields__name_middle__type STRING
attributes__payload__data__attributes__fields__phone_number__type STRING
attributes__payload__data__attributes__fields__phone_number__type STRING
attributes__payload__data__attributes__fields__selected_country_code__type STRING
attributes__payload__data__attributes__fields__selected_country_code__value STRING
attributes__payload__data__attributes__fields__selected_id_class__type STRING
attributes__payload__data__attributes__fields__selfie_photo__type STRING
attributes__payload__data__attributes__name STRING
attributes__payload__data__attributes__next_step_name STRING
attributes__payload__data__attributes__published_at STRING
attributes__payload__data__attributes__reference_id STRING
attributes__payload__data__attributes__status STRING
attributes__payload__data__attributes__updated_at STRING
attributes__payload__data__id STRING
attributes__payload__data__meta__processing_time_seconds FLOAT64
attributes__payload__data__relationships__account__data__type STRING
attributes__payload__data__relationships__account__data__id STRING
attributes__payload__data__relationships__case_template__data__type STRING
attributes__payload__data__relationships__case_template__data__id STRING
attributes__payload__data__relationships__creator__data__type STRING
attributes__payload__data__relationships__creator__data__id STRING
attributes__payload__data__relationships__inquiry_template__data__type STRING
attributes__payload__data__relationships__inquiry_template__data__id STRING
attributes__payload__data__relationships__inquiry_template_version__data__type STRING
attributes__payload__data__relationships__inquiry_template_version__data__id STRING
attributes__payload__data__relationships__workflow__data__type STRING
attributes__payload__data__relationships__workflow__data__id STRING
attributes__payload__data__relationships__workflow_version__data__type STRING
attributes__payload__data__relationships__workflow_version__data__id STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__attributes__payload__data__attributes__attachments

Section titled “Subtable: events__attributes__payload__data__attributes__attachments”
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: events__attributes__payload__data__attributes__enabled_locales

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

Subtable: events__attributes__payload__data__attributes__fields__identification_numbers__value

Section titled “Subtable: events__attributes__payload__data__attributes__fields__identification_numbers__value”
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: events__attributes__payload__data__attributes__tags

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

Subtable: events__attributes__payload__data__relationships__accounts__data

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

Subtable: events__attributes__payload__data__relationships__case_comments__data

Section titled “Subtable: events__attributes__payload__data__relationships__case_comments__data”
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: events__attributes__payload__data__relationships__documents__data

Section titled “Subtable: events__attributes__payload__data__relationships__documents__data”
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: events__attributes__payload__data__relationships__inquiries__data

Section titled “Subtable: events__attributes__payload__data__relationships__inquiries__data”
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: events__attributes__payload__data__relationships__reports__data

Section titled “Subtable: events__attributes__payload__data__relationships__reports__data”
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: events__attributes__payload__data__relationships__selfies__data

Section titled “Subtable: events__attributes__payload__data__relationships__selfies__data”
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: events__attributes__payload__data__relationships__sessions__data

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

Subtable: events__attributes__payload__data__relationships__txns__data

Section titled “Subtable: events__attributes__payload__data__relationships__txns__data”
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: events__attributes__payload__data__relationships__verifications__data

Section titled “Subtable: events__attributes__payload__data__relationships__verifications__data”
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.
inquiries (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__created_at STRING
attributes__creator STRING
attributes__fields__address_city__type STRING
attributes__fields__address_country_code__type STRING
attributes__fields__address_postal_code__type STRING
attributes__fields__address_street_1__type STRING
attributes__fields__address_street_2__type STRING
attributes__fields__address_subdivision__type STRING
attributes__fields__birthdate__type STRING
attributes__fields__current_government_id__type STRING
attributes__fields__current_selfie__type STRING
attributes__fields__email_address__type STRING
attributes__fields__expiration_date__type STRING
attributes__fields__government_identification_number_map__type STRING
attributes__fields__identification_class__type STRING
attributes__fields__identification_number__type STRING
attributes__fields__issue_date__type STRING
attributes__fields__issuing_authority__type STRING
attributes__fields__name_first__type STRING
attributes__fields__name_last__type STRING
attributes__fields__name_middle__type STRING
attributes__fields__phone_number__type STRING
attributes__fields__selected_country_code__type STRING
attributes__fields__selected_country_code__value STRING
attributes__fields__selected_id_class__type STRING
attributes__next_step_name STRING
attributes__reference_id STRING
attributes__status STRING
attributes__updated_at STRING
id STRING
relationships__account__data__type STRING
relationships__account__data__id STRING
relationships__inquiry_template__data__type STRING
relationships__inquiry_template__data__id STRING
relationships__inquiry_template_version__data__type STRING
relationships__inquiry_template_version__data__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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: inquiries__relationships__documents__data

Section titled “Subtable: inquiries__relationships__documents__data”
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: inquiries__relationships__reports__data

Section titled “Subtable: inquiries__relationships__reports__data”
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: inquiries__relationships__selfies__data

Section titled “Subtable: inquiries__relationships__selfies__data”
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: inquiries__relationships__sessions__data

Section titled “Subtable: inquiries__relationships__sessions__data”
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: inquiries__relationships__verifications__data

Section titled “Subtable: inquiries__relationships__verifications__data”
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.
inquiry-sessions (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
webhooks (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__api_key_inflection STRING
attributes__api_version STRING
attributes__created_at STRING
attributes__file_access_token_expires_in FLOAT64
attributes__status STRING
attributes__url STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: webhooks__attributes__api_attributes_blocklist

Section titled “Subtable: webhooks__attributes__api_attributes_blocklist”
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: webhooks__attributes__enabled_events

Section titled “Subtable: webhooks__attributes__enabled_events”
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.
workflow-runs (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__completed_at STRING
attributes__created_at STRING
attributes__status STRING
id STRING
meta__processing_time_seconds FLOAT64
relationships__creator__data__type STRING
relationships__creator__data__id STRING
relationships__workflow__data__type STRING
relationships__workflow__data__id STRING
relationships__workflow_version__data__type STRING
relationships__workflow_version__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
workflows-run (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
attributes__completed_at STRING
attributes__created_at STRING
attributes__status STRING
id STRING
meta__processing_time_seconds FLOAT64
relationships__creator__data__type STRING
relationships__creator__data__id STRING
relationships__workflow__data__type STRING
relationships__workflow__data__id STRING
relationships__workflow_version__data__type STRING
relationships__workflow_version__data__id 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 Persona 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 Persona?

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

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

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

Use inquiries and cases to track verification volume and outcomes over time.

Join workflows-run with inquiries to see how verification flows perform.

Use events and api-logs to support compliance and review.

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

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