G2 Lite

G2 is a software marketplace.

Features

Feature Name	Supported	Notes
Capture deletes		`PRODUCT`, `PRODUCT_COMPETITOR`, `PRODUCT_FEATURE`, `PRODUCT_RATING`, `TRACK_PROSPECT`, and `RESOURCE_SUBSCRIPTION` tables.
History mode
Custom data
Data blocking		Column level
Column hashing
Re-sync		Connector 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.

NOTE: 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 remaining tables and their child tables during every sync.

This schema applies to all G2 connectors.

Explore G2 schema ERD

The survey-responses endpoint of the G2 API returns multiple [answers](https://data.g2.com/api/ docs#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.