CIK VARCHAR(16777216)
COMPANY_NAME VARCHAR(16777216)
EIN VARCHAR(16777216)
SIC VARCHAR(16777216)
SIC_CODE_CATEGORY VARCHAR(16777216)
SIC_CODE_DESCRIPTION VARCHAR(16777216)
CITY VARCHAR(16777216)
STATE VARCHAR(16777216)
STATE_GEO_ID VARCHAR(16777216)
COUNTRY VARCHAR(16777216)
COUNTRY_GEO_ID VARCHAR(16777216)

use these columns to form create table command for spark sql. remember to use datatypes supported by spark dont use varchar since its not spported by spark. Also use lowercase for column names.