YouTube Channel ID format
24-digit unique ID which is mixed of numbers and CaSe SeNsItive letters and started with 'UC'.
How to find YouTube channel related to music
1. youtube_channel.official_artist
2. Find YouTube channel based on YouTube for Artist
SELECT *
FROM youtube_artist ya
JOIN cm_url cu ON cu.target = 'cm_artist' AND cu.target_id = ya.cm_artist::TEXT AND cu.type=3
JOIN youtube_channel yc ON yc.id = cu.account_id;
3. End with specific strings like,
- 'VEVO'
- 'Official'
- ' - Topic'
A topic channel is where your art tracks are housed on YouTube. Typically, they are titled 'Artist Name - Topic', where 'Artist Name' is your artist name. For example razz mattreezy - Topic.
A topic channel is automatically generated by YouTube, and can't be customized, nor does it have a log-in function to it.
https://www.emubands.com/faqs/what-is-a-topic-channel-on-youtube/#:~:text=A%20topic%20channel%20is%20where,log%2Din%20function%20to%20it
What is a Topic Channel on YouTube? - EmuBands
A topic channel is where your art tracks are housed on YouTube. Typically, they are titled ‘Artist Name – Topic’, where ‘Artist Name’ is your artist name. For example razz mattreezy – Topic. A topic channel is automatically generated by YouTube
www.emubands.com
YouTube channel URL format
1. {*.youtube.com}/channel/{24-digit CaSe SeNsItive channel id}
2. {*.youtube.com}/c/{user's custom URL name}
3. {*.youtube.com}/{user's custom URL name}
4. {*.youtube.com}/{username}
⚠️ username in case 4 is different with user's custom URL name in case 2,3
💡Official answer from YouTube : https://support.google.com/youtube/answer/6180214?hl=en
Understand your YouTube channel's URLs - YouTube Help
Your channel can have more than one URL that directs your audience to your channel homepage. These URLs can look different from one another, but each URL can point your audience to the same place - your channel. Handle URLs, custom URLs, and legacy usernam
support.google.com
For example,
all these 3 urls below are URL linked to same channel, Vogue
https://www.youtube.com/vogue
https://www.youtube.com/c/vogue
https://www.youtube.com/channel/UCRXiA3h1no_PFkb1JCP0yMA
This URL below is different URL linked to the channel, British Vogue
https://www.youtube.com/user/vogue
'Data Engineering' 카테고리의 다른 글
| [Youtube Data API v3] 2. How to get API Keys? (0) | 2025.07.07 |
|---|---|
| [Youtube Data API v3] 1. How to monitor API Key Error? (0) | 2025.07.07 |
| Tech Stack I use daily as a Data Engineer (1) | 2025.07.03 |
| Airflow 101: Building Your First Workflow (3) | 2025.06.26 |
| [SQLD 자격검정 실전문제] Part 2-1. 90번 SQL 완성하기 (0) | 2025.06.19 |