Forum Discussion
Azure Cost Management - Import Columns
Is there a way to import certain columns from Azure Cost Management or does it have to be the full table? Our dataset is prohibitively large.
Hi RShackelford ,
Azure Cost Management's export feature itself does not support exporting just one column; it can only export the entire table. I also checked the REST API related to Azure Cost Management and it seems that the interface related to exporting only a column does not exist.
If you are loading too slowly due to the sheer volume of data in the entire table, I would suggest that you try the partitioned export for large datasets mentioned in that document, which may perhaps optimize your performance in this regard.
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-export-acm-data?tabs=azure-portal#file-partitioning-for-large-datasets
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-improved-exports
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi RShackelford ,
Azure Cost Management's export feature itself does not support exporting just one column; it can only export the entire table. I also checked the REST API related to Azure Cost Management and it seems that the interface related to exporting only a column does not exist.
If you are loading too slowly due to the sheer volume of data in the entire table, I would suggest that you try the partitioned export for large datasets mentioned in that document, which may perhaps optimize your performance in this regard.
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-export-acm-data?tabs=azure-portal#file-partitioning-for-large-datasets
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-improved-exports
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.