Hey @wkhan, thanks for the reply!
Here is the latest workflow attached.
The third step establishes a connection to Snowflake (DB Connector), the next node (DB SQL Executor) executes COPY INTO of the CSV files from the Snowflake S3 stage to a Snowflake table.
Here is the query executed within the DB SQL Executor looks like:
FILE_FORMAT = (
TYPE = CSV,
RECORD_DELIMITER = '\n' ,
FIELD_OPTIONALLY_ENCLOSED_BY = '"'
It appears several nodes seem deprecated, e.g.
Amazon S3 Connection, CSV Writer, List Files, Created Directory, Upload and List Remote Files.
Amazon S3 Connection and
CSV Writer seem to have equivalent new nodes to replace the older ones. For instance,
Amazon S3 Connection becomes two nodes - a connection node and an authentication node.
What nodes to use to create the same workflow or process without using the deprecated nodes?