CODEWITHSUNDEEP
azureterraformcost-management
N1ckson
N1ckson

Reputation: 21

How to make an azure cost management export run daily and only export that day or previous days data? Using terraform or azure api

Taking the Terraform resource example:

resource "azurerm_billing_account_cost_management_export" "example" {
  name                         = "example"
  billing_account_id           = "example"
  recurrence_type              = "Daily"
  recurrence_period_start_date = "2020-08-18T00:00:00Z"
  recurrence_period_end_date   = "2020-09-18T00:00:00Z"

  export_data_storage_location {
    container_id     = azurerm_storage_container.example.resource_manager_id
    root_folder_path = "/root/updated"
  }

  export_data_options {
    type       = "Usage"
    time_frame = "Custom"
  }
}

The documentation isn't very clear what time_frame = "Custom" does and what else to add here?, I would like to create an export that runs daily however it only exports that day or maybe the previous days worth of data not month-to-date being the closest to this. As i do not want all of the other days data on that export. Is Setting the time_frame to custom allow me to do this? Will i have to set a start_date and end_date? and if so can i then run an update request daily potentially to change the days in a script someway as an alternative option

Tried creating a day-to-month export however the file is too large and comes with unwanted data as the end of the month comes along

Upvotes: 1

Views: 1290

Answers (2)

Francesco Mantovani
Francesco Mantovani

Reputation: 12367

I would suggest you to use the Azure Cost Management connector in Power BI Desktop , upload that on Power BI and set a daily refresh.

You can then query the Datamart like a database daily.

Upvotes: 0

Swarna Anipindi
Swarna Anipindi

Reputation: 954

Is Setting the time_frame to custom allow me to do this?

Yes, we can do this via json api.
enter image description here

Terraform provider it self not supporting this option. Refer below screenshots.

I have replicated the ways using terraform, no luck. Using terraform we have only below custom options. time_frame only allows below mentioned parameters. enter image description here

Possible values include: WeekToDate, MonthToDate, BillingMonthToDate, TheLastWeek, TheLastMonth, TheLastBillingMonth, Custom.

seems the respective custom parameters are specific to Month. we can use like

time_frame  =  "TheLastMonth"

enter image description here

Upvotes: 1

Related Questions