search

kromerm / adflab

Azure Data Factory hands-on lab, self-paced. Learn how to lift & shift SSIS packages to the Cloud with ADF. Build new ETL pipelines in ADF, transform data at scale, load Azure Data Warehouse data marts. Also walks through operationalizing ADF pipelines with scheduling and monitoring modules.
http://aka.ms/adflab2
137 stars 129 forks source link

Lab 5 - WASB Paths require updates #8

Closed patpicos closed 6 years ago

patpicos commented 6 years ago

The documentation should ask the developer to update the FAAMerge.hql hive script to reflect the automatically generated storage account name

Mine was adflabstorage7nuut for example.

This is required 3 times in the HQL.

Also, hard coding of storage accounts in HQL makes the script not portable between environments.

kromerm commented 6 years ago

Good point ... we'll add replacement vars in the script and document those actions required

joshuha commented 6 years ago

Since you can edit this right in the GUI with Add/Edit script I added steps and screenshot for that in Lab Module 5.