3/31/2023 0 Comments Bigquery json query![]() Make sure you can now view this Table on your Table list.Give this table the name “YouTubeCategories”, and then – save it.After the query Run – click “Save Results”, click “BigQuery” and then “Save”.We will extract categories from the Json file. ![]() The new table we create will be named – YouTubeCategories.** Notice that the UNNEST() function explodes the JSON (which is 1 row of ) and allocates the kind and etag to all the other rows. ![]() ** In this case we use the table as “External” SUBSTR(_FILE_NAME, LENGTH('gs://rainbowdash/YouTubeStatistics/') + 1, 2 ) country,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |