Repository: mindsdb/mindsdb
Pull request: youtube documentation update
## Description

Documentation update to reflect the YouTube handler Readme.md. I assume that the read me is up to date.

Fixes #8667 

## Type of change
- [ x ] 📄 This change requires a documentation update

## Checklist:

- [ x ] My code follows the style guidelines(PEP 8) of MindsDB.
- [ x ] I have appropriately commented on my code, especially in complex areas.
- [ x ] Necessary documentation updates are either made or tracked in issues.
- [ x ] Relevant unit and integration tests are updated or added.





Problem statement:
[Docs]: Update the Documentation for the YouTube Integration
### Short description of what should be added or improved

The documentation for the YouTube handler needs to be updated in line with the recent updates that have been made, especially the use of OAuth for authentication.

### Video or screenshots

_No response_

### Anything else?

_No response_

Hints from issue discussion:

Commit message: youtube documentation update

Patch to review:
diff --git a/docs/integrations/app-integrations/youtube.mdx b/docs/integrations/app-integrations/youtube.mdx
index b9eea5e8e4f..4cda7bb8804 100644
--- a/docs/integrations/app-integrations/youtube.mdx
+++ b/docs/integrations/app-integrations/youtube.mdx
@@ -5,66 +5,79 @@ sidebarTitle: YouTube
 
 In this section, we present how to connect YouTube to MindsDB.
 
-[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users can upload, view, share, and interact with videos created by individuals and organizations from around the world.
+[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users
+can upload, view, share, and interact with videos created by individuals and organizations from around the world.
 
-Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments, detect sentiment of comments, or use AI models to create replies.
+Comment Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments,
+detect sentiment of comments, or use AI models to create replies.
 
-## Connection
+## Install the Handler
+
+First, we have to install the required python packages.
+```bash
+pip install mindsdb[YouTube]
+```
+
+## Connecting
 
 This handler is implemented using the `google-api-python-client` library, a Python library that from where we can use YouTube v3 API.
 
 The only required argument to establish a connection are as follows:
 
-* `youtube_api_token` which is a Google API key used for authentication.
+* `YouTube_api_token` which is a Google API key used for authentication.
 
 <Tip>
-Check out [this guide](https://blog.hubspot.com/website/how-to-get-youtube-api-key) on how to create the API key in order to access YouTube data.
+Check out [this guide](https://blog.hubspot.com/website/how-to-get-YouTube-api-key) on how to create the API key in order to access YouTube data.
 </Tip>
 
 The first step is to create a database with the new `Youtube` engine using the following command:
 
 ```sql
 CREATE DATABASE mindsdb_youtube
-WITH ENGINE = 'youtube',
+WITH ENGINE = 'YouTube',
 PARAMETERS = {
-  "youtube_api_token": "<your-youtube-api-key-token>"  
+  "YouTube_api_token": "<your-YouTube-api-key-token>"  
 };
 ```
 
 <Tip>
-If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler's folder (mindsdb/integrations/handlers/youtube_handler) and run this command: `pip install -r requirements.txt`.
+If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the
+    handler's folder `mindsdb/integrations/handlers/YouTube_handler` and run this command: `pip install -r requirements.txt`.
 </Tip>
 
 ## Usage
 
-Use the established connection to query the `get_comments` table for any YouTube Video of your choice.
-
-```sql
-SELECT * FROM mindsdb_youtube.get_comments
-WHERE youtube_video_id = "raWFGQ20OfA";
-```
+Use the established connection to query the comments table
 
+~~~~sql
+SELECT * FROM mindsdb_youtube.comments
+WHERE video_id = "raWFGQ20OfA";
+~~~~
 
-Advanced queries which are supported
+Advanced queries for the YouTube handler
 
-```sql
-SELECT * FROM mindsdb_youtube.get_comments
-WHERE youtube_video_id = "raWFGQ20OfA"
+~~~~sql
+SELECT * FROM mindsdb_youtube.comments
+WHERE video_id = "raWFGQ20OfA"
 ORDER BY display_name ASC
 LIMIT 5;
-```
+~~~~
 
+Given a channel_id, get information about the channel
 
-Get information about any youtube video using video_id:
-```sql
+~~~~sql
+SELECT * FROM mindsdb_youtube.channels
+WHERE channel_id="UC-...";
+~~~~
+
+Here, `channel_id` column is mandatory in the where clause.
+
+Get information about any YouTube video using video_id:
+
+~~~~sql
 SELECT * FROM mindsdb_youtube.videos
 WHERE video_id="id";
-```
+~~~~
 
+`video_id` is a mandatory column in the where clause.
 
-Given a channel_id, get information about the channel:
-
-```sql
-SELECT * FROM mindsdb_youtube.channels
-WHERE channel_id="UC-...";
-```
diff --git a/mindsdb/integrations/handlers/youtube_handler/README.md b/mindsdb/integrations/handlers/youtube_handler/README.md
index 16bb479d465..7122b3efab7 100644
--- a/mindsdb/integrations/handlers/youtube_handler/README.md
+++ b/mindsdb/integrations/handlers/youtube_handler/README.md
@@ -3,7 +3,7 @@
 Youtube handler for MindsDB provides interfaces to connect with Youtube via APIs and pull the video comments of the particular video.
 
 ## Youtube
-Youtube is app that needs no introduction. It provides a great distribution for all business and creators and It opens-up a great opportunity to do NLP on youtube comments
+Youtube is a social video sharing platform businesses and creators.  MindsDB users can deploy the youtube integration to perform NLP on youtube comments.
 
 ## Youtube Handler Initialization
 
@@ -11,7 +11,8 @@ The Youtube handler is initialized with the following parameters:
 
 - `youtube_api_token`: Youtube API key to use for authentication 
 
-Please follow this (link)[https://blog.hubspot.com/website/how-to-get-youtube-api-key] to generate the token for accessing strava API
+Please follow this (link)[https://blog.hubspot.com/website/how-to-get-youtube-api-key] to generate the token for 
+accessing youtube API
 
 ## Implemented Features
 
@@ -52,6 +53,7 @@ SELECT * FROM mindsdb_youtube.comments
 WHERE video_id = "raWFGQ20OfA"
 ORDER BY display_name ASC
 LIMIT 5;
+~~~~
 
 Given a channel_id, get information about the channel
 


Code review comments:
diff_hunk: @@ -5,66 +5,79 @@ sidebarTitle: YouTube
 
 In this section, we present how to connect YouTube to MindsDB.
 
-[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users can upload, view, share, and interact with videos created by individuals and organizations from around the world.
+[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users
+can upload, view, share, and interact with videos created by individuals and organizations from around the world.
 
-Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments, detect sentiment of comments, or use AI models to create replies.
+Comment Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments,
+detect sentiment of comments, or use AI models to create replies.
 
-## Connection
+## Install the Handler
path: docs/integrations/app-integrations/youtube.mdx
text: @user1:
Throughout the app integration docs, we use sections "Connection" and "Usage".  Let's keep it consistent.
So let's change it back to Connection.

diff_hunk: @@ -5,66 +5,79 @@ sidebarTitle: YouTube
 
 In this section, we present how to connect YouTube to MindsDB.
 
-[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users can upload, view, share, and interact with videos created by individuals and organizations from around the world.
+[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users
+can upload, view, share, and interact with videos created by individuals and organizations from around the world.
 
-Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments, detect sentiment of comments, or use AI models to create replies.
+Comment Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments,
+detect sentiment of comments, or use AI models to create replies.
 
-## Connection
+## Install the Handler
+
+First, we have to install the required python packages.
+```bash
+pip install mindsdb[YouTube]
+```
+
+## Connecting
 
 This handler is implemented using the `google-api-python-client` library, a Python library that from where we can use YouTube v3 API.
 
 The only required argument to establish a connection are as follows:
 
-* `youtube_api_token` which is a Google API key used for authentication.
+* `YouTube_api_token` which is a Google API key used for authentication.
 
 <Tip>
-Check out [this guide](https://blog.hubspot.com/website/how-to-get-youtube-api-key) on how to create the API key in order to access YouTube data.
+Check out [this guide](https://blog.hubspot.com/website/how-to-get-YouTube-api-key) on how to create the API key in order to access YouTube data.
 </Tip>
 
 The first step is to create a database with the new `Youtube` engine using the following command:
 
 ```sql
 CREATE DATABASE mindsdb_youtube
-WITH ENGINE = 'youtube',
+WITH ENGINE = 'YouTube',
 PARAMETERS = {
-  "youtube_api_token": "<your-youtube-api-key-token>"  
+  "YouTube_api_token": "<your-YouTube-api-key-token>"  
path: docs/integrations/app-integrations/youtube.mdx
text: @user1:
Same as above - this should be `youtube_api_token`.

diff_hunk: @@ -5,66 +5,79 @@ sidebarTitle: YouTube
 
 In this section, we present how to connect YouTube to MindsDB.
 
-[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users can upload, view, share, and interact with videos created by individuals and organizations from around the world.
+[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users
+can upload, view, share, and interact with videos created by individuals and organizations from around the world.
 
-Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments, detect sentiment of comments, or use AI models to create replies.
+Comment Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments,
+detect sentiment of comments, or use AI models to create replies.
 
-## Connection
+## Install the Handler
+
+First, we have to install the required python packages.
+```bash
+pip install mindsdb[YouTube]
+```
+
+## Connecting
 
 This handler is implemented using the `google-api-python-client` library, a Python library that from where we can use YouTube v3 API.
 
 The only required argument to establish a connection are as follows:
 
-* `youtube_api_token` which is a Google API key used for authentication.
+* `YouTube_api_token` which is a Google API key used for authentication.
 
 <Tip>
-Check out [this guide](https://blog.hubspot.com/website/how-to-get-youtube-api-key) on how to create the API key in order to access YouTube data.
+Check out [this guide](https://blog.hubspot.com/website/how-to-get-YouTube-api-key) on how to create the API key in order to access YouTube data.
 </Tip>
 
 The first step is to create a database with the new `Youtube` engine using the following command:
 
 ```sql
 CREATE DATABASE mindsdb_youtube
-WITH ENGINE = 'youtube',
+WITH ENGINE = 'YouTube',
path: docs/integrations/app-integrations/youtube.mdx
text: @user1:
Same as above - this should be `youtube`.

diff_hunk: @@ -5,66 +5,79 @@ sidebarTitle: YouTube
 
 In this section, we present how to connect YouTube to MindsDB.
 
-[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users can upload, view, share, and interact with videos created by individuals and organizations from around the world.
+[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users
+can upload, view, share, and interact with videos created by individuals and organizations from around the world.
 
-Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments, detect sentiment of comments, or use AI models to create replies.
+Comment Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments,
+detect sentiment of comments, or use AI models to create replies.
 
-## Connection
+## Install the Handler
+
+First, we have to install the required python packages.
+```bash
+pip install mindsdb[YouTube]
+```
+
+## Connecting
 
 This handler is implemented using the `google-api-python-client` library, a Python library that from where we can use YouTube v3 API.
 
 The only required argument to establish a connection are as follows:
 
-* `youtube_api_token` which is a Google API key used for authentication.
+* `YouTube_api_token` which is a Google API key used for authentication.
path: docs/integrations/app-integrations/youtube.mdx
text: @user1:
All parameter names and engine names, we keep in lower-case.

In fact, when you use `YouTube_api_token`, it will result in an error when connecting yt to mindsdb.

diff_hunk: @@ -5,66 +5,79 @@ sidebarTitle: YouTube
 
 In this section, we present how to connect YouTube to MindsDB.
 
-[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users can upload, view, share, and interact with videos created by individuals and organizations from around the world.
+[YouTube](https://www.youtube.com/) is a popular online video-sharing platform and social media website where users
+can upload, view, share, and interact with videos created by individuals and organizations from around the world.
 
-Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments, detect sentiment of comments, or use AI models to create replies.
+Comment Data from YouTube can be utilized within MindsDB to train AI models and chatbots based on user comments,
+detect sentiment of comments, or use AI models to create replies.
 
-## Connection
+## Install the Handler
+
+First, we have to install the required python packages.
+```bash
+pip install mindsdb[YouTube]
+```
+
+## Connecting
 
 This handler is implemented using the `google-api-python-client` library, a Python library that from where we can use YouTube v3 API.
 
 The only required argument to establish a connection are as follows:
 
-* `youtube_api_token` which is a Google API key used for authentication.
+* `YouTube_api_token` which is a Google API key used for authentication.
 
 <Tip>
-Check out [this guide](https://blog.hubspot.com/website/how-to-get-youtube-api-key) on how to create the API key in order to access YouTube data.
+Check out [this guide](https://blog.hubspot.com/website/how-to-get-YouTube-api-key) on how to create the API key in order to access YouTube data.
 </Tip>
 
 The first step is to create a database with the new `Youtube` engine using the following command:
 
 ```sql
 CREATE DATABASE mindsdb_youtube
-WITH ENGINE = 'youtube',
+WITH ENGINE = 'YouTube',
 PARAMETERS = {
-  "youtube_api_token": "<your-youtube-api-key-token>"  
+  "YouTube_api_token": "<your-YouTube-api-key-token>"  
 };
 ```
 
 <Tip>
-If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler's folder (mindsdb/integrations/handlers/youtube_handler) and run this command: `pip install -r requirements.txt`.
+If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the
+    handler's folder `mindsdb/integrations/handlers/YouTube_handler` and run this command: `pip install -r requirements.txt`.
 </Tip>
 
 ## Usage
 
-Use the established connection to query the `get_comments` table for any YouTube Video of your choice.
-
-```sql
-SELECT * FROM mindsdb_youtube.get_comments
-WHERE youtube_video_id = "raWFGQ20OfA";
-```
+Use the established connection to query the comments table
 
+~~~~sql
path: docs/integrations/app-integrations/youtube.mdx
text: @user1:
In the MDX format, we use triple backticks, so please change it back throughout this doc page.