AWS Big Data

FEBRUARY 24, 2023

Data lakes are a popular choice for today’s organizations to store their data around their business activities. As a best practice of a data lake design, data should be immutable once stored. A data lake built on AWS uses Amazon Simple Storage Service (Amazon S3) as its primary storage environment.

Data Lake 91

Data Lake Metadata Testing Data Warehouse 91

AWS Big Data

NOVEMBER 7, 2024

Refer to Easy analytics and cost-optimization with Amazon Redshift Serverless to get started. Let’s ask Amazon Q “Can you give me the total sales for 1998, from different sales channels, using a union of the sales data from different channels?” It can help optimize the generation process by reducing unnecessary table references.

Metadata 97

Metadata Sales Data Warehouse Optimization 97

AWS Big Data

OCTOBER 14, 2024

Enterprise data is brought into data lakes and data warehouses to carry out analytical, reporting, and data science use cases using AWS analytical services like Amazon Athena , Amazon Redshift , Amazon EMR , and so on.

Metadata 89

Metadata Data Lake Modeling Data Warehouse 89

AWS Big Data

JANUARY 26, 2023

AWS Glue provides an extensible architecture that enables users with different data processing use cases. A common use case is building data lakes on Amazon Simple Storage Service (Amazon S3) using AWS Glue extract, transform, and load (ETL) jobs. AWS Glue version Hudi Delta Lake Iceberg AWS Glue 3.0 AWS Glue 4.0

Data Lake 121

Data Lake Big Data Software Interactive 121

AWS Big Data

JANUARY 9, 2025

Iceberg offers distinct advantages through its metadata layer over Parquet, such as improved data management, performance optimization, and integration with various query engines. Unlike direct Amazon S3 access, Iceberg supports these operations on petabyte-scale data lakes without requiring complex custom code.

Metadata 107

Metadata Snapshot Cost-Benefit Optimization 107

AWS Big Data

APRIL 8, 2025

In modern data architectures, Apache Iceberg has emerged as a popular table format for data lakes, offering key features including ACID transactions and concurrent write support. For more detailed configuration, refer to Write properties in the Iceberg documentation.

Snapshot 117

Snapshot Management Metadata Big Data 117

AWS Big Data

AUGUST 3, 2023

Data analytics on operational data at near-real time is becoming a common need. Due to the exponential growth of data volume, it has become common practice to replace read replicas with data lakes to have better scalability and performance. Apache Hudi connector for AWS Glue For this post, we use AWS Glue 4.0,

Data Lake 88

Data Lake Visualization Dashboards Insurance 88

AWS Big Data

JANUARY 27, 2023

This post shows you how to integrate Apache Flink in Amazon EMR with the AWS Glue Data Catalog so that you can ingest streaming data in real time and access the data in near-real time for business analysis. For data read/write, Flink has the interface DynamicTableSourceFactory for read and DynamicTableSinkFactory for write.

Data Lake 67

Data Lake Metadata Business Analysis Data-driven 67

CIO Business Intelligence

JULY 31, 2024

With this platform, Salesforce seeks to help organizations apply the cleverness of LLMs to the customer data they have squirreled away in Salesforce data lakes in the hopes of selling more. Einstein 1 Studio handles the piping so the data from your Einstein 1 platform instance will flow smoothly into the AI.

Data Lake 119

Data Lake IT Sales Experimentation 119

AWS Big Data

NOVEMBER 29, 2023

We have seen a strong customer demand to expand its scope to cloud-based data lakes because data lakes are increasingly the enterprise solution for large-scale data initiatives due to their power and capabilities. Let’s say that this company is located in Europe and the data product must comply with the GDPR.

Data Lake 117

Data Lake Management Metrics Data Warehouse 117

AWS Big Data

JUNE 25, 2024

This post is co-authored by Vijay Gopalakrishnan, Director of Product, Salesforce Data Cloud. In today’s data-driven business landscape, organizations collect a wealth of data across various touch points and unify it in a central data warehouse or a data lake to deliver business insights.

Data Lake 112

Data Lake Cost-Benefit Data-driven Data Warehouse 112

AWS Big Data

MAY 29, 2024

These users interact with and run analytical queries across AWS analytics services. To enable them to use the AWS services, their identities from the external IdP are mapped to AWS Identity and Access Management (IAM) roles within AWS, and access policies are applied to these IAM roles by data administrators.

Data Lake 94

Data Lake Enterprise Management Business Intelligence 94

Smart Data Collective

DECEMBER 13, 2022

There are several choices to consider, each with its own set of advantages and disadvantages: Data warehouses are used to store data that has been processed for a specific function from one or more sources. Data lakes hold raw data that has not yet been altered to meet a specific purpose.

Visualization 145

Visualization Key Performance Indicator Sales Advertising 145

Alation

FEBRUARY 20, 2020

When it was no longer a hard requirement that a physical data model be created upon the ingestion of data, there was a resulting drop in richness of the description and consistency of the data stored in Hadoop. You did not have to understand or prepare the data to get it into Hadoop, so people rarely did.

Data Lake 52

Data Lake Metadata Structured Data Big Data 52

AWS Big Data

JUNE 20, 2023

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon Simple Storage Service (Amazon S3) and data sources residing in AWS, on-premises, or other cloud systems using SQL or Python. He works with enterprise customers building data products, analytics platforms, and solutions on AWS.

Data Lake 83

Data Lake Data Science Recreation/Entertainment Experimentation 83

AWS Big Data

FEBRUARY 13, 2025

Refer to the appendix at the end of this post for more details. To organize the data assets within the organization, the admin logs in to the SageMaker Unified Studio URL and creates domain units aligned with the business divisions. Refer to the appendix at the end of this post for more details.

Data Analytics 72

Data Analytics Analytics Modeling Management 72

AWS Big Data

FEBRUARY 29, 2024

Unstructured data is typically stored across siloed systems in varying formats, and generally not managed or governed with the same level of rigor as structured data. On the backend, the batch data engineering processes refreshing the enterprise data lake need to expand to ingest, transform, and manage unstructured data.

Data Governance 110

Data Governance Unstructured Data Metadata Data Lake 110

CIO Business Intelligence

JUNE 29, 2022

Data Explorer is a big data analytics platform that you can use, as the name suggests, for exploring data using KQL, also known as the Kusto Query Language, from the codename for the project which may or may not be a reference to exploring your ocean of data as if you were Jacques Cousteau.

Data Lake 116

Data Lake Analytics Data Warehouse Machine Learning 116

AWS Big Data

JANUARY 31, 2023

We have collected some of the key talks and solutions on data governance, data mesh, and modern data architecture published and presented in AWS re:Invent 2022, and a few data lake solutions built by customers and AWS Partners for easy reference.

Data Lake 90

Data Lake Data Governance Data Architecture Machine Learning 90

AWS Big Data

APRIL 30, 2024

Amazon Q Developer can now generate complex data integration jobs with multiple sources, destinations, and data transformations. and Amazon Q provides concise explanations along with references you can use to follow up on your questions and validate the guidance. Configure an IAM role to interact with Amazon Q.

Data Integration 117

Data Integration Data Lake Data Warehouse Software 117

AWS Big Data

JANUARY 17, 2024

With Amazon EMR 6.15, we launched AWS Lake Formation based fine-grained access controls (FGAC) on Open Table Formats (OTFs), including Apache Hudi, Apache Iceberg, and Delta lake. Many large enterprise companies seek to use their transactional data lake to gain insights and improve decision-making.

Data Lake 107

Data Lake Snapshot Big Data Data-driven 107

erwin

AUGUST 15, 2022

For NoSQL, data lakes, and data lake houses—data modeling of both structured and unstructured data is somewhat novel and thorny. This blog is an introduction to some advanced NoSQL and data lake database design techniques (while avoiding common pitfalls) is noteworthy. Data Modeling.

Data Lake 52

Data Lake Modeling Unstructured Data Data Warehouse 52

Dataiku

SEPTEMBER 1, 2023

Lately, the concept of data experience has been gaining attention in discussions around the enterprise data stack. As the name suggests, it refers to how people interact with data in enterprise settings. Due to fragmented data setups in these companies, their data lakes have the following characteristics:

Data Lake 69

Data Lake Data Analytics Analytics Interactive 69

AWS Big Data

MARCH 23, 2023

Data producer setup In this section, we present the steps to set up the data producer. In the navigation pane, under Register and ingest , choose Data lake locations. For additional information about roles, refer to Requirements for roles used to register locations. Choose Register location.

Interactive 76

Interactive Snapshot Data Lake Software 76

DataKitchen

JUNE 12, 2023

I spent much time de-categorizing DataOps: we are not discussing ETL, Data Lake, or Data Science. Today we have had over 20,000 signatures , millions of page views, and copycat clones, and it is frequently used as a reference guide. It’s Customer Journey for data analytic systems.

Testing 130

Testing Dashboards Data Lake Data Science 130

AWS Big Data

OCTOBER 23, 2023

For interactive applications, Athena Spark allows you to spend less time waiting and be more productive, with application startup time in under a second. Running SQL on data lakes is fast, and Athena provides an optimized, Trino- and Presto-compatible API that includes a powerful optimizer.

Data Lake 116

Data Lake Visualization Optimization Interactive 116

AWS Big Data

MARCH 2, 2023

Many organizations are building data lakes to store and analyze large volumes of structured, semi-structured, and unstructured data. In addition, many teams are moving towards a data mesh architecture, which requires them to expose their data sets as easily consumable data products.

Data Lake 84

Data Lake Testing Interactive Unstructured Data 84

AWS Big Data

APRIL 26, 2023

To enable this use case, we used the BMW Group’s cloud-native data platform called the Cloud Data Hub. In 2019, the BMW Group decided to re-architect and move its on-premises data lake to the AWS Cloud to enable data-driven innovation while scaling with the dynamic needs of the organization.

Forecasting 130

Forecasting Manufacturing Data Lake Big Data 130

AWS Big Data

NOVEMBER 10, 2023

The data sourcing problem To ensure the reliability of PySpark data pipelines, it’s essential to have consistent record-level data from both dimensional and fact tables stored in the Enterprise Data Warehouse (EDW). These tables are then joined with tables from the Enterprise Data Lake (EDL) at runtime.

Data Processing 105

Data Processing Data Lake Data Warehouse Optimization 105

AWS Big Data

NOVEMBER 20, 2023

Use case A typical workload for AWS Glue for Apache Spark jobs is to load data from a relational database to a data lake with SQL-based transformations. For instructions, refer to Create a CloudWatch alarm based on a static threshold. When the example job ran, the workerUtilization metrics showed the following trend.

Metrics 109

Metrics Data Lake Cost-Benefit Dashboards 109

AWS Big Data

MARCH 25, 2024

To learn more about RAG, refer to Question answering using Retrieval Augmented Generation with foundation models in Amazon SageMaker JumpStart. A RAG-based generative AI application can only produce generic responses based on its training data and the relevant documents in the knowledge base.

Data Lake 105

Data Lake Unstructured Data Management Snapshot 105

AWS Big Data

MARCH 7, 2023

Flexible and easy to use – The solutions should provide less restrictive, easy-to-access, and ready-to-use data. A data hub contains data at multiple levels of granularity and is often not integrated. It differs from a data lake by offering data that is pre-validated and standardized, allowing for simpler consumption by users.

Analytics 79

Analytics Data Warehouse Data Lake Metadata 79

AWS Big Data

MARCH 21, 2024

For your application’s low-latency and real-time data access, you can use Lambda and DynamoDB. For longer-term data storage, you can use managed serverless connector service Amazon Data Firehose to send data to your data lake. To use the console, refer to Getting started using MSK Serverless clusters.

Data Lake 111

Data Lake Management Modeling Optimization 111

AWS Big Data

AUGUST 16, 2023

Iceberg has become very popular for its support for ACID transactions in data lakes and features like schema and partition evolution, time travel, and rollback. For more details, refer to Creating Apache Iceberg tables. The customer wants to make product data accessible to analyst personas for interactive analysis using Athena.

Data Lake 86

Data Lake Metadata Snapshot Management 86

AWS Big Data

AUGUST 19, 2024

This report is essential for understanding revenue streams, identifying opportunities for optimization, and making data-driven decisions regarding pricing and promotions. Refer to Enabling AWS PrivateLink in the Snowflake documentation to verify the steps, required access level, and service level to set the configurations. Choose Next.

Analytics 108

Analytics Data-driven Data Integration Data Lake 108

AWS Big Data

NOVEMBER 16, 2023

Amazon Redshift is a popular cloud data warehouse, offering a fully managed cloud-based service that seamlessly integrates with an organization’s Amazon Simple Storage Service (Amazon S3) data lake, real-time streams, machine learning (ML) workflows, transactional workflows, and much more—all while providing up to 7.9x

Enterprise 98

Enterprise Data Warehouse Data Lake Optimization 98

AWS Big Data

JUNE 8, 2023

This data is often stored and analyzed using various tools, such as Amazon OpenSearch Service , a powerful search and analytics service offered by AWS. OpenSearch Service provides real-time insights into your data to support use cases like interactive log analytics, real-time application monitoring, website search, and more.

Data Lake 87

Data Lake Dashboards Metrics Testing 87