Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse by Mark Beckner;

Author:Mark Beckner;
Language: eng
Format: epub
Publisher: De Gruyter
Published: 2019-11-15T00:00:00+00:00

Figure 2.19: Allowing a connection to ADLS from ADF

4.Assuming you have the connection worked out with your linked service, click the Finish button.

5.Now, set the File path property by clicking on the Browse button. We’ll use the same SalesData folder that we manually uploaded the CSV file to earlier in this chapter. Select this folder and click Finish. At this stage the file property can be hardcoded—we’ll come back and make this dynamic after getting the core pipeline functional. For this exercise, create a text file that looks like that shown in Figure 2.20.

6.Give the file a name like “export.txt.”. This will allow us to create a mapping to this structure. We’ll create an SQL table shortly that matches this structure (see Listing 2.2). When this file is created, upload it to your Data Lake storage using the Data explorer and place it in the SalesData folder.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.