Data warehousing Archieven - Nimbus Intelligence

Mar 08

The Data Evolution: Embracing ELT for Agile Data Warehousing

By Jordi Kiesewetter Uncategorized No Comments

1 ELT has been making its way into the data world these past years and making a name for itself as organizations continually seek innovative approaches to streamline processes, harness…

Jan 26

Love0

Unpacking Data Warehousing Philosophies: Kimball vs. Inmon

By Jordi Kiesewetter Uncategorized No Comments

When it comes to handling data, two big methods stand out: Kimball and Inmon. They both have their ways of setting up and running data warehouses, and each comes with…

Nov 10

Love0

Snowflake Hybrid Tables

By Luca Balduzzi Database, Snowday, Snowflake No Comments

Hybrid Tables in Snowflake are a new type of table that can support transactional workloads. They store data in a row-oriented format, and allow fast single-row operations as well as…

Apr 14

Love0

From JSON to XML: A Deep Dive into Snowflakes File Types

By Sebastian Wiesner Data Load, Snowflake

Snowflake is a cloud-based data warehousing solution that has become increasingly popular in recent years due to its scalability and ease of use. As more and more businesses adopt Snowflake…

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

Snowflake’s Security Measures against Cyber Threats

By Sebastian Wiesner Data, Database, Snowflake

The Barrier Between Your Data and Cyber Threats Snowflake's data platform has gained popularity for its advanced security measures. Data security is becoming an ever growing concern for companies of…

Mar 23

Love0

Keeping Your Data Safe: Blockchain vs. Snowflake

By Sebastian Wiesner Database, Snowflake

Businesses today are highly concerned with safeguarding their data. While Snowflake has established itself as a reliable data storage player, blockchains are yet to gain significant popularity in this domain.…

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 20

Love0

Snowflake: Melting our Environment?

By Sebastian Wiesner Database, Snowflake

In the digital age, we generate vast amounts of data that need to be stored and processed. Cloud-based data warehouses like Snowflake Database have emerged as a solution for handling…