When using this code:
CREATE TABLE my-data-project-2448.Customer_Data.CUSTOMER (
CustomerID INTEGER
FirstName CHAR (15),
LastName CHAR (20),
Street CHAR (30),
City CHAR (25),
Region CHAR (25),
Country CHAR (25),
Phone CHAR (13)
);
I am trying to just create a table in one of my datasets for Customer_Data but is giving me the error:
Syntax error: Expected “)” or “,” but got identifier “FirstName” at [3:3]
Not sure what is going on here and need some assistance.
I am currently using bigquery, and tried to make sure the CREATE TABLE statement was correct.
Elliott Earley is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.