Query YouTube VideoCategories. A VideoCategory resource identifies a category that has been or could be associated with uploaded Videos.

Table-Specific Information

SELECT

You can specify exactly one of the following columns: Id or Region. If you do not specify any filtering criteria, the driver returns results for the US Region by default. Language is an optional filter column and supports the = operator.

SELECT * FROM VideoCategories WHERE Region = 'JP'

Use the IN operator to filter on multiple Ids:

SELECT Id, ChannelId, Title, Assignable
FROM   VideoCategories
WHERE  (ID IN ('1', '2', '10'))

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
Id [KEY]	String				The unique identifier for the video category.
ChannelId	String				The YouTube channel that created the video category.
Title	String				The title of the video category.
Assignable	Boolean				Indicates whether videos can be associated with the category.
Region	String				The country from which to retrieve video categories.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
Language	String	Specifies the language that should be used for text values in the API response. The default value is en_US.