Monte Carlo

JANUARY 25, 2023

When it comes to the question of building or buying your data stack, there’s never a one-size-fits-all solution for every data team—or every component of your data stack. Data storage and compute are very much the foundation of your data platform. Let’s jump in!

Data Warehouse 40

Data Warehouse Building Data Lake Data Storage 40

ProjectPro

AUGUST 11, 2021

“Data Lake vs Data Warehouse = Load First, Think Later vs Think First, Load Later” The terms data lake and data warehouse are frequently stumbled upon when it comes to storing large volumes of data. Data Warehouse Architecture What is a Data lake?

Data Lake 52

Data Lake Data Warehouse Cloud Hadoop 52

Christophe Blefari

MARCH 1, 2023

dbt Core is an open-source framework that helps you organise data warehouse SQL transformation. dbt was born out of the analysis that more and more companies were switching from on-premise Hadoop data infrastructure to cloud data warehouses. This switch has been lead by modern data stack vision.

Data Warehouse 278

Data Warehouse SQL Metadata Raw Data 278

Knowledge Hut

APRIL 25, 2024

Each of these technologies has its own strengths and weaknesses, but all of them can be used to gain insights from large data sets. As organizations continue to generate more and more data, big data technologies will become increasingly essential. Let's explore the technologies available for big data.

Big Data 98

Big Data Technology NoSQL Hadoop 98

Hevo

MAY 10, 2024

Amazon S3 is a prominent data storage platform with multiple storage and security features. Integrating data stored in Amazon S3 to a data warehouse like Databricks can enable better data-driven decisions. Integrating data from Amazon S3 to Databricks […]

Data Integration 52

Data Integration Data Warehouse Data Storage Machine Learning 52

Towards Data Science

MARCH 23, 2023

The difference between tables and views and how to use them Continue reading on Towards Data Science »

Data Warehouse 77

Data Warehouse Data Science Data Cloud Computing 77

Hevo

MAY 17, 2024

You can use it effectively for customer data management, but it does not facilitate efficient data storage. To resolve this limitation, you can integrate Salesforce with data warehouses like Snowflake. Snowflake It allows you […]

Cloud 40

Cloud Media Data Warehouse Data Storage 40

Hevo

MAY 9, 2024

Nowadays, with ever-increasing data, storage and analysis of large volumes of data have become basic foundations of any organization. While focusing on storage and analysis, which two concepts come to your mind? That’s a database and a data warehouse, right?

AWS 40

AWS Data Warehouse Data Storage Database 40

Christophe Blefari

JANUARY 20, 2024

Data engineering inherits from years of data practices in US big companies. Hadoop initially led the way with Big Data and distributed computing on-premise to finally land on Modern Data Stack — in the cloud — with a data warehouse at the center. Picking the right format for your data storage.

Data Engineering 130

Data Engineering Data Engineer Engineering Hadoop 130

Christophe Blefari

AUGUST 4, 2023

The modern data stack as a collection of tools which interacts altogether to serve data to consumers is still relevant. Personally I think that the modern data stack characterises by having a central data storage in which everything happens. DuckDB is not really a data warehouse.

Google Cloud 225

Google Cloud MongoDB NoSQL Data 225

Knowledge Hut

MARCH 28, 2024

Job Role 1: Azure Data Engineer Azure Data Engineers develop, deploy, and manage data solutions with Microsoft Azure data services. They use many data storage, computation, and analytics technologies to develop scalable and robust data pipelines.

Data Engineering 52

Data Engineering Data Engineer Engineering Data Warehouse 52

Cloudera

DECEMBER 12, 2018

After having rebuilt their data warehouse, I decided to take a little bit more of a pointed role, and I joined Oracle as a database performance engineer. I spent eight years in the real-world performance group where I specialized in high visibility and high impact data warehousing competes and benchmarks.

Data Warehouse 42

Data Warehouse Relational Database Hadoop BI 42

Christophe Blefari

NOVEMBER 11, 2022

I'll speak about "How to build the data dream team" Let's jump onto the news. Ingredients of a Data Warehouse Going back to basics. Kovid wrote an article that tries to explain what are the ingredients of a data warehouse. And he does it well. In the post Kovid details every idea.

BI 130

BI Data Warehouse Data Database 130

The Modern Data Company

MAY 10, 2023

In our previous post, The Pros and Cons of Leading Data Management and Storage Solutions , we untangled the differences among data lakes, data warehouses, data lakehouses, data hubs, and data operating systems. Does not have the resources to implement robust data governance and management.

Data Management 52

Data Management Data Lake Management Data Warehouse 52

The Modern Data Company

MAY 10, 2023

In our previous post, The Pros and Cons of Leading Data Management and Storage Solutions , we untangled the differences among data lakes, data warehouses, data lakehouses, data hubs, and data operating systems. Does not have the resources to implement robust data governance and management.

Data Management 52

Data Management Management Data Lake Data Warehouse 52

The Modern Data Company

MAY 10, 2023

In our previous post, The Pros and Cons of Leading Data Management and Storage Solutions , we untangled the differences among data lakes, data warehouses, data lakehouses, data hubs, and data operating systems. Does not have the resources to implement robust data governance and management.

Data Management 52

Data Management Management Data Lake Data Warehouse 52

Christophe Blefari

SEPTEMBER 25, 2023

A guide to the Snowflake results cache — Cache is a critical piece to every data warehouse either for reusing data between runs or between stages in the same run. I'd say that Iceberg (or table formats) are probably one of the technology that will incrementally change for the better the way we write data pipelines.

Data 130

Data Data Warehouse Data Storage Data Pipeline 130

Christophe Blefari

SEPTEMBER 25, 2023

A guide to the Snowflake results cache — Cache is a critical piece to every data warehouse either for reusing data between runs or between stages in the same run. I'd say that Iceberg (or table formats) are probably one of the technology that will incrementally change for the better the way we write data pipelines.

Data 130

Data Data Warehouse Data Storage Data Pipeline 130

Simon Späti

NOVEMBER 28, 2018

However, this is still not common in the Data Warehouse (DWH) field. In my recent blog, I researched OLAP technologies, for this post I chose some open-source technologies and used them together to build a full data architecture for a Data Warehouse system. Why is this?

Data Warehouse 130

Data Warehouse Data Storage Data Architecture Architecture 130

Databand.ai

JULY 19, 2023

A Beginner’s Guide [SQ] Niv Sluzki July 19, 2023 ELT is a data processing method that involves extracting data from its source, loading it into a database or data warehouse, and then later transforming it into a format that suits business needs. The data is loaded as-is, without any transformation.

Data Cleanse 52

Data Cleanse Raw Data Data Storage Data Warehouse 52

Christophe Blefari

FEBRUARY 24, 2023

In order to improve your data infra you should sometimes try to occasionally kill your data stack , chaos engineering is something that helps discover issues. At the moment the best way to develop in your data warehouse is still in the query editor of BigQuery / Snowflake / etc., Often they are right.

Kafka 130

Kafka Data Lake Data Storage Data 130

Hevo

MAY 18, 2023

A plain text file containing a list of data separated by commas is known as a Comma Separated Values (CSV) file. Data is regularly transferred between apps using these files. BigQuery, Google’s data warehouse as a service, combines data storage and analytics in one package. BigQuery allows […]

Data Warehouse 52

Data Warehouse Data Storage Data Database 52

phData: Data Engineering

SEPTEMBER 19, 2023

This blog will guide you through the best data modeling methodologies and processes for your data lake, helping you make informed decisions and optimize your data management practices. What is a Data Lake? What are Data Modeling Methodologies, and Why Are They Important for a Data Lake?

Data Lake 52

Data Lake Process Metadata Data Warehouse 52

Monte Carlo

APRIL 27, 2023

Empowered by the rise of the modern data stack , leading companies like Warner Music Group , Chime and Petsmart are now turning to the Composable CDP to unlock a modular customer data architecture that centers on the cloud data warehouse. Why not build one single store of customer data to activate from centrally?

Data Warehouse 72

Data Warehouse Data Collection Architecture Data Storage 72

Hevo

AUGUST 17, 2023

Organizations rely on multiple databases and cloud-based solutions for their ever-expanding data storage needs. However, for in-depth analysis of organizational data, it is essential to perform seamless integrations between different platforms.

MySQL 52

MySQL Data Warehouse Data Storage Database 52

Monte Carlo

MARCH 28, 2023

As part of this movement, Fivetran and dbt fundamentally altered the data pipeline from ETL to ELT. Hightouch interrupted SaaS eating the world in an attempt to shift the center of gravity to the data warehouse. Other common light transformations done within the ingestion phase are data formatting and deduplication.

Data Warehouse 126

Data Warehouse Raw Data Data Pipeline Software Engineer 126

Christophe Blefari

SEPTEMBER 28, 2023

Historically, data pipelines were designed with an ETL approach, storage was expensive and we had to transform the data before using it. With the cloud, we got the—false—impression that resources were infinite and cheap, so we switched to ETL by pushing everything into a central data storage.

Cloud Storage 147

Cloud Storage Big Data Hadoop SQL 147

Data Engineering Weekly

DECEMBER 2, 2023

Revisiting The Current State of Data Infrastructure Let’s revisit the current state of the data infrastructure before discussing the S3 Express. There are two critical properties of data warehouse access patterns. Data freshness matters a lot—the more recent the data, the more frequently it is accessed.

IT 85

IT BI AWS Kafka 85

AltexSoft

AUGUST 29, 2023

In 2010, a transformative concept took root in the realm of data storage and analytics — a data lake. The term was coined by James Dixon , Back-End Java, Data, and Business Intelligence Engineer, and it started a new era in how organizations could store, manage, and analyze their data.

Data Lake 52

Data Lake Architecture IT Amazon Web Services 52

DareData

JANUARY 30, 2023

In this post, we'll discuss some key data engineering concepts that data scientists should be familiar with, in order to be more effective in their roles. These concepts include concepts like data pipelines, data storage and retrieval, data orchestrators or infrastructure-as-code.

Data Engineering 52

Data Engineering Data Engineer NoSQL Engineering 52

Monte Carlo

JANUARY 5, 2024

You know what they always say: data lakehouse architecture is like an onion. …ok, Data lakehouse architecture combines the benefits of data warehouses and data lakes, bringing together the structure and performance of a data warehouse with the flexibility of a data lake. But they should!

Architecture 52

Architecture Data Lake Metadata Unstructured Data 52

Monte Carlo

JANUARY 5, 2024

You know what they always say: data lakehouse architecture is like an onion. …ok, Data lakehouse architecture combines the benefits of data warehouses and data lakes, bringing together the structure and performance of a data warehouse with the flexibility of a data lake. But they should!

Architecture 52

Architecture Data Lake Metadata Unstructured Data 52

Knowledge Hut

NOVEMBER 17, 2023

Database Knowledge Data warehousing ideas like the star and snowflake schema, as well as how to design and develop a data warehouse, should be well understood by you. This involves knowing how to manage data partitions, load data into a data warehouse, and speed up query execution.

Data Engineering 52

Data Engineering Data Engineer Engineering Scala 52

The Modern Data Company

MAY 8, 2023

Data lakes, data warehouses, data hubs, data lakehouses, and data operating systems are data management and storage solutions designed to meet different needs in data analytics, integration, and processing. However, data warehouses can experience limitations and scalability challenges.

Data Management 52

Data Management Data Lake Management Data Governance 52

The Modern Data Company

MAY 8, 2023

Data lakes, data warehouses, data hubs, data lakehouses, and data operating systems are data management and storage solutions designed to meet different needs in data analytics, integration, and processing. However, data warehouses can experience limitations and scalability challenges.

Data Management 52

Data Management Data Lake Management Data Governance 52

The Modern Data Company

MAY 8, 2023

Data lakes, data warehouses, data hubs, data lakehouses, and data operating systems are data management and storage solutions designed to meet different needs in data analytics, integration, and processing. However, data warehouses can experience limitations and scalability challenges.

Data Management 52

Data Management Data Lake Management Data Governance 52

Cloudera

AUGUST 31, 2021

Cloudera and Accenture demonstrate strength in their relationship with an accelerator called the Smart Data Transition Toolkit for migration of legacy data warehouses into Cloudera Data Platform. Accenture’s Smart Data Transition Toolkit . Are you looking for your data warehouse to support the hybrid multi-cloud?

Data Warehouse 81

Data Warehouse Database-centric Metadata Cloud 81