ODSC - Open Data Science

APRIL 3, 2023

Data Wrangling: Data Quality, ETL, Databases, Big Data The modern data analyst is expected to be able to source and retrieve their own data for analysis. Competence in data quality, databases, and ETL (Extract, Transform, Load) are essential. SQL excels with big data and statistics, making it important in order to query databases.

Analytics 52

Analytics Analytics Data Analyst Data Science 52

phData

MARCH 1, 2024

As you can see in the above demo, it is incredibly simple to use INFER_SCHEMA and SCHEMA EVOLUTION features to speed up data ingestion into Snowflake. There’s no need for developers or analysts to manually adjust table schemas or modify ETL (Extract, Transform, Load) processes whenever the source data structure changes.

Data Engineering 52

Data Engineering Data Engineering Data Engineering Data Engineer 52

Alation

FEBRUARY 7, 2023

There was a software product demo showcasing its ability to scan every layer of your application code, and I was intrigued to see how it worked. The developers spent time looking for a tool that could scan all the SQL code and Microsoft SSIS packages because that was the ETL tool being used.

Data Warehouse 52

Data Warehouse ETL Business Intelligence SQL 52

phData

AUGUST 22, 2024

Snowflake Cortex stood out as the ideal choice for powering the model due to its direct access to data, intuitive functionality, and exceptional performance in handling SQL tasks. I used a demo project that I frequently work with and introduced syntax errors and data quality problems.

SQL 52

SQL Data Quality Python Data Warehouse 52

The MLOps Blog

OCTOBER 20, 2023

Example template for an exploratory notebook | Source: Author How to organize code in Jupyter notebook For exploratory tasks, the code to produce SQL queries, pandas data wrangling, or create plots is not important for readers. In those cases, most of the data exploration and wrangling will be done through SQL. documentation.

SQL 52

SQL Database Data Scientist Python 52

Pickl AI

APRIL 26, 2024

It covers essential topics such as SQL queries, data visualization, statistical analysis, machine learning concepts, and data manipulation techniques. Key Takeaways SQL Mastery: Understand SQL’s importance, join tables, and distinguish between SELECT and SELECT DISTINCT. How do you join tables in SQL?

Data Analyst 52

Data Analyst Data Analysis Data Analysis Machine Learning 52

DataRobot

JUNE 4, 2021

Powered by Snowflake’s data-sharing technology, data from the Snowflake Data Marketplace allows users to query data instantaneously without additional ETL processing steps. Request a Demo. The process is simple, and if you have a Snowflake account, getting data from the Snowflake Data Marketplace involves only a few clicks.

Machine Learning 52

Machine Learning Machine Learning Algorithm ETL 52

phData

NOVEMBER 30, 2023

For example, you can use alerts to send notifications, capture data, or execute SQL commands when certain events or thresholds are reached in your data. We can then give you a demo, learn more about your monitoring needs, and help you to deploy or customize a solution for your organization.

SQL 52

SQL Cloud Data Database ETL 52

AWS Machine Learning Blog

FEBRUARY 18, 2025

The assistant is connected to internal and external systems, with the capability to query various sources such as SQL databases, Amazon CloudWatch logs, and third-party tools to check the live system health status. Creating ETL pipelines to transform log data Preparing your data to provide quality results is the first step in an AI project.

AWS 71

AWS Database AI AI 71