Big data Archieven - Nimbus Intelligence

Set 22

Data Engineer vs Analytics Engineer: What’s the difference?

By Darko Monzio Compagnoni Uncategorized No Comments

Since I started my Analytics Engineer traineeship at Nimbus Intelligence, I noticed that this emerging role is often confused with the Data Engineer role. Photo source: Analytics Engineer: Job Description,…

Apr 20

Love0

Optimizing SQL Queries in Snowflake

By Sebastian Wiesner Data, Snowflake, SQL

In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake for better performance. Best practices for query design, data structure optimization, utilizing Snowflake's features, and…

Apr 07

Love0

Two ways to populate a table with stage data

By Niccolo Racioppi Data, Data Load, Database, Snowflake, SQL, Uncategorized

MATCH_BY_COLUMN_NAME vs Variant data type I found myself having to insert files from my device into my database.The final aim of the process was to obtain a table with the…

Apr 07

Love0

Snowflake SnowPro: How to probably Ace it

By Sebastian Wiesner Academy, Snowflake

As an Analytics Engineer trainee, I recently took the Snowflake Snowpro Core Certification exam. Before taking the exam, I had been working with Snowflake for seven weeks, mainly for simple…

Apr 07

Love0

How to become a SnowPro

By Niccolo Racioppi Academy, Data, Database, Snowflake

I took the SnowPro Core Certification exam. SnowPro Core certification badge I will make some observations and give some advice on how I approached preparing for the exam and how…

Mar 22

Love0

Data Lake or Data Warehouse? When to Use Which

By Dimitris Lampriadis Snowflake

Βusinesses that are working with data must determine how to store, manage, and analyze them efficiently. Two popular options for data storage are data lakes and data warehouses. In this…

Mar 22

Love0

Streamline Workflows with Snowflake-ServiceNow Integration

By Sebastian Wiesner Snowflake

In today's data-driven world, businesses are constantly seeking new approaches to access and analyze data. Therefore, Snowflake's recent integration with ServiceNow is creating a lot of excitement. This connector is…

Mar 21

Love0

Snowflake Stages: a brief explanation

By Mario Calise Data Load, Database, Snowflake

Data storage is a critical component of any database system. When dealing with large amounts of data it is unthinkable to assume having to manually enter information - row by…