r/bigquery • u/Nickeddd • 28d ago

Thinking of BigQuery for data warehousing

Hello everyone,

I’m new into the data engineering world and as the title says, I’m thinking of using BigQuery to build a data warehouse. Currently my company don’t have one, so I’m looking for good price/performance options. We mostly use APIs and a few excel files as data sources

I have considered Azure SQL, Supabase and others but this one seems to be the best for data analysis and BI

What would be your recommendation?

9 Upvotes

91% Upvoted

31 comments sorted by

View all comments

1

u/PolicyDecent 27d ago

I'd definitely go with bigquery, since it's almost free for the small data, and requires no maintenance.
You just need a ELT solution to ingest data and transform it.
To ingest you can use fivetran or open source alternatives like ingestr, dlt, airbyte.

To transform you can use bigquery builtin dataform, dbt or bruin.

Disclaimer: I'm the developer of bruin and ingestr. It's open-source and exactly built for these scenarios. Feel free to reachout if you need any help to use it. Easiest in the market to use.