Pickl AI

JULY 25, 2023

Unfolding the difference between data engineer, data scientist, and data analyst. Data engineers are essential professionals responsible for designing, constructing, and maintaining an organization’s data infrastructure. Read more to know.

Data Engineering 52

Data Engineering Data Engineer Data Engineering Data Engineering 52

phData

FEBRUARY 14, 2023

Data integration is essentially the Extract and Load portion of the Extract, Load, and Transform (ELT) process. Data ingestion involves connecting your data sources, including databases, flat files, streaming data, etc, to your data warehouse. Snowflake provides native ways for data ingestion.

Data Warehouse 59

Data Warehouse Azure AWS Database 59

ODSC - Open Data Science

JUNE 7, 2023

Data has to be stored somewhere. Data warehouses are repositories for your cleaned, processed data, but what about all that unstructured data your organization is starting to notice? What is a data lake? So let’s take a look at a few of the leading industry examples of data lakes. Where does it go?

Data Lakes 52

Data Lakes Azure Hadoop Data Warehouse 52

phData

SEPTEMBER 19, 2023

Thankfully, there are tools available to help with metadata management, such as AWS Glue, Azure Data Catalog, or Alation, that can automate much of the process. What are the Best Data Modeling Methodologies and Processes? Data lakes are meant to be flexible for new incoming data, whether structured or unstructured.

Data Lakes 52

Data Lakes Data Modeling Data Models Data Warehouse 52

phData

MAY 25, 2023

In a perfect world, Microsoft would have clients push even more storage and compute to its Azure Synapse platform. One of the easiest ways for Snowflake to achieve this is to have analytics solutions query their data warehouse in real-time (also known as DirectQuery).

Power BI 84

Power BI Analytics Analytics Azure 84

The MLOps Blog

MAY 17, 2023

This article explores the importance of ETL pipelines in machine learning, a hands-on example of building ETL pipelines with a popular tool, and suggests the best ways for data engineers to enhance and sustain their pipelines. Before delving into the technical details, let’s review some fundamental concepts.

ETL 59

ETL Data Pipeline ML ML 59

phData

JULY 18, 2023

With the birth of cloud data warehouses, data applications, and generative AI , processing large volumes of data faster and cheaper is more approachable and desired than ever. First up, let’s dive into the foundation of every Modern Data Stack, a cloud-based data warehouse.

Data Warehouse 52

Data Warehouse SQL Analytics Analytics 52

phData

AUGUST 4, 2023

The external stage area includes Microsoft Azure Blob storage, Amazon AWS S3, and Google Cloud Storage. Amazon S3 for AWS, Azure Blob Storage for Azure, or Google Cloud Storage for GCP) to store the actual data files in micro-partitions. They are flexible, secure, and provide exceptional performance.

Database 52

Database Azure SQL AWS 52

The MLOps Blog

JANUARY 23, 2023

However, there are some key differences that we need to consider: Size and complexity of the data In machine learning, we are often working with much larger data. Basically, every machine learning project needs data. Given the range of tools and data types, a separate data versioning logic will be necessary.

ML 52

ML ML Data Lakes Machine Learning 52

Analytics Vidhya

FEBRUARY 25, 2023

Introduction A data lake is a centralized and scalable repository storing structured and unstructured data. The need for a data lake arises from the growing volume, variety, and velocity of data companies need to manage and analyze.

Data Lakes 167

Data Lakes Analytics Analytics Data Warehouse 167

Alation

FEBRUARY 8, 2022

While data fabric takes a product-and-tech-centric approach, data mesh takes a completely different perspective. Data mesh inverts the common model of having a centralized team (such as a data engineering team), who manage and transform data for wider consumption. But why is such an inversion needed?

Data Governance 52

Data Governance Data Engineering Data Engineer Data Engineering 52