Add
button, choose New Datasource
, search for YouTube
, and follow the instructions in the form. After providing the connection name and the YouTube API token, click on the Test Connection
button. Once the connection is established, click on the Save and Continue
button.youtube_api_token
: It is a Google API key used for authentication. Check out this guide on how to create the API key to access YouTube data.Add
button, choose New Datasource
, search for YouTube
, and follow the instructions in the form. After providing the connection name and the credentials file or URL, click on the Test Connection
button and complete the authorization process in the pop-up window. Once the connection is established, click on the Save and Continue
button.credentials_file
: It is a path to a file generated from the Google Cloud Console, as described below.credentials_url
: It is a URL to a file generated from the Google Cloud Console, as described below.How to Generate the Credentials File
../auth/youtube
, .../auth/youtube.force-ssl
, .../auth/youtubepartner
.Web application
and provide a name. In the Authorized redirect URIs, add the following: http://localhost/verify-auth
, https://cloud.mindsdb.com/verify-auth
, http://127.0.0.1:47334/verify-auth
comments
table.
You can query for one video’s comments:
channels
table.
channel_id
column is mandatory in the WHERE
clause.
Use the established connection to query the videos
table.
video_id
column is mandatory in the WHERE
clause.
With the connection option 2, you can insert replies to comments: