phData

OCTOBER 9, 2023

As organizations embrace the benefits of data vault, it becomes crucial to ensure optimal performance in the underlying data platform. One such platform that has revolutionized cloud data warehousing is the Snowflake Data Cloud. However, joining tables using a hash key can take longer than a sequential key.

ETL 69

ETL Clustering Data Warehouse SQL 69

phData

SEPTEMBER 2, 2024

In this blog, we will cover the best practices for developing jobs in Matillion, an ETL/ELT tool built specifically for cloud database platforms. The blog will be divided into three broad sections: Design, SDLC, and Security, each with its best practices. What Are Matillion Jobs and Why Do They Matter?

ETL 52

ETL Data Warehouse SQL Database 52

phData

MARCH 8, 2023

Fivetran, a cloud-based automated data integration platform, has emerged as a leading choice among businesses looking for an easy and cost-effective way to unify their data from various sources. It allows organizations to easily connect their disparate data sources without having to manage any infrastructure.

Data Warehouse 96

Data Warehouse Data Engineering Data Engineering Data Engineering 96

phData

APRIL 29, 2024

In our previous blog, Top 5 Fivetran Connectors for Financial Services , we explored Fivetran’s capabilities that address the data integration needs of the finance industry. Now, let’s cover the healthcare industry, which also has a surging demand for data and analytics, along with the underlying processes to make it happen.

SQL 52

SQL Data Warehouse Azure Cloud Data 52

phData

JUNE 6, 2024

Marketing and business professionals must effectively manage and leverage their customer data to stay competitive. In this blog, we will explore how marketing professionals have approached the challenge of effectively using their vast amount of customer data using Composable CDPs. Why use Fivetran for Composable CDP?

Data Warehouse 52

Data Warehouse Cloud Data ETL Data Modeling 52

Data Science Blog

JUNE 27, 2023

It offers the advantage of having a single ETL platform to develop and maintain. It is well-suited for developing data systems that emphasize online learning and do not require a separate batch layer. Its focus on unique, ongoing events allows for effective and responsive data processing. appeared first on Data Science Blog.

Big Data 130

Big Data Big Data Apache Kafka Database 130

phData

JULY 17, 2023

Over the past few decades, the corporate data landscape has changed significantly. The shift from on-premise databases and spreadsheets to the modern era of cloud data warehouses and AI/ LLMs has transformed what businesses can do with data. This is where Fivetran and the Modern Data Stack come in.

Data Warehouse 52

Data Warehouse Data Pipeline Cloud Data ETL 52

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

Data Science Dojo

JULY 3, 2024

In this blog, we will explore the arena of data science bootcamps and lay down a guide for you to choose the best data science bootcamp. What do Data Science Bootcamps Offer? Big Data Technologies : Handling and processing large datasets using tools like Hadoop, Spark, and cloud platforms such as AWS and Google Cloud.

Data Science 150

Data Science Machine Learning Machine Learning Data Visualization 150

phData

SEPTEMBER 27, 2024

Using cloud data services can be nerve-wracking for some companies. Yes, it’s cheaper, faster, and more efficient than keeping your data on-premises, but you’re at the provider’s mercy regarding your available data. Query Resiliency Snowflake uses virtual warehouses for compute execution in one availability zone.

Cloud Data 52

Cloud Data Database ETL Data Visualization 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. Practitioners and hands-on data users were thrilled to be there, and many connected as they shared their progress on their own data stack journeys.

Data Pipeline 52

Data Pipeline Data Warehouse Cloud Data ETL 52

AWS Machine Learning Blog

AUGUST 4, 2023

As a result, businesses can accelerate time to market while maintaining data integrity and security, and reduce the operational burden of moving data from one location to another. With Einstein Studio, a gateway to AI tools on the data platform, admins and data scientists can effortlessly create models with a few clicks or using code.

AWS 84

AWS ML ML AI 84

phData

JANUARY 4, 2023

The Snowflake Data Cloud is a modern data warehouse that allows companies to take advantage of its cloud-based architecture to improve efficiencies while at the same time reducing costs. In this blog post, we will explore the reasons why many organizations are choosing to migrate from Netezza to Snowflake.

Data Warehouse 52

Data Warehouse SQL Database ETL 52

phData

NOVEMBER 28, 2023

In this blog, we will show you how easy it is to get your Data Productivity Cloud environment up and running and how you can start your studies on the platform. What is Matillion Data Productivity Cloud? Suppose this is not your first time using Matillion products; you are already familiar with Matillion ETL.

Data Warehouse 52

Data Warehouse Data Pipeline ETL Azure 52

IBM Journey to AI blog

JULY 17, 2023

In this blog, I will cover: What is watsonx.ai? sales conversation summaries, insurance coverage, meeting transcripts, contract information) Generate: Generate text content for a specific purpose, such as marketing campaigns, job descriptions, blogs or articles, and email drafting support. What capabilities are included in watsonx.ai?

AI 74

AI AI Machine Learning Machine Learning 74

phData

NOVEMBER 30, 2023

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 the ability to create alerts based on data in Snowflake. How does CRON work for scheduling alerts?

SQL 52

SQL Cloud Data Database ETL 52

phData

SEPTEMBER 4, 2024

ThoughtSpot offers AI-powered and lightning-fast analytics, a user-friendly semantic engine that is easy to learn, and the ability to empower users across any organization to quickly search and answer data questions. ThoughtSpot was designed to be low-code and easy for anyone to use across a business to generate insights and explore data.

Analytics 52

Analytics Analytics SQL ETL 52

phData

FEBRUARY 14, 2023

This may result in data inconsistency when UPDATE and DELETE operations are performed on the target database. For simple and quick replication to Snowflake, Matillion offers Data Loader, a SaaS tool that migrates data from various data sources. Replication of calculated values is not supported during Change Processing.

Data Warehouse 59

Data Warehouse Azure AWS Database 59

Alation

OCTOBER 27, 2022

Few actors in the modern data stack have inspired the enthusiasm and fervent support as dbt. This data transformation tool enables data analysts and engineers to transform, test and document data in the cloud data warehouse. Curious to learn how the data catalog can power your data strategy?

Data Analyst 52

Data Analyst Data Scientist Analytics Analytics 52

Dataversity

SEPTEMBER 6, 2021

The rush to become data-driven is more heated, important, and pronounced than it has ever been. Businesses understand that if they continue to lead by guesswork and gut feeling, they’ll fall behind organizations that have come to recognize and utilize the power and potential of data. Click to learn more about author Mike Potter.

Data Warehouse 98

Data Warehouse Data Lakes ETL Cloud Data 98

phData

JUNE 14, 2023

In recent years, data engineering teams working with the Snowflake Data Cloud platform have embraced the continuous integration/continuous delivery (CI/CD) software development process to develop data products and manage ETL/ELT workloads more efficiently.

Data Pipeline 52

Data Pipeline Database SQL Data Engineering 52

Alation

APRIL 4, 2023

This expanded connector to Databricks Unity Catalog does just that, delivering to joint customers a comprehensive view of all cloud data. New Connectivity for dbt Modern data engineers confront complex, challenging data environments and need to empower data users for self-service. Now with this new 2023.1

DataOps 52

DataOps Data Engineering Data Engineering Data Engineering 52

Alation

JANUARY 25, 2022

Data fabric is now on the minds of most data management leaders. In our previous blog, Data Mesh vs. Data Fabric: A Love Story , we defined data fabric and outlined its uses and motivations. The data catalog is a foundational layer of the data fabric. Subscribe to Alation's Blog.

DataOps 52

DataOps SQL ML ML 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

In this blog, we’re going to answer these questions and more. Walking you through the biggest challenges we have found when migrating our customer’s data from a legacy system to Snowflake. You’re in luck because this blog is for anyone ready to move or thinking about moving to Snowflake who wants to know what’s in store for them.

SQL 52

SQL Database Data Quality Data Warehouse 52

phData

JULY 10, 2024

These tools allow users to handle more advanced data tasks and analyses. In this blog, we’ll explain why custom SQL and CSVs are important, demonstrate how to use these features in Sigma Computing, and provide some best practices to help you get started. Mastering custom SQL and CSVs in Sigma is essential for several reasons.

SQL 52

SQL Data Warehouse Analytics Analytics 52

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. With Accenture, teams can avoid the costly investment of integrating a broad array of cloud services. Subscribe to Alation's Blog.

DataOps 52

DataOps Data Pipeline Data Engineering Data Engineer 52

phData

JANUARY 19, 2024

Matillion is also built for scalability and future data demands, with support for cloud data platforms such as Snowflake Data Cloud , Databricks, Amazon Redshift, Microsoft Azure Synapse, and Google BigQuery, making it future-ready, everyone-ready, and AI-ready.

Data Pipeline 52

Data Pipeline Data Warehouse ETL Azure 52

Dataversity

APRIL 8, 2021

Business intelligence (BI) tools transform the unprocessed data into meaningful and actionable insight. BI tools analyze the data and convert them […]. Click to learn more about author Piyush Goel. What is a BI tool? Which BI tool is best for your organization?

Business Intelligence 75

Business Intelligence Business Intelligence ETL Data Quality 75

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

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

Dataversity

JUNE 7, 2022

Unlocking value from data is a journey. It involves investing in data infrastructure, analysts, scientists, and processes for managing data consumption. Even when data operations teams progress along this journey, growing pains crop up as more users want more data. You don’t have to grin […].

ETL 52

ETL Data Governance Data Quality Cloud Data 52

Dataversity

MARCH 17, 2021

I do not think it is an exaggeration to say data analytics has come into its own over the past decade or so. What started out as an attempt to extract business insights from transactional data in the ’90s and early 2000s has now transformed into an […]. The post Is Lakehouse Architecture a Grand Unification in Data Analytics?

Analytics 52

Analytics Analytics Data Lakes Data Warehouse 52

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

phData

NOVEMBER 9, 2023

This blog was originally written by Keith Smith and updated for 2024 by Justin Delisi. Snowflake’s Data Cloud has emerged as a leader in cloud data warehousing. In 2022, the term data mesh has started to become increasingly popular among Snowflake and the broader industry. What is a Cloud Data Warehouse?

Data Warehouse 98

Data Warehouse Data Lakes Clustering Cloud Data 98

phData

OCTOBER 17, 2023

In our previous blog , we discussed how Fivetran and dbt scale for any data volume and workload, both small and large. Now, you might be wondering what these tools can do for your data team and the efficiency of your organization as a whole. Can these tools help reduce the time our data engineers spend fixing things?

ETL 52

ETL Data Pipeline Data Engineering Data Engineer 52

phData

APRIL 20, 2023

In today’s world, data-driven applications demand more flexibility, scalability, and auditability, which traditional data warehouses and modeling approaches lack. This is where the Snowflake Data Cloud and data vault modeling comes in handy. By combining the Snowflake Data Cloud with a Data Vault 2.0

Data Warehouse 72

Data Warehouse Data Governance Clustering Database 72