[jira] [Created] (NIFI-7862) Allow PutDatabaseRecord to optionally create the target table if it doesn't exist

["Matt Burgess (Jira)" <ji...@apache.org>]

Matt Burgess created NIFI-7862:
----------------------------------

             Summary: Allow PutDatabaseRecord to optionally create the target table if it doesn't exist
                 Key: NIFI-7862
                 URL: https://issues.apache.org/jira/browse/NIFI-7862
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Extensions
            Reporter: Matt Burgess


As part of NIFI-6934, the "Database Type" property was added, allowing for DB-specific SQL/DML to be generated. That property could be used with a new true/false property "Create Table" that would create the target table if it didn't already exist.

I wouldn't go so far as to support schema migration (changing column types, e.g.), at least not for this case, the intent here would only be to check if table exists and attempt to create it , mapping the NiFi Record datatypes to DB-specific column types and generating/executing a DB-specific CREATE TABLE statement. If "Create Table" is set to true and an error occurs while attempting to create the table, the flowfile should be routed to failure or rolled back (depending on the setting of the "Rollback on Failure" property).



--
This message was sent by Atlassian Jira
(v8.3.4#803005)