readycopy

$serverName = 'usgsserver' + $participantNumber
$fullyQualifiedServerName = $serverName + '.database.windows.net'
$dataWarehouseName = 'usgsdataset'
$dataFactoryName = 'usgsdatafactory' + $participantNumber
$dataLakeName = 'usgsdatalake' + $participantNumber
$adminUser = 'usgsadmin'
$adminPassword = 'P@ssword' + $participantNumber

$integrationRuntimeName = 'selfHostedIntegrationRuntime101'
$dWConnectionString = "Server=tcp:$fullyQualifiedServerName,1433;Initial Catalog=$dataWarehouseName;User ID=$adminuser;Password=$adminPassword;Encrypt=True;TrustServeCertificate=False;Connection Timeout=30;"
$dataLakeAccountKey = (Get-AzureRmStorageAccountKey -ResourceGroupName $resourceGroupName -AccountName $dataLakeName).Value[0]
$destinationFileName = "@dataset().cw_fileName"
$destinationFolderPath = "usgs\\fireevents"
$dataLakeURL = "https://$dataLakeName.dfs.core.windows.net"

# Create a data factory pipeline to copy from SQL Server to ADLS Gen2
New-AzureRmResourceGroupDeployment -Name USGSARMDeployment -ResourceGroupName $resourceGroupName -TemplateFile C:\Scripts\Module1\CopyfromSQL\arm_template.json -factoryName $dataFactoryName -integrationRuntime_integrationRuntime1 $integrationRuntimeName -usgssql_connectionstring $dwConnectionString -usgsdatalakevnet1_accountkey $dataLakeAccountKey -DestinationDataset_eeb_properties_typeProperties_filename $destinationFileName -DestinationDataset_eeb_properties_typeProperties_folderPath $destinationFolderPath -usgsdatalakevnet1_properties_typeProperties_url $dataLakeURL