in schema-induction/src/main/java/aws/json/schema/induction/RedshiftDDLGenerator.java [15:34]
public String generate(SchemaNode root, String tableName, String s3location, boolean isNDJSON) {
StringBuffer ddlBuffer = new StringBuffer();
ddlBuffer.append("create external table ");
ddlBuffer.append(tableName);
ddlBuffer.append("(\n");
ddlBuffer.append(getColumns(root));
ddlBuffer.append("\n)\n");
ddlBuffer.append("row format serde 'org.openx.data.jsonserde.JsonSerDe'\n");
ddlBuffer.append("with serdeproperties (");
ddlBuffer.append("'dots.in.keys' = 'true'");
ddlBuffer.append(",'mapping.requesttime' = 'requesttimestamp'");
if (isNDJSON)
ddlBuffer.append(",'strip.outer.array' = 'true'");
ddlBuffer.append(")\nlocation '");
ddlBuffer.append(s3location);
ddlBuffer.append("'\n;\n");
return ddlBuffer.toString();
}