Azure RM cmdlet
Jump to navigation
Jump to search
# Authenticate Login-AzureRmAccount # Set Subscription Set-AzureRmContext -SubscriptionName $subscriptionName #Provision the Azure data warehouse and SQL server via ARM template New-AzureRmResourceGroupDeployment -Name "BI Tool Version 1.0" -ResourceGroupName $resoourceGroupName -TemplateParameterFile $templateParameterFilePath -TemplateFile $templateFilePath Get-AzureRmDataFactorySlice -ResourceGroupName DW-BI-Prod-RG -DataFactoryName ZDW-BI-Prod-DF -DatasetName IN-DS-SFTP-Eloqua-Activity -StartDateTime "4/6/2017 12:00:00 AM" -EndDateTime "4/7/2017 12:00:00 AM" Get-AzureRmDataFactorySlice -ResourceGroupName DW-BI-Prod-RG -DataFactoryName DW-BI-Prod-DF -DatasetName OUT-DS-ADLS-Eloqua-Activity -StartDateTime 2017-04-06T18:00:00 -EndDateTime 2017-04-07T18:00:00 Get-AzureRmDataFactoryRun -ResourceGroupName DW-BI-Prod-RG -DataFactoryName DW-BI-Prod-DF -DatasetName IN-DS-SFTP-Eloqua-Activity -StartDateTime "04/06/2017 12:00:00 AM" Get-AzureRmDataFactoryActivityWindow -DataFactoryName DW-BI-Prod-DF -ResourceGroupName DW-BI-Prod-RG -Top 10 Get-AzureRmDataFactoryRun -ResourceGroupName DW-BI-Prod-RG -DataFactoryName DW-BI-Prod-RF -DatasetName IN-DS-SFTP-Eloqua-Activity -StartDateTime 2017-04-05T16:00:00Z # PAUSE & RESUME PIPELINE Resume-AzureRmDataFactoryPipeline -ResourceGroupName DW-BI-Prod-RG -DataFactoryName DW-BI-Prod-DF -Name ZBRPL_elq_AzureDW Suspend-AzureRmDataFactoryPipeline -ResourceGroupName DW-BI-Prod-RG -DataFactoryName DW-BI-Prod-DF -Name ZBR-DF-eloqua
