Incorrect Data Types for Google BigQuery creation

[kevinjyee]

In the scripts for big query,

create table concept (
  concept_id			    integer			  not null ,
  concept_name	            varchar(255)  not null ,
  domain_id		            varchar(20)		  not null ,
  vocabulary_id	            varchar(20)		  not null ,
  concept_class_id		   varchar(20)		  not null ,
  standard_concept		   varchar(1)		  null ,
  concept_code		   varchar(50)		  not null ,
  valid_start_date		   date			  not null ,
  valid_end_date		   date			  not null ,
  invalid_reason		   varchar(1)		  null
)
;

the data type varchar is used.
However, Google Bigquery does not support the datatype "varchar" for neither their Legacy nor Standard SQL

https://cloud.google.com/bigquery/data-types
https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types

Was this script meant for Google Cloud Sql instead of BigQuery?

[clairblacketer]

@kevinjyee I created the big query ddl using SqlRender which takes a sql server script and converts it to a different dialect. I suspect this problem is an artifact of how it was translated. I see you created a PR to address this. I will pull it in and open an issue with SqlRender (#119).