Data warehouse

Your Freshline data, in your warehouse.

Orders, line items, products, and customers stream into your BigQuery dataset as they change, so finance and ops report on the same records.

Freshline
Freshline
Google BigQuery
Google BigQuery
Self-serve setup with a service account
Updates stream in real time
Report with SQL, Looker Studio, or your BI tool

Connect your warehouse

Point Freshline at a dataset in your Google Cloud project. Freshline creates the tables for you.

  1. 1

    Create a dataset

    Set up a BigQuery dataset in your Google Cloud project.

  2. 2

    Add a service account

    Create a service account with BigQuery Data Editor and Job User roles and copy its key.

  3. 3

    Test the connection

    Enter the project, dataset, and key in Freshline and test before you install.

  4. 4

    Start reporting

    Freshline creates the tables and keeps them current. Query them or connect your BI tool.

Stop exporting CSVs to answer simple questions

One source for reporting

Finance and ops query the same tables, so numbers match across teams.

Join with everything else

Combine Freshline data with your ERP, marketing, and finance data in one warehouse.

Always up to date

Records stream in as they're created or changed. No one has to remember to run an export.

What syncs between Freshline and BigQuery

Data flows one way: from Freshline into your BigQuery dataset.

From BigQuery into Freshline

Nothing flows this way.

From Freshline to BigQuery

  • Orders
  • Order line items
  • Fees and discounts
  • Products and variants
  • Customers and contacts
  • Custom data
Tables

Warehouse-ready, not a data dump

Freshline creates structured tables when you install and keeps them current. Deleted records are kept as markers, so history stays complete.

Book a demo
What lands in BigQuery
  • Orders and line items
  • Fees and discounts
  • Products, variants, and customers
  • Your custom data fields
Analysis

Answer the questions your reports can't

Margin by customer, order frequency by day, or slow-moving products. Ask anything SQL can answer, or build it in your BI tool.

Book a demo
Example questions
  • Which customers are ordering less this month?
  • What's our revenue by category?
  • Which products haven't sold in 30 days?
  • How do fees and discounts affect order value?
Control

Your project, your access rules

Data lands in a Google Cloud project you own, through a service account you create. Freshline shows when each table last synced.

Book a demo
Controls
  • Your Google Cloud project
  • A service account you control
  • Your IAM and retention policies
  • Last-synced time per table

Questions about the BigQuery integration

Do we need a data team to use this?

No. If you can connect Looker Studio or another BI tool to BigQuery, you can report on Freshline data.

Does data flow back into Freshline?

No. BigQuery is a reporting destination. Freshline writes to it and doesn't read from it.

Who pays for BigQuery?

The tables live in your Google Cloud project, so storage and query costs are billed by Google to your account.

Ready to get started?

Join 100+ food distributors automating their operations with Freshline.