I am looking for Stored As option to support AVRO format. We are using ER 17.0.2(Build 10207) and do not find AVRO in the options. So is there any way to add AVRO into that drop down list ? Is there a possibility to create a macro to generate DDL and update it ? what options do I have if I want to avoid editing the DDL manually after generating script.
This is being looked at for a future release. The only option right now would be to put it in the Post SQL tab and that should get it to work. When you generate a database script, you may need to go to the General Options and remove the delimiter to have the script look correct.
If we use Post SQL tab and generate database script by selecting multiple tables at a time, all post SQL tab content is appended at the end of script. So not sure how this option would be feasible. Also, any idea on when would this feature be available ?
If you put the post SQL in the Entity,
then it will append it to the end of the Create Table statement. If you do the post SQL on a model level, then it'll do it at the end of the script.
I don't have any dates on when it'll be available yet.