The data node that can be used as input and output in CopyActivity
The base trait of all data nodes
The abstracted RedshiftDataNode
Defines data from s3
Defines data from s3 directory
that the AWS Datapipeline SqlDataNode does not require a JdbcDatabase parameter, but requires specify the username, password, etc. within the object, we require a JdbcDatabase object for consistency with other database data node objects.
this is not tested or documented anywhere in AWS Data Pipeline Docs, we are assuming the insert syntax is 'insert into mytable (col1, col2, ...)' without 'values'.