public String generate()

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();
    }