Snowflake


Why Snowflake?

When Snowflake launched, its founders set out to build a platform that would allow their customers to fully harness the power of the cloud. Today, the innovative Snowflake Data Cloud offers companies the ability to store, organise, share and analyse vast quantities of data.  Clients migrating from other data platforms to Snowflake can run all their data workloads on a single platform, access its unique features and expect to enjoy a financial payback on their investment within months. 


Whether starting out on your cloud journey or choosing to migrate to Snowflake from another platform, our partnership with Snowflake and knowledge of the Snowflake Data Cloud will give you the expertise that your company needs in order to utilise the power of data within the cloud.

DTSQUARED Capabilities

Snowflake Maturity Assessment Maturity Assessment and Snowflake PoC

Snowflake incorporates a sophisticated and automatic query optimisation capability that is available to all users, however, compute costs are material and well written code is always more optimal than automatically optimised poor code.  Our skilled data engineers at DTSQUARED can analyse your Snowflake usage and advise you on options to reduce your compute usage and therefore reduce your overall costs.

Snowflake Migration

Snowflake typically run the BVA process with existing customers to identify additional data migration use cases that will ultimately save the customer money.  DTSQUARED were the first consultancy to undertake a joint BVA with Snowflake identifying and costing out use cases that, when realised, will save the customer a significant sum and enhance their data management capabilities.  

Snowflake Data Integration

Gathering data from many sources and integrating it using the Snowflake data warehouse platform may require either an ETL or an ELT process. At DTSQUARED, our team is experienced in working with third-party vendors and applications and can advise you which products will deliver a seamless data integration. For customers who are hesitant to introduce another vendor into the process, DTSQUARED offers a bespoke framework that ensures your data transformation runs entirely within Snowflake.

Snowflake Optimisation

Snowflake incorporates a sophisticated query optimisation capability that is available to all users at no additional cost and with no additional configuration requirements. However, as compute costs are high, our skilled data engineers at DTSQUARED can analyse your Snowflake usage and advise you how best to reduce your compute usage and therefore reduce your costs.

Snowflake BVA (Business Value Assessment)

Snowflake typically runs a BVA on existing clients to help identify additional data migration use cases that could save them money.  DTSQUARED were the first consultancy to undertake a joint BVA with Snowflake identifying and costing out data use cases that when realised, will save the customer a significant sum and enhance their current capabilities.

DTSQUARED Tooling

We are committed to adding value to our clients use of Snowflake and our team has developed a variety of bespoke tooling in this regard under our ‘Gondola’ brand.  For example, Gondola includes a lightweight data transformation framework that can potentially eliminate the need for a dedicated ETL vendor.  Our framework leverages Snowflake stored procedures to centralise business logic within your data platform and includes support for standard data warehouse constructs like SCD Type 2; all activity undertaken is logged and fully auditable. 

Team and Certifications

We have built a team of highly experienced engineers to help our clients take full advantage of all that Snowflake offers. Our team has many years of experience in data warehousing. They have all achieved SnowPro Core certification and many also have SnowPro Advanced (Architect and/or Data Engineer) certifications.  Snowflake recognises our skills in the design, development, and implementation of Snowflake solutions certifying us as a Select Services Partner. 

We are also skilled in a large and growing number of complementary products from other vendors in regards to ELT (Extract, Load, Transform), BI (Business Intelligence) and ML (Machine Learning).

Related Content

Project Spotlight Part 2: Integrating Collibra and Informatica for Data Quality

Project Spotlight Part 2: Integrating Collibra and Informatica for Data Quality

Building robust data strategies for a Social Housing client

Building robust data strategies for a Social Housing client

New Episode – DataCast from DTSQUARED

New Episode – DataCast from DTSQUARED

Contacts

To speak to us about engaging the DTSQUARED team in Data Cloud Enablement, Data Warehousing Best Practice, establishing a Data Warehousing Centre of Excellence and in all things Snowflake, please reach out to our Data Cloud team via the button below.

Or

If you are an engineer with an interest in joining the DTSQUARED team, please use our ‘Get in Touch’ page to make contact.

Get in touch with our data experts

Get in touch for a free session with our data experts

Let us hear from you