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

Dataconomy

SEPTEMBER 4, 2023

Cloud-based business intelligence (BI): Cloud-based BI tools enable organizations to access and analyze data from cloud-based sources and on-premises databases. These tools offer the flexibility of accessing insights from anywhere, and they often integrate with other cloud analytics solutions.

Analytics 203

Analytics Analytics Big Data Analytics Big Data Analytics 203

Data Science Blog

FEBRUARY 4, 2023

The fusion of data in a central platform enables smooth analysis to optimize processes and increase business efficiency in the world of Industry 4.0 using methods from business intelligence , process mining and data science. Cloud Data Platform for shopfloor management and data sources such like MES, ERP, PLM and machine data.

Cloud Data 147

Cloud Data Data Science Business Intelligence Business Intelligence 147

Data Science Blog

SEPTEMBER 19, 2023

By automating the provisioning and management of cloud resources through code, IaC brings a host of advantages to the development and maintenance of Data Warehouse Systems in the cloud. So why using IaC for Cloud Data Infrastructures? apply(([serverName, rgName, dbName]) => { return `Server=tcp:${serverName}.database.windows.net;initial

Data Warehouse 259

Data Warehouse Azure SQL Database 259

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

Towards AI

JANUARY 28, 2024

To start, get to know some key terms from the demo: Snowflake: The centralized source of truth for our initial data Magic ETL: Domo’s tool for combining and preparing data tables ERP: A supplemental data source from Salesforce Geographic: A supplemental data source (i.e., Instagram) used in the demo Why Snowflake?

ETL 111

ETL Python Database Data Preparation 111

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 Cloud Data Tableau 52

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

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. And it injects mature process control techniques from the world of traditional engineering.

DataOps 52

DataOps Data Pipeline Data Engineering Data Engineer 52

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

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

phData

FEBRUARY 5, 2024

Creating the databases, schemas, roles, and access grants that comprise a data system information architecture can be time-consuming and error-prone. Luckily phData has created a template-driven Provision Tool that automates onboarding users and projects to Snowflake, allowing your data teams to start producing real value immediately.

SQL 52

SQL Database Data Quality Data Warehouse 52

Data Science Blog

JUNE 27, 2023

For existing event sources, listeners are utilized to stream writes directly from database logs or similar data stores. By treating every data point as a streaming event, the Kappa architecture enables the ability to near-realtime analytics and observe the state of all data in the organization at any given point.

Big Data 130

Big Data Big Data Apache Kafka Database 130

Mlearning.ai

JULY 10, 2023

In my 7 years of Data Science journey, I’ve been exposed to a number of different databases including but not limited to Oracle Database, MS SQL, MySQL, EDW, and Apache Hadoop. It will automatically scale queries to handle any size data set, so you can focus on analyzing your data.

SQL 52

SQL Database Apache Hadoop Data Science 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

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

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 Engineer Data Engineering 52

phData

JANUARY 4, 2023

With Snowflake, organizations can be data consumers, data providers, or both. Complete SQL Database No need to learn new tools as Snowflake supports the tools millions of business users already know how to use today.

Data Warehouse 52

Data Warehouse SQL Database ETL 52

Flipboard

DECEMBER 18, 2023

Amazon Redshift powers data-driven decisions for tens of thousands of customers every day with a fully managed, AI-powered cloud data warehouse, delivering the best price-performance for your analytics workloads. Learn more about the AWS zero-ETL future with newly launched AWS databases integrations with Amazon Redshift.

AWS 112

AWS Data Warehouse ETL SQL 112

IBM Journey to AI blog

JULY 17, 2023

Through workload optimization across multiple query engines and storage tiers, organizations can reduce data warehouse costs by up to 50 percent. 1 Watsonx.data offers built-in governance and automation to get to trusted insights within minutes, and integrations with existing databases and tools to simplify setup and user experience.

AI 68

AI AI Machine Learning Machine Learning 68

Alation

OCTOBER 19, 2021

Reduced User Experience : As previously mentioned, data silos can lead to problems down the road. Applications may draw data from different databases, sometimes in different formats. Keeping data siloed also makes adopting new technologies more difficult.

Data Silos 52

Data Silos ETL Data Governance Data Quality 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 SQL Cloud Data Analytics 52

phData

APRIL 20, 2023

Hashed PKs were introduced as a means of eliminating the bottleneck encountered by most database sequence generators, making this DV pattern ideal for customers prioritizing data loading performance and using data warehouse automation tools. By combining the Snowflake Data Cloud with a Data Vault 2.0

Data Warehouse 72

Data Warehouse Data Governance Clustering Database 72