question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked deherman-MSFT edited

CurrentMonth/CurrentDay/Sysdate

Hello Team,

I am trying to extract the data from csv file from Blob storage and trying to load into synapse analytics. The Path :

https://BlobStorageName.blob.core.windows.net/global/ods/coastal/2021/09/28/Test.csv.

I need to mention the path like mentioned below .


https://BlobStorageName.blob.core.windows.net/global/ods/coastal/CurrentYear/CurrentMonth/CurrentDay/Test.csv.

Manually every time I can't go and select the path. Please advise.


Thanks in Advance
RK

azure-synapse-analyticsazure-blob-storage
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@RohitKulkarni-6062 Could you please clarify how you are trying to access the blob url? Is this something you are doing programmatically or via portal or some tool?

0 Votes 0 ·

1 Answer

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.