Redshift documentation bug report: STORED AS is optional for CREATE EXTERNAL TABLE

Question

Loading json files from s3, this runs fine but STORED AS is not marked as optional in the documentation

```
create external table spectrum.mytable(id int, updated_at timestamp)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
location 's3://mybucket';
```

MilindOke · Answer

Firstly, thank you for catching this.

The best way to report this is through the "[Provide feedback](https://docs-feedback.aws.amazon.com/feedback.jsp?hidden_service_name=Redshift&topic_url=http://docs.aws.amazon.com/en_us/redshift/latest/dg/r_CREATE_EXTERNAL_TABLE.html)" link towards the bottom of the page.

That will open a new window where you should select `Type of issue` as `Incomplete information` and fill out the details.

Redshift documentation bug report: STORED AS is optional for CREATE EXTERNAL TABLE

Add your answer

Relevant content