Nifi: What is the best way to issue a SQL CREATE table command?

[#1]

It seems that there are processor options for SQL INSERT, UPDATE and SELECT, but what about other commands? CREATE for example?

My understanding is that ExecuteSQL is not intended for this as it expects rows back (description states that it is for SELECT). So, how else would / should I do this (and similar, i.e, generic SQL commands that may not necessarily involve data directly)?

[#2]

@Ben

An option to consider if you want to run other types of DDL is via executeprocess process. Within this processor you can script up the activities not perform OOB with NiFi.

[#3 · Accepted solution]

The PutSQL processor issues statements and does not expect a ResultSet to be returned, you can use that to issue DDL/DML commands.