Schema enforcement from External Location

[Dp15]

Hi, 
This might be a silly question to ask but is it possible to enforce schema on a table created from external location, I am trying to create a table from a s3 location and my command looks like this

query = """CREATE TABLE IF NOT EXISTS {}
           USING PARQUET 
           LOCATION '{}'""".format(raw_table,s3_bucket_location)

but I am not happy with the schema it infers from the parquet, Is there a way I can enforce schema on this table by changing some column types ? I tried by add the 
options ( schema = <schema_definition> ) to the create command, that didnt work.

[feiyun0112 · Accepted solution]

define columns when create table 

https://community.databricks.com/t5/data-engineering/external-table-from-parquet-partition/td-p/2468... 

[Kaniz_Fatma]

I want to express my gratitude for your effort in selecting the most suitable solution. It's great to hear that your query has been successfully resolved. Thank you for your contribution.