Moving On-Prem Data Warehouses to Snowflake: Mastering the Art of Data Migration Phase 

We started our analytical journey more than 15 years ago, providing end-to-end solutions to our clients – from data strategy, business analytics, data warehouse implementation and data integration, to business intelligence or AI use cases. 6 years ...

Optimize Performance on Snowflake

While Snowflake does all query tuning and optimization behind the scenes without DBA support, there are nevertheless situations, especially when we are dealing with huge amounts of data, when a little help from a Snowflake administrator is needed. Qu ...

Migrating Oracle Functions, Procedures and Packages to Snowflake

Oracle to Snowflake Migration Series, part 5 Snowflake supports functions and procedures, but not packages. Many Oracle implementations use packages to encapsulate functions, stored procedures and global variables that belong together. Any code that ...

We opened a branch office in Dubai!

Exciting news! Our company is thrilled to announce the opening of a new branch office in Dubai to better serve our clients in the region with our top-notch analytical services. As one of the leading European providers of analytical services, we are ...

Insurance Cloud Migration – The solution to the industry’s challenges

Leverage the power of data and eliminate your challenges Every year the insurance industry continues to expand all over the world. Here are some facts: in Germany, the Gross Written Premium data was reported at 220 million EURO in 2020. And in the Un ...

Convert Oracle code to Snowflake

Oracle to Snowflake Migration Series, part 4 Convert Oracle code to Snowflake: By converting code, we are referring to Oracle PL/SQL procedures, functions, and packages that will be migrated. Since Snowflake supports SQL scripting, many of the progra ...

Hitchhiker’s guide to the Snowflake Data Cloud

There are many compelling reasons why companies around the world are moving to Snowflake, but many are dreading of the big M – Migration. It can be a risky, costly, time-consuming and challenging project. But as with everything in life, the sam ...

Initial Data Extract and Load

Oracle to Snowflake Migration Series, part 3 We have many options for extracting data from Oracle into Snowflake. Some approaches that we can use for migrating from Oracle include: Legacy tools such as UTL_FILE packages, SQL*Plus, or the Export utili ...

Create Data Structures

Oracle to Snowflake Migration Series, part 2 Before we can perform an initial data extract and load, we have to create data structures for data warehouse tables and other objects that will be migrated. These may include tables, views, sequences, func ...

Oracle to Snowflake Migration Case Study Presentation

Oracle to Snowflake Migration Series, part 1 Case study As a case study, we will present one of our migrations from Oracle to Snowflake and share our findings. In addition to achieving benefits when migrating from Oracle to Snowflake, there were spec ...

Oracle to Snowflake Migration Benefits

Oracle to Snowflake Migration Series Oracle is among the leading database management systems for running online transaction processing and data warehousing systems. With increasing volume, velocity, and variety of data that is at our disposal for mod ...

Krepimo ekipo

Iščemo podatkovnega analitika začetnika (m/ž) (študentsko delo z možnostjo redne zaposlitve) Pri nas namreč SVETLA PRIHODNOST NE MINE KOT KEKS, saj: • si želimo dolgoročnega sodelovanja,• imamo sistem onboardinga in mentorstva na najviš ...