Azure RM cmdlet

From Ittichai Chammavanijakul's Wiki
Jump to: navigation, 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