Combining Different Sources

How can we identify all unique customers across online and in-store channels?

Advanced⏱ 3 Minutes⭐ 1790 XP

🤔 THE QUESTION

How can we identify all unique customers across online and in-store channels?

💡 WHAT IS IT?

UNION across disparate transactional tables generates a unified unique customer identifier pool.

🎯 WHAT IS IT USED FOR?

Omnichannel customer unification, master data management, total customer base sizing.

💻 EXAMPLE

SELECT customer_id
FROM online_orders
UNION
SELECT customer_id
FROM store_orders;

Practice typing production-grade SQL code for Combining Different Sources.