Snowflake Data Cloud has opened a new world with its advanced data analytics capabilities.

Build from the ground up for the cloud, with completely separated storage and compute, it delivers high performance, simplicity and flexibility and enables organizations to store all their data at one place. It processes reports and analytics at lightning speed because its modern cloud architecture is built around the separation of resources, which allows it to scale instantly, effectively and efficiently without trade-offs.

But many are hesitant to take the plunge as data migration projects have a notorious reputation for being both – highly challenging and prone to failure.

At In516ht, our strategic focus are the migrations and modernizations of existing data platforms with a cloud-first strategy. We devoted a lot of time to establishing and optimizing the best practice approach for development, modernization, and migration projects on the Snowflake Data Cloud.

With 15+ years of experience with data management projects, we built a proven migration methodology that helps steer migration projects to a successful outcome. As such, we’ve become one of the leading Premier Snowflake partners in Europe with successful migration projects in the finance, energy, and retail industry. In 2021 we reached another milestone as we received Snowflake’s RSI Innovation Partner of the year award in the EMEA region.

Every phase counts.

Our approach is based on ensuring the least possible risk
at every step.

#1 Kickstart your Snowflake journey

Enablement pack

You have just started your cloud journey on Snowflake Data Cloud and so many questions arise. Get the know-how, invest in knowledge, and empower your team.

Step 1: A 2-hour consultation to gather all your questions and concerns to understand your plans, check your background and gain insights about your current set up, team competence and experience. We then organize 2-4 days tailored enablement workshops where senior Snowflake experts will onboard your team to kick start your Snowflake journey.

2 days workshop

Your team has done Snowflake onboarding classes and Snowflake certification and understand how Snowflake Data Cloud works.
They have knowledge about Snowflake User interface, user roles and administration, DB navigation, data exploration, warehouses concepts, creating objects, staging data, data storage, data ingestion and transformations (structured and semi structured data, cost monitoring, activity monitoring…).
Our expert Snowflake trainers address your most important questions and bring you to the next level.

OUTCOMES:

  • asses your reference future architecture,
  • learn best practices, potential pitfalls and possible optimizations,
  • understand how to write a code in optimal way to optimize cloud spending,
  • know how to utilize unique Snowflake features like: time travel, multi cluster architecture, scaling,
  • build a modern ELT pipeline using Snowflake tasks and external functions,
  • learn how to prepare data models to best utilize modern BI tools.

Who should attend (technical training):
Data analysts, Data engineers, Data scientists, Data warehouse architects, Database administrators, business intelligence users

Knowledge level needed:
Training is intended for people with existing Snowflake knowledge.

Pricing: 4.000 €

4 days workshop

Read further if your team is new to the cloud solutions. They have been working with traditional analytical solution mostly on-premises and decided to start the cloud journey. You have done self-paced trainings to get basic understanding and concepts of Snowflake Data Cloud. Your fist goal is to learn Snowflake data cloud to an extent that your team would be ready to take the next step, get certified and reap the knowledge of new cloud concepts (how to move data from on premises to the cloud quickly and efficiently, how to automate as much as possible, adopt new modern ELT approach vs. ETL to utilize cloud resources as much as possible, how to write the code optimally, …
Based on your current set up we will suggest a new modern cloud architecture. Our expert Snowflake trainers will tailor the training to your needs and equip your staff with the knowledge and address all aspects of modern cloud solutions and concepts. We will go from theory to hands-on labs (from Zero to Snowflake).

OUTCOMES:

  • learn how to plan step by step migration/greenfield approach to the cloud,
  • which steps to be taken and in what order,
  • what modern tools are available and how to utilize them,
  • know expected cloud resource costs,
  • learn best practices, potential challenges, and opportunities,
  • write a code in an optimal way to optimize cloud spending,
  • understand how to utilize unique Snowflake features like: time travel, multi cluster architecture, scaling…;
  • how to build a modern ELT pipeline and how to prepare data models to best utilize modern BI tools.

Who should attend (technical training):
Data analysts, Data engineers, Data Scientists, Data warehouse architects, Database administrators, BI users

Knowledge level needed:
Training is intended for people with basic Snowflake knowledge.

Pricing: 7.000 €

#2 Prepare for take-off

Go-to-cloud preparation services

You have done a comprehensive financial analysis between your current IT portfolio and a future state, cloud-based environment by incorporating multi-factor analysis of people, processes, technology and automation across multiple domains. The TCO showed that the cloud is the way for your future data management solution, and you have chosen the Snowflake Data Cloud as your new cloud platform.

You have onboarded your in-house team and maybe even did the Snowflake MRA program but would like to dig deeper.

You are asking yourself the following questions:
What use cases to start with?
How to prepare a detailed project migration/development plan?
What should be your priorities (business, technical, or both)?
How to set up and steer your team?
Should you outsource or do it in-house?

How to build a detailed architecture, ELT, data marts yes or no?
Introduce new BI and data science tools that would fit better or migrate the old workloads?
How to prepare for testing?
Can you do the lift and shift as is or we need to re-engineer?
What can you automate?
Do you need a backup scenario?
What are the potential bottlenecks and pitfalls you should avoid?

This pack provides you with a guided consultation in a series of in-depth interactive workshops. Our common goal here is to help you address questions of overall architecture, project management, and final services cost.

To really comprehend your organization’s unique needs, we need to deep-dive into your business and industry. We want to know everything about your technical needs, expectations, and priorities.

OUTCOME 1:
Detailed documentation and project plan

  • Document the existing solution (architecture, list of dbs, db objects, schemas, security,process and tools that move data into our/out of existing solution- data ingestion tools, ETL/ELT, BI, Data science and AI…)
  • Migration use cases (draft of deliverables) and define high level strategy: lift and shift – migration as-is, reingeeniring or lift and shift + modernization and planned future architecutre diagram
  • Development and deployment process: list of existing and/or new tools for migration, production/development environment, define deployment process
  • Set priorities for migration (what data sets to migrate first, data sets depencencies to lower the challenges down the road)
  • Set up the migration team (team members and their roles on the project)
  • Migration project timeline (business and technical expectations, detailed migration plan and budget required for the Snowflake resources and migration services)
  • Risk factors (asses possible risk factors based on the strategy chosen and possible plan B)
  • Success factors (set KPIs and success metrics)

With an agile approach »think big, start small« we define project delivery concept:

  • phased project delivery,
  • MVP and in the next step deliver a prototype (in case of major uknowns).

OUTCOME 2:

  • A defined overall architecture, migration strategy, cut-over strategy, system testing & reconciliation strategy
  • Have an assigned project team, project roles and responsibilities
  • Get delivered an end-to-end migration schedule, including a detailed plan and list of migration tasks.

Who should attend?
Key project stakeholders. 

#3 Effort estimate

The devil is in the details

A major benefit claimed for cloud computing is the cost savings, improved scalability and on-demand pricing that drives companies to move their workloads to the cloud. Over the years, we have developed our own cost model and evaluation approach to better understand and make decisions about migrating to the cloud.

If you don’t understand how the cloud migration process works, you will never be able to determine how much effort and resources are required to complete the project and what the actual cost will be.

A good plan is crucial for successful execution.

Cloud migration is not just about simply moving your existing environment to the cloud, it requires a deep dive into your legacy systems, existing code, tools and business cases. Not going into detail means that 90% of the project may be migrated quickly and without much effort, but the other 10% of issues can kill and delay your execution plan.

In our workshops, we will take you on a journey and look at the skeleton of your existing environment with you. Together we will decide what kind of migration plan is better by going case by case, we will make an overview of your existing ETL/ELT jobs and code, decide what needs to be modernised and what can be reused. The key question is also what tools will be used in your future architecture to optimise the workloads and speed up the migration process.

OUTCOMES:

  • Detailed architecture
  • Step-by-step migration plan
  • Detailed project plan (timeline)
  • Effort estimation:
    • Fixed base effort:
      • ETL/ELT jobs
      • Code conversion
    • Variable effort:
      • Modernisation
      • Optimization

Duration: 4-7 weeks (based on complexity)

#4 Second Opinion

Another doctor’s view

You have your first journey to cloud around the corner and you want to evaluate your Cloud Migration Strategy.

Just feeling uncertain about the migration plan you’ve been handed can be reason enough to get a second opinion. After all, no single service provider knows everything about what a migration to the cloud looks like, or all the new best practices and features that cloud technology brings.

However, if you are skeptical about your proposed migration path, it may be worth seeking a second opinion for one of the following reasons:
You are not aware if your migration to cloud is simple or complex?
You doubt that cloud technology is right for you?
Your plan was determined without diving deep into your existing environment and code?
You have a list of offerings that vary widely in cost.


Based on our experience with various migration projects, we know that there is no perfect way how migration to the cloud should look like and therefore there is no generic calculator that defines how much effort is required to execute the migration plan.

In these cases, we offer a set of workshops where we assess your current migration plan, overall cloud strategy, intended architecture, current environment, business requirements and provide you with revised plan and potential recommendations.

Whether you’re planning to move to the cloud on your own, with a partner you’ve already selected, or looking for a new service provider, give us a call and we’ll help you make the right move.

Who should attend? Key project stakeholders 

Duration: 2 – 5 day consultation

Pricing: 2.500 – 5.000 €

#5 Snowflake POC

Test, revise and become a believer

Like many organizations, you’re facing challenges with your existing data warehouse solution and are looking for alternatives. You spend days trying to get data to end-users, your data is scattered in data silos, your on-premise infrastructure is outdated and offers limited scalability. Lack of resources means you can’t address new business cases and semi-structured data without heavy investment in new HW and SW.

Your leadership team wants faster insight into data and you are overwhelmed with new requests. Snowflake Data Cloud offers a new way of thinking and opens up huge opportunities as you move from on-premises to the cloud.

We can help you properly evaluate modern data warehouse architecture on your data, define the most important use cases and KPIs to measure against your current solution.  With Snowflake data cloud you will be able to reap the benefits of modern cloud solutions by addressing any use case that your business needs, without resource contention or infrastructure limitations. With scalability, concurrency, and access to all of your data, speedy and accurate decision-making will be at your fingertips.

POC services include but are not limited to:

  • Introduction of new modern architecture
  • Loading data to the cloud
  • Concurrency testing (workload isolation)
  • Scalability and elasticity
  • Modern ELT approach and BI workloads
  • Semi-structured data
  • Security and user roles
  • Spend monitoring (per-second billing)

OUTCOMES

During the POC we will define the project scope and success criteria. The idea is to test End2End architecture including modern ELT tools for data ingestion and transformation to take the cloud advantages and test your existing or new BI/data science tools against Snowflake.

  • How to set up and run Snowflake instance on any public cloud
  • Define modern end2end solution environment
  • How to set up data Pipelines (ETL/ETL) for the specific business use case (for structured and semi-structured data)
  • Staging
  • Development and Production Environment
  • Business Intelligence/data science tools Integration

#6 Quality assurance

Prevention is better than cure

You have a project already running and as you might have already figured it out – mistakes can (and most probably will) happen. No matter how small they seem at the beginning; they can cost you big time by the end.

Have another set of eyes carefully monitoring the process. The goal of quality assurance services is to provide an additional senior architect to the project to periodically monitor and advise on the project deliverables and overall usage of the cloud platform.

Services included:

  • Methodology revision
  • Architecture revision
  • Code revision
  • Code optimization
  • Security revision

#7 Identify new use cases

Ideas born out of challenges

New use cases are not just a question of technology. Namely, just by using Snowflake, you become part of the Data Cloud, which means your possibilities open exponentially and become literally endless as you become a part of a wide net of interlaced data.

And more data means better insights – but you need to get it right. We need to dig into this from a business perspective to find the right data-driven solution that will build a strong relationship between users and all the data available.

A good use case needs to and business value, so your current challenges and desires are at the core of this.

With minimal up-front investment and reduced need for in-house expertise, you are just one step away from realizing different approaches from the latest trends from your industry on how to think big but start small and fast.

Let us reshuffle the cards of your data sets and open a fresh view of your business.  These are the cases where we can unleash creativity and prepare some real mind-boggling insights that you might not be even aware are there for you.

The list of new use cases is endless, from data sharing possibilities to AI and data lake options – whom better to explore them with than with Snowflake’s most Innovative partner of 2021 in EMEA region.

​#8 Accelerate your time-to-cloud

Born in Innovation Lab

We questioned, tested, and re-evaluated numerous times all the different ways to make our projects faster. How to reduce delivery time, risks, costs? How to bring our customers a few steps ahead of everyone else?

Everything we’ve learned along the way is encapsulated in our assets and industry solutions. If we see it as a well-fitting puzzle, we’ll be glad to power up your stack with the chosen ones.

DataMerlin, Data Warehouse Automation Platform – save time, money & heaps of stress by automating your ETL processes.

Meet the wizard

antFarm, Data Migration Solution – Lift ‘n’ shift your data from on-premise to cloud in a single day. 

Meet the diligent ants

Codify, MDM application – manage your master data and process governance.

Meet the MDM master

Parsaur, The Code Transformation and lineage tool – translate code from one language to another and convert platform-specific capabilities and features

Meet our dino