Data Warehouse FTP | Community
Skip to main content
skatofiabah
skatofiabah
Level 5
November 26, 2024
Solved

Data Warehouse FTP

Hi,

 

We just ran a Data Warehouse Request and FTP. It says it's CSV but how do we access it?

MandyGeorge
MandyGeorgeAccepted solution
New Participant
November 26, 2024

That will depend on the destination that you set up. When you created the data warehouse job, one of the pages asked for an account and location. 

 

Under report destination it asks for an account and location. The account is the type of destination that you're going to send it to. It sounds like you're using an FTP. It should ask you for the account properties. Then you need to set up the location, this will be the exact spot where it will send the file. 

 

Just a note, FTP for data warehouse is considered legacy, although you can still use it. What is it that you're planning to do with the file? If it's a one time drop, you could have it sent to your email (or anyone's email). 

View reply

12 replies

MandyGeorge
MandyGeorgeAccepted solution
New Participant
November 26, 2024

That will depend on the destination that you set up. When you created the data warehouse job, one of the pages asked for an account and location. 

 

Under report destination it asks for an account and location. The account is the type of destination that you're going to send it to. It sounds like you're using an FTP. It should ask you for the account properties. Then you need to set up the location, this will be the exact spot where it will send the file. 

 

Just a note, FTP for data warehouse is considered legacy, although you can still use it. What is it that you're planning to do with the file? If it's a one time drop, you could have it sent to your email (or anyone's email). 

Translate
    skatofiabah
    skatofiabahAuthor
    Level 5
    November 26, 2024

    Hi @mandygeorge,

     

    How do you open an FTP with a location path and port? Also, can you send a Data Warehouse Request to your email to open a CSV file via email?

    Translate
    NicoleYa
    Level 2
    November 26, 2024

    Not sure if this helps, but we used Azure Synapse pipeline to copy data from the FTP server with path and port, and stored data into Azure data lake. But then this become unavailable since 11/05/2024 because the data warehouse is deprecated. so now we are trying to look for new options. 

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...