Practice

Snowflake services

Snowflake that stays tidy and affordable as more teams join.

We migrate to Snowflake, build on it, and tune it. Roles, warehouses, and resource monitors go in before the data does, so growth doesn't arrive as a surprise bill.

Snowflake practice

Our experience

Datagist on Snowflake.

We keep up with Snowflake releases and use newer features such as Dynamic Tables and Openflow where they fit your workloads.

We often deliver Snowflake alongside master data platforms like Reltio and Informatica, so mastered customer and product records land in the warehouse ready to join.

The problem

Snowflake takes minutes to start, so teams start without a plan. Warehouses get sized for the heaviest query and left running. Roles multiply until no one can say who sees what, and each team models its own version of the customer.

How we work on Snowflake

We design accounts, roles, and warehouses before any data is loaded. Pipelines are tested and kept in version control. Core entities like customer and product are modeled once and fed from master data. Resource monitors and a spend report by team stay in place after we hand over.

What we deliver

Snowflake work we take on.

The outcome

A Snowflake bill you can forecast, and one customer table every team uses.

  • 01

    Snowflake architecture and setup

    Account and database design, role-based access, network security, and environments managed as code.

  • 02

    Migration to Snowflake

    Moves from Teradata, Netezza, Oracle, SQL Server, and Hadoop, with automated reconciliation of the results.

  • 03

    Data engineering

    Ingestion with Snowpipe and Openflow, transformation with dbt, Dynamic Tables, and Snowpark, and Apache Iceberg tables.

  • 04

    Master data on Snowflake

    Mastered customer, product, and supplier data from Reltio, Informatica, and other MDM platforms, shared with every team.

  • 05

    Governance with Snowflake Horizon

    Classification, masking and row access policies, tagging, lineage, and audit.

  • 06

    Data sharing and collaboration

    Secure data sharing, Snowflake Marketplace listings, and data clean rooms.

  • 07

    AI with Snowflake Cortex

    Cortex AI functions, Cortex Search, and Cortex Analyst for plain-language questions over governed data, plus Streamlit apps.

  • 08

    Cost optimization

    Warehouse sizing and auto-suspend, resource monitors, query tuning, and spend reporting by team.

How it starts

The first step.

We go through your query history and warehouse settings to find where the credits go, and check roles for access no one needs. If you are moving to Snowflake, we profile the workloads on your current platform first. Then we agree on the first workload to fix or migrate.

How we work
Ask Dex

Questions about Snowflake?

Dex answers from our own pages and links to where it found the answer.

Snowflake and the Snowflake logo are trademarks of their owner, used here only to identify the platform we work on.

Credits climbing faster than usage?

We'll find the warehouses and queries behind it.

Start a conversation