Difference between revisions of "Azure RM cmdlet"
Jump to navigation
Jump to search
(Created page with "<pre> # Authenticate Login-AzureRmAccount # Set Subscription Set-AzureRmContext -SubscriptionName $subscriptionName #Provision the Azure data warehouse and SQL server via...") |
|||
Line 8: | Line 8: | ||
#Provision the Azure data warehouse and SQL server via ARM template | #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 | 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 | ||
</pre> | </pre> | ||
[[Category:Azure]] | [[Category:Azure]] |
Latest revision as of 18:12, 8 September 2018
# 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