Sync Freshservice to Google BigQuery

Freshservice

What are Combo Data Sets?

Flatly's pre-blended combo data sets from Freshservice are some of the most comprehensive in the industry. They take slightly longer to process, but their utility in a business intelligence context is unparalleled. These data sets are automatically presented in a left-joined format, with parent data sets repeated and child data sets unique to each row. This enables an analyst to examine individual child records with vital context from the parent records, without doing any additional blending or mapping.

What is the Analytics Export?

The Universal JSON Data Source in Flatly can be used to automatically extract the Scheduled Data Export JSON provided by Freshservice for custom use cases that go beyond the standard data resources provided by the Freshservice API. Flatly will try to automatically detect keys and values and produce a useful table. Additional layout options are available with assistance from Flatly Support.

FAQ: Google BigQuery

How does schema setup work?

Flatly leverages intelligent schema generation that adapts to BigQuery's auto-detection protocols, handling data type inference and column ordering automatically so you never have to manually map fields.‍

What about data sanitization?

Data hygiene is built directly into the ingestion process. Before a single row is written to BigQuery, Flatly validates your data against a generated reference schema. It proactively detects and strips out "schema violators" —inconsistent data types or malformed records that would typically cause a load job to crash. Flatly logs these exclusions in a detailed metadata file, ensuring your pipeline remains resilient and continuous while giving you full transparency into data quality issues.‍

How performant and scalable is this integration?

This integration is designed for scale and flexibility, the engine processes data in memory-optimized chunks to handle massive datasets efficiently. It offers powerful pre-load controls, allowing you to filter rows based on custom logic (e.g., date ranges, specific values) and allowlist specific keys. This ensures that you only sync high-value data, optimizing your BigQuery storage costs and query performance.

How does authorization work?

Everything is secured via Service Account authentication, providing a stable, production-grade connection for your most critical analytics dashboards.

What is special about this integration?

Price-to-performance is impressive. Data can be synced to BigQuery every 6 hours for just $19 a month.