SERGE AURUBIN

DATA SCIENTIST

Welcome to my blog for everything having to do with data science and analysis. I am always looking for new opportunities to drive business insight using data analysis.

Data & Analytics

Data Analysis
Power BI
Excel
Data Pipelines
Matillion

Engineering

Software Developer
Python
PHP
ReactJS
Flutter
Front End Dev
Back End Dev

Databases

MySQL Dev/DBA
Oracle DBA

Cloud & AI

Amazon Web Services
Docker
Kubernetes
Git
Artificial Intelligence
Claude
OpenAI

Back to Videos

Snowflake ASOF JOIN in 7 Minutes | New SQL JOIN

techTFQ

December 11, 2025 1

0 Watch on YouTube

Learn how to use Snowflake’s ASOF JOIN with a real-world stock market scenario using TRADES and QUOTES tables. You will see why normal joins fail with time-series data, and how ASOF JOIN helps you match each trade to the most recent market price at or before the trade time. This video walks through the problem statement, table design, sample data, and a clear ASOF JOIN query you can reuse in your own projects.

Check out SQLNest ????
https://sqlnest.com/

Thanks for Watching!

0 Comments

No comments yet. Be the first to weigh in.