I need the syntax for specifying FILE PATH " to upload CSV files located in the remote server protected by username and password.
I am able to upload the files with the following syntax if the csv files are placed locally .
COPY my_table FROM 'c:\localsystem\file.csv' DELIMITERS ',' CSV;