I'm building a stack for product, sales, and support data; what warehouse works well?

For a stack that combines product, sales, and support data, the warehouse usually works best when it’s:

• easy to ingest from SaaS tools
• fast enough for BI and ad hoc analysis
• cost-predictable
• friendly to analysts and data engineers
• good at semi-structured/event data if you have product analytics

Best all-around choices

Snowflake and BigQuery are the most common strong picks.

Snowflake

Best if you want:

• strong performance across mixed workloads
• easy scaling with fewer tuning concerns
• good support for structured and semi-structured data
• broad ecosystem support

Good fit for:

• companies with lots of SaaS sources
• teams using dbt, Fivetran, Airbyte, Mode/Hex/Looker, etc.
• organizations that expect data growth and multiple departments using the warehouse

BigQuery

Best if you want:

• very low ops overhead
• excellent scalability
• strong native integration with the Google ecosystem
• great for event/product data and large analytical queries

Good fit for:

• product-heavy companies
• teams already on GCP
• lots of clickstream/app event data
• teams that want simple maintenance

Other solid options

Databricks SQL / Lakehouse

Best if your data stack leans heavily toward:

• machine learning
• unstructured or very large-scale data
• streaming + batch together

It can work well, but for classic product/sales/support analytics, Snowflake or BigQuery is often simpler.

Redshift

Still viable, especially if you’re deep in AWS, but generally less compelling than Snowflake/BigQuery unless you already have strong AWS data infra and expertise.

What I’d recommend by scenario

• Small/medium startup, want simplest ops: BigQuery
• Cross-functional analytics, lots of SaaS data, want flexibility: Snowflake
• Google Cloud + product event data: BigQuery
• AWS-centric org with existing infra: Redshift or Snowflake
• Heavy ML / data science / lakehouse needs: Databricks

For your specific use case

If you’re unifying product, sales, and support, the safest default is:

Snowflake if you want the most balanced general-purpose warehouse.
BigQuery if you prioritize simplicity and product-event scale.

If you want, I can also suggest a full stack around the warehouse — e.g. Fivetran/Airbyte + dbt + BI tool + reverse ETL — based on your team size and cloud provider.