How to dynamically create a table from json metadata?

Hi @ag, I think you can build SQL statements from the JSON documents and execute them to create DB tables with the SQLExecutor transformer. If you could share a few samples of the JSON files, I would try implementing a workspace example.

Here is an example creating some data (name and fme_data_type) and necessary schema attributes (fme_geometry{0} and fme_feature_type) and dynamically writing.

@takashi, curious how you do that dynamically. I am attaching one example of the json file.

basin_header.json

Hi @ag, the writer is set according to the same way as described in the link provided. Basically using the dynamic mode with fme_feature_type as table name.

See section 4 https://knowledge.safe.com/articles/1051/index.html

Thanks for the URL. I need to change the column_name to be exactly "name" and use "attribute" as the list. it works now. I have an issue with one column though. The "entitled_key" is varchar2(65536), so fme_varchar(65536). The FME gives and error on "create table ..." sql. This sql is mis-formed at the end in FME. The reason is that the standard length limit for Oracle 12c on varchar2 is 4000. After I change the column_size to be 4000, it successfully creates the table . Many thanks.