'Trying to load a .sql file into Bigquery
I'm trying to do some practice queries, and I found a site with some excercises. I need to upload this .sql file into Bigquery https://www.wiseowl.co.uk/files/exercise-question-files/qf-792.zip
I uploaded it to Google Drive, then tried to add it as a table. This is the error I get:
Failed to create table: Error while reading table: world_events, error message: Failed to parse JSON: Unknown token type; Unexpected token; Parser terminated before end of string
Can anyone tell me what I'm doing wrong? Bigquery didn't give me any problems like this when uploading CSV files.
Opening the small file as though it were a text and reading near the top, it suggests that it contains four different tables.
tblCategory
tblContinent
tblCountry
tblEvent
Is Bigquery not able to seperate the data into 4 seperate tables?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|