yeah I can get rid of the macro input and just have the directory input read in. But I don't think control parameters have any input option? is that the parameter type you meant? I have attached some screenshots (sorry for the redaction of private info)
step 1: read in the directory
step 2: grab the file name, then concatenate with a hard code of the connection string that the output data uses to write to redshift and append the filename (which will be the table name) to the end of it, just like the connection string does when you output to redshift with the output tool
step 3: use a select tool to just grab filename, the new connection string I created in the formula tool, and the path.
once in the macro: the filename and path are used to dynamically load the table, the new connection string is supposed to be fed into the output data tool but thats the part I can't figure out how to do.