Data and analytics · Service

Snowflake consulting: set-up, modelling and keeping the cost under control

Snowflake makes it easy to start and easy to overspend. The decisions that matter early are the role model, how data is loaded and modelled, and how compute is sized and suspended.

Short answer

Snowflake consulting covers setting up a Snowflake account, designing roles and access, loading data from source systems, modelling it for reporting, and controlling cost. Snowflake separates storage from compute and charges for compute by use, so warehouses that are oversized or left running are the usual cause of surprise bills. A good set-up fixes roles, loading, modelling and cost controls before the data volume grows.

  • Snowflake
  • dbt
  • Fivetran
  • Power BI
  • Tableau
  • Salesforce
  • NetSuite

Last reviewed . General guidance, not legal, tax or accounting advice. Consultants in a Box is a Make partner and independent of the other vendors named.

Set-up decisions, by area

Counted from the table on this page.

Show as table
ItemSet-up decisions, by area
Access3
Cost4
Data3

Where the numbers come from

These counts come straight from the lists on this page. Nothing here is a survey result or a client outcome.

Why do Snowflake costs surprise people?

Because compute is billed while a warehouse runs, and it is easy to leave a large one running or to point an inefficient query at it.

  • Set auto-suspend on every warehouse.
  • Start small and size up only with evidence.
  • Give each workload its own warehouse so cost is visible.
  • Put a resource monitor on each one.

What does a good role model look like?

One that separates what a person does from what an object allows, so access can be granted and reviewed without one-off exceptions.

  • Access roles hold privileges on databases and schemas.
  • Functional roles, such as analyst or engineer, are granted access roles.
  • People and tools are granted functional roles only.
  • Nobody works day to day in the account administrator role.

How do you get from raw data to trusted reports?

In layers: raw data as loaded, staged models that clean it, and business models that hold the agreed definitions.

  1. Load each source into a raw schema, unchanged.
  2. Stage it: rename, type and de-duplicate.
  3. Model the business entities and measures, with tests.
  4. Expose those models to the reporting tool.
  5. Document each measure where analysts can read it.

Features and pricing change. Confirm current details in Snowflake's documentation.

FAQ

Questions buyers ask about this

Are you a Snowflake partner?

We are an independent consultancy. This page is not published or endorsed by Snowflake.

Can you take over an existing Snowflake account?

Yes. We start with a review of roles, warehouses, spend and models, then fix the biggest risks and costs first.

Is Snowflake too much for a mid-size company?

Not if it is set up with small warehouses and cost controls. The platform scales down as well as up.

Which reporting tools work with Snowflake?

The main ones, including Power BI and Tableau. We connect whichever your team uses.

Vendor documentation to check against

Product details, plans and pricing change. Confirm current details in each vendor's own documentation. Consultants in a Box is a Make partner and otherwise an independent consultancy; this page is not published or endorsed by any vendor named. Names and logos are trademarks of their owners.

Want to talk this project through?

Book a call and we will look at your systems, what the work involves and what it should cost. Or start with the free business analysis.

Book a free consultation

Tell us about your team and the software you need help with. We'll follow up to schedule a time to talk.

Open the form on its own page

Talk to a person

The fastest way is to pick a time. Prefer to write? Leave a message and we will email you back, usually the same business day.

Book a free call

By sending this you agree to our Terms and Privacy Policy.