I started doing a course where I use Google BigQuerry to try out SQL with a spreadsheet about a movie theater. I want to upload a CSV file to BigQuerry but i keep getting an error with the field name.

If someone has experienced this problem before and knows a fix, please let me know.

In the instructions it’s as simple as downloading the CSV file, selecting auto-detect for schema and pressing create table. I can’t however seem to be able to create the table because i keep getting an error like: Failed to create table: Field name ‘Director (1)’ is not supported by the current character map. Please change your field name or use character map V2 to let the system modify the field names.

i realised that () was not supported so i changed it to Director_1, which seemed to help the problem in that field but i can’t get rid of the last error where i get the error code: Failed to create table: Field name ‘Revenue;’ is not supported by the current character map. Please change your field name or use character map V2 to let the system modify the field names.

note: Revenue is the final column and i dont have the semicolon written in my CSV file so i can’t get rid of it.