phData

APRIL 29, 2024

Understanding Fivetran Fivetran is a popular Software-as-a-Service platform that enables users to automate the movement of data and ETL processes across diverse sources to a target destination. For a longer overview, along with insights and best practices, please feel free to jump back to the previous blog.

SQL 52

SQL Data Warehouse Azure Cloud Data 52

phData

MARCH 8, 2023

Fivetran is an automated data integration platform that offers a convenient solution for businesses to consolidate and sync data from disparate data sources. With over 160 data connectors available, Fivetran makes it easy to move data out of, into, and across any cloud data platform in the market.

Data Warehouse 96

Data Warehouse Data Engineering Data Engineer Data Engineering 96

Alation

JANUARY 17, 2023

Data ingestion/integration services. Reverse ETL tools. Data orchestration tools. These tools are used to manage big data, which is defined as data that is too large or complex to be processed by traditional means. How Did the Modern Data Stack Get Started? A Note on the Shift from ETL to ELT.

Data Warehouse 52

Data Warehouse ETL Tableau Cloud Data 52

phData

NOVEMBER 28, 2023

In July 2023, Matillion launched their fully SaaS platform called Data Productivity Cloud, aiming to create a future-ready, everyone-ready, and AI-ready environment that companies can easily adopt and start automating their data pipelines coding, low-coding, or even no-coding at all. Why Does it Matter?

Data Warehouse 52

Data Warehouse Data Pipeline ETL Azure 52

Precisely

APRIL 3, 2023

How can an organization enable flexible digital modernization that brings together information from multiple data sources, while still maintaining trust in the integrity of that data? To speed analytics, data scientists implemented pre-processing functions to aggregate, sort, and manage the most important elements of the data.

ETL 52

ETL Database Analytics Analytics 52

Alation

APRIL 14, 2023

Last week, the Alation team had the privilege of joining IT professionals, business leaders, and data analysts and scientists for the Modern Data Stack Conference in San Francisco. In “The modern data stack is dead, long live the modern data stack!” Cloud costs are growing prohibitive.

Data Pipeline 52

Data Pipeline Data Warehouse Cloud Data ETL 52

Precisely

JUNE 2, 2023

As companies strive to leverage AI/ML, location intelligence, and cloud analytics into their portfolio of tools, siloed mainframe data often stands in the way of forward momentum. The right data integration technology can vastly simplify things. Streaming data pipelines help to make data available and accessible in real time.

Data Silos 52

Data Silos ETL Data Quality Data Pipeline 52

phData

JANUARY 19, 2024

Matillion’s Data Productivity Cloud is a versatile platform designed to increase the productivity of data teams. It provides a unified platform for creating and managing data pipelines that are effective for both coders and non-coders. With that, you can cover most of the necessary connections.

Data Pipeline 52

Data Pipeline Data Warehouse ETL Azure 52

phData

JANUARY 5, 2023

Python has proven proficient in setting up pipelines, maintaining data flows, and transforming data with its simple syntax and proficiency in automation. Having been built completely for and in the cloud, the Snowflake Data Cloud has become an industry leader in cloud data platforms.

Python 52

Python Data Engineering Data Engineering Data Engineer 52

Smart Data Collective

OCTOBER 17, 2022

If you haven’t already, moving to the cloud can be a realistic alternative. Cloud data warehouses provide various advantages, including the ability to be more scalable and elastic than conventional warehouses. Can’t get to the data. Data pipeline maintenance.

Big Data 110

Big Data Big Data Data Engineering Data Engineer 110

Data Science Dojo

JULY 3, 2024

Big Data Technologies : Handling and processing large datasets using tools like Hadoop, Spark, and cloud platforms such as AWS and Google Cloud. Data Processing and Analysis : Techniques for data cleaning, manipulation, and analysis using libraries such as Pandas and Numpy in Python.

Data Science 195

Data Science Machine Learning Machine Learning Data Visualization 195

Alation

MARCH 22, 2022

As the latest iteration in this pursuit of high-quality data sharing, DataOps combines a range of disciplines. It synthesizes all we’ve learned about agile, data quality , and ETL/ELT. They created each capability as modules, which can either be used independently or together to build automated data pipelines.

DataOps 52

DataOps Data Pipeline Data Engineering Data Engineer 52

Precisely

MAY 23, 2024

The sudden popularity of cloud data platforms like Databricks , Snowflake , Amazon Redshift, Amazon RDS, Confluent Cloud , and Azure Synapse has accelerated the need for powerful data integration tools that can deliver large volumes of information from transactional applications to the cloud reliably, at scale, and in real time.

Data Governance 64

Data Governance ETL Data Pipeline Azure 64

Alation

APRIL 4, 2023

However, the race to the cloud has also created challenges for data users everywhere, including: Cloud migration is expensive, migrating sensitive data is risky, and navigating between on-prem sources is often confusing for users. To build effective data pipelines, they need context (or metadata) on every source.

DataOps 52

DataOps Data Engineering Data Engineer Data Engineering 52

Precisely

MAY 23, 2024

The sudden popularity of cloud data platforms like Databricks , Snowflake , Amazon Redshift, Amazon RDS, Confluent Cloud , and Azure Synapse has accelerated the need for powerful data integration tools that can deliver large volumes of information from transactional applications to the cloud reliably, at scale, and in real time.

Data Governance 52

Data Governance ETL Data Pipeline Azure 52

phData

FEBRUARY 7, 2024

The Snowflake Data Cloud is a leading cloud data platform that provides various features and services for data storage, processing, and analysis. A new feature that Snowflake offers is called Snowpark, which provides an intuitive library for querying and processing data at scale in Snowflake.

Python 52

Python ML ML SQL 52

phData

FEBRUARY 5, 2024

Replicate can interact with a wide variety of databases, data warehouses, and data lakes (on-premise or based in the cloud). Migrating Your Pipelines and Code It’s more than likely that your business has years of code being used in its data pipelines.

SQL 52

SQL Database Data Quality Data Warehouse 52

phData

FEBRUARY 14, 2023

Source data formats can only be Parquer, JSON, or Delimited Text (CSV, TSV, etc.). Streamsets Data Collector StreamSets Data Collector Engine is an easy-to-use data pipeline engine for streaming, CDC, and batch ingestion from any source to any destination.

Data Warehouse 59

Data Warehouse Azure AWS Database 59

phData

SEPTEMBER 27, 2024

If the event log is your customer’s diary, think of persistent staging as their scrapbook – a place where raw customer data is collected, organized, and kept for future reference. In traditional ETL (Extract, Transform, Load) processes in CDPs, staging areas were often temporary holding pens for data.

Data Models 52

Data Models Data Modeling Apache Kafka Data Lakes 52

Dataversity

MARCH 12, 2024

While we haven’t built technology that enables real-time matter transfer yet, modern science is pursuing concepts like superposition and quantum teleportation to facilitate information transfer across any distance […] The post 10 Advantages of Real-Time Data Streaming in Commerce appeared first on DATAVERSITY.

Data Pipeline 59

Data Pipeline ETL Cloud Data Analytics 59

IBM Journey to AI blog

JULY 17, 2023

The next generation of Db2 Warehouse SaaS and Netezza SaaS on AWS fully support open formats such as Parquet and Iceberg table format, enabling the seamless combination and sharing of data in watsonx.data without the need for duplication or additional ETL. Savings may vary depending on configurations, workloads and vendor.

AI 75

AI AI Machine Learning Machine Learning 75

phData

OCTOBER 28, 2024

Modern low-code/no-code ETL tools allow data engineers and analysts to build pipelines seamlessly using a drag-and-drop and configure approach with minimal coding. One such option is the availability of Python Components in Matillion ETL, which allows us to run Python code inside the Matillion instance.

Python 52

Python ETL AWS Database 52

Dataversity

APRIL 1, 2021

In the data-driven world we live in today, the field of analytics has become increasingly important to remain competitive in business. In fact, a study by McKinsey Global Institute shows that data-driven organizations are 23 times more likely to outperform competitors in customer acquisition and nine times […].

Analytics 69

Analytics Analytics Data Silos Data Lakes 69

phData

OCTOBER 17, 2023

The story is all too common – a business user requests some data, the data team creates/prioritizes a ticket, and said ticket is completed after some number of months (or weeks if you’re lucky) – just to have the data be wrong, and the whole process starts again. Those are scary for data teams to change.

ETL 52

ETL Data Pipeline Data Engineering Data Engineer 52

phData

NOVEMBER 9, 2023

Snowflake’s Data Cloud has emerged as a leader in cloud data warehousing. As a fundamental piece of the modern data stack , Snowflake is helping thousands of businesses store, transform, and derive insights from their data easier, faster, and more efficiently than ever before.

Data Warehouse 98

Data Warehouse Data Lakes Clustering Cloud Data 98

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. This typically results in long-running ETL pipelines that cause decisions to be made on stale or old data.

Data Warehouse 52

Data Warehouse Analytics Analytics SQL 52