Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

copy .csv data to warehouse

hello, using the copy activity in fabric I can take data from .csv file (Which is sitting in azure storage account) and place the data into the table in the warehouse (tblwh) - I am using mapping in...
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    I can also find the same result -


    By default FileName and FilePath are designed like that.
    As a workaround (assume file path won't change dynamically), you can use custom value -

     

    Hope this is helpful. Please let me know incase of further queries.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

I can also find the same result -


By default FileName and FilePath are designed like that.
As a workaround (assume file path won't change dynamically), you can use custom value -

 

Hope this is helpful. Please let me know incase of further queries.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

hi, I see you have hardcoded the value however my pipeline I would like it to be dynamic as the path will vary since the source varies

any suggestions?

thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Can you please share the screenshot of Copy Activity - Source?
    I would like to see how are defining file path dynamically? So that I can help you.