Snowflake

NOVEMBER 2, 2023

Over the years, the technology landscape for data management has given rise to various architecture patterns, each thoughtfully designed to cater to specific use cases and requirements. These patterns include both centralized storage patterns like data warehouse , data lake and data lakehouse , and distributed patterns such as data mesh.

Data Lake 94

Data Lake Data Warehouse Cloud Unstructured Data 94

Cloudera

SEPTEMBER 24, 2020

Some of the most powerful results come from combining complementary superpowers, and the “dynamic duo” of Apache Hive LLAP and Apache Impala, both included in Cloudera Data Warehouse , is further evidence of this. Both Impala and Hive can operate at an unprecedented and massive scale, with many petabytes of data.

Data Warehouse 72

Data Warehouse SQL Engineering Metadata 72

Data Engineering Podcast

MAY 1, 2022

Atlan is a collaborative workspace for data-driven teams, like Github for engineering or Figma for design teams. Datafold built automated regression testing to help data and analytics engineers deal with data quality in their pull requests. No more shipping and praying, you can now know exactly what will change in your database!

Data Warehouse 100

Data Warehouse Data Integration Cloud Google Cloud 100

Data Engineering Podcast

NOVEMBER 4, 2018

Summary Business intelligence is a necessity for any organization that wants to be able to make informed decisions based on the data that they collect. Unfortunately, it is common for different portions of the business to build their reports with different assumptions, leading to conflicting views and poor choices.

Business Intelligence 100

Business Intelligence Hadoop BI Data Warehouse 100

Data Engineering Podcast

OCTOBER 28, 2021

He also explains why he started Decodable to address that limitation and the work that he and his team have done to let data engineers build streaming pipelines entirely in SQL. Start trusting your data with Monte Carlo today! Hightouch is the easiest way to sync data into the platforms that your business teams rely on.

Data Pipeline 100

Data Pipeline SQL Data Warehouse Data Lake 100

Monte Carlo

FEBRUARY 6, 2023

So, you’re planning a cloud data warehouse migration. But be warned, a warehouse migration isn’t for the faint of heart. As you probably already know if you’re reading this, a data warehouse migration is the process of moving data from one warehouse to another. A worthy quest to be sure.

Data Warehouse 52

Data Warehouse AWS Data Validation Data 52

Christophe Blefari

JUNE 21, 2024

Snowflake was founded in 2012 around its data warehouse product, which is still its core offering, and Databricks was founded in 2013 from academia with Spark co-creator researchers, becoming Apache Spark in 2014. you could write the same pipeline in Java, in Scala, in Python, in SQL, etc.—with 3) Spark 4.0

Metadata 147

Metadata Data Warehouse BI Scala 147

Monte Carlo

AUGUST 25, 2023

Different vendors offering data warehouses, data lakes, and now data lakehouses all offer their own distinct advantages and disadvantages for data teams to consider. So let’s get to the bottom of the big question: what kind of data storage layer will provide the strongest foundation for your data platform?

Data Lake 52

Data Lake Data Warehouse Unstructured Data Raw Data 52

Cloudera

MARCH 2, 2022

Analytical SQL workloads use aggregates and joins heavily. This memory efficiency and performance optimization, as well as many others in Impala, is what makes it the preferred choice for business intelligence and analytics workloads, especially at scale. You can also contact your sales representative to book a demo.

Data Warehouse 90

Data Warehouse Bytes Data Business Intelligence 90

Data Engineering Podcast

FEBRUARY 5, 2023

Materialize’s PostgreSQL-compatible interface lets users leverage the tools they already use, with unsurpassed simplicity enabled by full ANSI SQL support. Sign up now for early access to Materialize and get started with the power of streaming data with the same simplicity and low implementation cost as batch cloud data warehouses.

Data Engineering 147

Data Engineering Data Engineer Engineering PostgreSQL 147

Data Engineering Podcast

JANUARY 8, 2023

In this episode Ori Rafael explains how they are automating the creation and scheduling of orchestration flows and their related transforations in a unified SQL interface. Trusted by the data teams at Fox, JetBlue, and PagerDuty, Monte Carlo solves the costly problem of broken data pipelines. Missing data?

PostgreSQL 130

PostgreSQL Data Lake Data Warehouse BI 130

Data Engineering Podcast

JANUARY 15, 2023

With a PostgreSQL-compatible interface, you can now work with real-time data using ANSI SQL including the ability to perform multi-way complex joins, which support stream-to-stream, stream-to-table, table-to-table, and more, all in standard SQL.

Coding 130

Coding Building PostgreSQL Data Lake 130

dbt Developer Hub

JULY 12, 2022

What is a SQL function? Some common SQL functions are COALESCE , LOWER , and EXTRACT. Most, if not all, modern cloud data warehouses support some type of the DATE_TRUNC function. Below, we’ll outline some of the slight differences in the implementation between some of the data warehouses.

SQL 52

SQL IT Data Warehouse BI 52

Cloudera

SEPTEMBER 9, 2018

We are proud to announce the general availability of Cloudera Altus Data Warehouse , the only cloud data warehousing service that brings the warehouse to the data. Modern data warehousing for the cloud. Modern data warehousing for the cloud. Using Cloudera Altus for your cloud data warehouse.

Data Warehouse 40

Data Warehouse Metadata Cloud Storage Cloud 40

Data Engineering Weekly

JULY 21, 2024

Focus on Needs Over Nomenclature : Define the outcomes you want from your analytics team instead of getting caught up in the semantics of terms like analytics, data science, and business intelligence. The Three C’s of Analytics : Emphasize data creation, curation, and consumption.

Data Engineering 117

Data Engineering Data Engineer Engineering Generalist 117

Hevo

JUNE 6, 2024

Amazon Redshift provides a fast, reliable, and petabyte-scale Data Warehouse solution that effectively connects to Business Intelligence tools, assisting companies in gaining insights into their customers and business operations. This […]

Data Warehouse 40

Data Warehouse Business Intelligence SQL Database 40

Data Engineering Podcast

DECEMBER 18, 2022

Push information about data freshness and quality to your business intelligence, automatically scale up and down your warehouse based on usage patterns, and let the bots answer those questions in Slack so that the humans can focus on delivering real value.

Metadata 130

Metadata Business Intelligence Data Lake BI 130

Data Engineering Podcast

OCTOBER 22, 2021

Summary The market for business intelligence has been going through an evolutionary shift in recent years. Lightdash has fully embraced that shift by building an entire open source business intelligence framework that is powered by dbt models. No more scripts, just SQL. What are the main goals of the project?

Engineering 100

Engineering Business Intelligence BI Data Warehouse 100

Data Engineering Podcast

DECEMBER 29, 2022

Push information about data freshness and quality to your business intelligence, automatically scale up and down your warehouse based on usage patterns, and let the bots answer those questions in Slack so that the humans can focus on delivering real value.

Management 130

Management Metadata Business Intelligence Data Lake 130

Advancing Analytics: Data Engineering

NOVEMBER 10, 2020

We have discussed in the past this idea of the lakehouse , the aspirational target of many analytics platforms these days of combining the huge power and potential of data lakes with the rigour, reliability and concurrency of a data warehouse. Essentially, we store data twice so that we can achieve the best of both worlds.

SQL 52

SQL BI Data Warehouse Data Lake 52

Data Engineering Podcast

APRIL 26, 2021

Summary The reason for collecting, cleaning, and organizing data is to make it usable by the organization. One of the most common and widely used methods of access is through a business intelligence dashboard. Once you sign up and create an alert in Datafold for your company data, they will send you a cool water flask.

Business Intelligence 100

Business Intelligence Data Warehouse Hadoop Data Pipeline 100

Data Engineering Weekly

MAY 26, 2024

link] Sponsored: 5/30 Google BigQuery Data Integration Tech Talk Scale data pipelines to and from BigQuery for GenAI, Business Intelligence, and Operations. It is a long standing question on people wondering In what situations should you use SQL instead of Pandas as a data scientist?

Data Engineering 76

Data Engineering Data Engineer Engineering Google Cloud 76

Data Engineering Podcast

NOVEMBER 4, 2021

Summary The precursor to widespread adoption of cloud data warehouses was the creation of customer data platforms. Acting as a centralized repository of information about how your customers interact with your organization they drove a wave of analytics about how to improve products based on actual usage data.

Data Warehouse 100

Data Warehouse Business Intelligence ETL System Data Lake 100

RandomTrees

SEPTEMBER 27, 2024

A cloud-based software as a service (SaaS) called Microsoft Fabric combines several data and analytics technologies that businesses require. Data Factory, Data Activator, Power BI, Synapse Real-Time Analytics, Synapse Data Engineering, Synapse Data Science, and Synapse Data Warehouse are some of them.

Database-centric 52

Database-centric Pipeline-centric IT BI 52

Knowledge Hut

MAY 20, 2024

The enterprise data warehouse (EDW) is the backbone of analytics and business intelligence for most large organizations and many midsize firms. The tools and techniques are proven, the SQL query language is well known, and there’s plenty of expertise available to keep EDWs humming.

Hadoop 52

Hadoop Big Data BI Business Intelligence 52

Cloudera

JUNE 18, 2022

Cloudera customers run some of the biggest data lakes on earth. These lakes power mission critical large scale data analytics, business intelligence (BI), and machine learning use cases, including enterprise data warehouses. On data warehouses and data lakes. Iterations of the lakehouse.

Data Lake 94

Data Lake Data Warehouse BI SQL 94

Edureka

JULY 16, 2024

Introduction Amazon Redshift, a cloud data warehouse service from Amazon Web Services (AWS), will directly query your structured and semi-structured data with SQL. Amazon Redshift is a petabyte-scale service that allows you to analyze all your data using SQL and your favorite business intelligence (BI) tools.

AWS 40

AWS Data Warehouse Amazon Web Services Business Intelligence 40

Data Engineering Podcast

JANUARY 1, 2022

In the same way that application performance monitoring ensures reliable software and keeps application downtime at bay, Monte Carlo solves the costly problem of broken data pipelines. Start trusting your data with Monte Carlo today! Hightouch is the easiest way to sync data into the platforms that your business teams rely on.

Data Warehouse 100

Data Warehouse SQL Hadoop Data Lake 100

Data Engineering Podcast

JUNE 11, 2021

In this episode Lak Lakshmanan enumerates the variety of services that are available for building your various data processing and analytical systems. He shares some of the common patterns for building pipelines to power business intelligence dashboards, machine learning applications, and data warehouses.

Google Cloud 100

Google Cloud Cloud Big Data Ecosystem BI 100

Knowledge Hut

DECEMBER 26, 2023

Certain roles like Data Scientists require a good knowledge of coding compared to other roles. Data Science also requires applying Machine Learning algorithms, which is why some knowledge of programming languages like Python, SQL, R, Java, or C/C++ is also required.

Data Science 97

Data Science BI Business Intelligence Machine Learning 97

Striim

SEPTEMBER 11, 2024

The approach to this processing depends on the data pipeline architecture, specifically whether it employs ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes. This method is advantageous when dealing with structured data that requires pre-processing before storage.

Data Pipeline 98

Data Pipeline Designing Data Lake Data Warehouse 98

Data Engineering Podcast

DECEMBER 19, 2021

In the same way that application performance monitoring ensures reliable software and keeps application downtime at bay, Monte Carlo solves the costly problem of broken data pipelines. Start trusting your data with Monte Carlo today! Hightouch is the easiest way to sync data into the platforms that your business teams rely on.

Systems 100

Systems Building Metadata Data Warehouse 100

Monte Carlo

FEBRUARY 15, 2023

On the surface, the promise of scaling storage and processing is readily available for databases hosted on AWS RDS, GCP cloud SQL and Azure to handle these new workloads. Cloud data warehouses solve these problems. What is a data warehouse? Let’s imagine a scenario where you’re collecting orders information.

Data Warehouse 52

Data Warehouse Unstructured Data AWS Business Intelligence 52

Data Engineering Podcast

NOVEMBER 27, 2022

Push information about data freshness and quality to your business intelligence, automatically scale up and down your warehouse based on usage patterns, and let the bots answer those questions in Slack so that the humans can focus on delivering real value.

Data Process 100

Data Process Process Metadata Business Intelligence 100

Data Engineering Podcast

DECEMBER 11, 2021

In the same way that application performance monitoring ensures reliable software and keeps application downtime at bay, Monte Carlo solves the costly problem of broken data pipelines. Start trusting your data with Monte Carlo today! Hightouch is the easiest way to sync data into the platforms that your business teams rely on.

Data Warehouse 100

Data Warehouse Raw Data Data Lake BI 100

Data Engineering Podcast

DECEMBER 4, 2021

In the same way that application performance monitoring ensures reliable software and keeps application downtime at bay, Monte Carlo solves the costly problem of broken data pipelines. Start trusting your data with Monte Carlo today! Hightouch is the easiest way to sync data into the platforms that your business teams rely on.

Data Warehouse 100

Data Warehouse Data Lake BI Data 100

Data Engineering Podcast

JUNE 19, 2022

Push information about data freshness and quality to your business intelligence, automatically scale up and down your warehouse based on usage patterns, and let the bots answer those questions in Slack so that the humans can focus on delivering real value. Can you describe what Canvas is and the story behind it?

Metadata 130

Metadata Unstructured Data MongoDB MySQL 130