G2 Lite

G2 is a software marketplace.

Features

Feature Name	Supported	Notes
Capture deletes		`PRODUCT`, `RESOURCE_SUBSCRIPTION`, and `TRACK_PROSPECT` tables and their child tables.
History mode
Custom data
Data blocking		Column level
Column hashing
Re-sync		Connection level and table level. A parent table re-sync includes all associated child tables.
API configurable		API configuration
Priority-first sync		`CATEGORY` and `HISTORY` tables.
Fivetran data models
Private networking
Authorization via API

We support the SaaS and Hybrid deployment models for the connector.

You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.

Follow our step-by-step G2 setup guide to connect G2 with your destination using Fivetran connectors.

To capture new records, we incrementally sync the following tables and their child tables:

To capture updates and deletes, we re-import the following tables and their child tables during every sync:

This schema applies to all G2 connections.

Explore G2 schema ERD

The survey-responses endpoint of the G2 API returns multiple answers and questions fields. Answers include comment_answers and secondary_answers. Questions include self and related questions. Because of the volume of the data, the SURVEY RESPONSE table, and the ANSWER and QUESTION child tables take a long time to sync. As a result, your initial syncs may take up to 14 days to complete.
Fivetran will retrieve and sync data only from the last 3 months for the SURVEY_RESPONSE and ANSWER tables.
Due to a source-side limitation, we can only retrieve and sync data from the last 3 days for the EVENT_STREAM table and its child table.