Already i have mentioned in above comments .i am using the below comments :
COPY INTO Table1
FROM 'azure://BlobStorageName.blob.core.windows.net/global/ods/coastal/2021/09/28/Test.csv.'
FILE_FORMAT = (TYPE = 'csv' FIELD_OPTIONALLY_ENCLOSED_BY = '"' RECORD_DELIMITER = '\n' SKIP_HEADER = 1 ) ON_ERROR='Continue';
I need to make currentYear and Current Month and Current date i need to make Dynamic.