Questions tagged [cost-management]

Use this tag for questions related to budgeting, cost analysis, cost management or cost calculation in any of various programming-related contexts, especially resource management and on-demand cloud computing.

Overview

  • Use this tag for questions related to budgeting, cost analysis, cost management or cost calculation in any of various programming-related contexts, especially resource management and on-demand cloud computing.

See also

211 questions
0
votes
1 answer

Would querying 60 columns from a Snowflake table would cost me more than querying 20 columns?

We are trying to find a less expensive way and more manageable way have our queries being stored and executed. One approach is to retrieve information from 60 columns every time someone queries and the other option is to make do with whatever…
0
votes
1 answer

Schedule-Export Billing Invoice of Azure Resource-Group cost analysis monthly

I want to automatically get the Billing Invoice details of my Azure Resource-group on a monthly basis using the Schedule Export feature in Azure Cost-Management. I'm able to create a monthly export. However, I'm not able to get the entire month's…
SD4
  • 439
  • 10
  • 27
0
votes
1 answer

Google Sheet - Calculate a cost

I'm trying to reproduce that lovely website that helps you calculate the cost of something you bought into my personnal google sheet so it's easier for me to use it. I'm seeking here for help since I don't really know how to adapt the math when you…
0
votes
1 answer

AWS Cost Explorer - stopping s3 reports

I enabled reporting from AWS Cost Explorer to an S3 bucket to test spot.io. I am being charged about $6.50 a month in API requests to Cost Explorer. I would like to turn off this feature so that I am no longer charged. Does anyone have any ideas on…
natsbat4ws
  • 67
  • 2
  • 8
0
votes
0 answers

How can I calculate cost for transfering files from S3 Standard-IA to S3 One Zone-IA

I need to calculate cost to do transmittion/transmit/move whole data from S3 Standard-IA to S3 One Zone-IA (for cost saving). I need to calculate all cost that apply to transfer because I have to transfer millions files and total 20TB size of data.…
Prashant Godhani
  • 337
  • 1
  • 4
  • 15
0
votes
1 answer

BigQuery: querying the latest partition, bytes to be processed vs. actually processed

I'm struggling with querying efficiently the last partition of a table, using a date or datetime field. The first approach was to filter like this: SELECT * FROM my_table WHERE observation_date = (SELECT MAX(observation_date) FROM my_table) But…
PBurns
  • 41
  • 4
0
votes
1 answer

Aggregate EC2 costs with key pair

Unfortunately, in my org there is not a good tag enforcement. Is it possible to group the ec2 costs by key pair used using boto3 or some other way? I don't see any methods here:…
NEO
  • 1,961
  • 8
  • 34
  • 53
0
votes
1 answer

Monitoring Cpu, iops and memory on Azure

I want to monitor the cpu/iops/memory usage for my appliation in an azure vm. I need to run it different times for different families to chose the best fit for my app. Should I use Azure monitor or a cli app inside my VM? Which are the best tools to…
0
votes
1 answer

Azure Cost Alert using Powershell

When i create a new budget using powershell and try to set alert using the same command, it sets but not displaying in cost alerts section and also the amount not seen in alert conditions. Below is the command: Set-AzConsumptionBudget -Amount…
Priya.D
  • 111
  • 9
0
votes
1 answer

AWS Cost and Usage Reports and linked accounts

I'm currently under an AWS Organisation Subscription. I want to export cost by CSV of my linked account into a S3 bucket. I have rights on my account, I can use Cost Explorer, do Budgets, but I'm unable to do the Cost&Usage Report as shown in this…
Otor
  • 410
  • 10
  • 21
0
votes
1 answer

How to add a resource monitor for MATERIALIZED_VIEW_MAINTENANCE and AUTOMATIC_CLUSTERING?

I would like to add a Resource Monitor for monitoring the costs for MATERIALIZED_VIEW_MAINTENANCE and AUTOMATIC_CLUSTERING. An email should be send if these costs above a specific threshold. Is there any way to do it? I can only chooses ACCOUNT or…
0
votes
2 answers

Is it possible to make a cost analysis per project in Azure Devops?

I see that in Azure Devops the billing account is set per organization. So, I can do a cost analysis per organization. Is it possible to do the same thing on a project level with labels and etc? I have checked but I couldn't find any labeling for…
MoonHorse
  • 1,966
  • 2
  • 24
  • 46
0
votes
2 answers

Failed to update data source credentials: The column 'budgetAmount' of the table wasn't found - Power BI Azure Cost Management Connector

I started using the Azure Cost Management Connector for Power BI. I could use it without an issue on Power BI desktop and import data into my report. However, when I published the report, it gives me the following error: My report is pretty basic.…
Sahan Serasinghe
  • 1,591
  • 20
  • 33
0
votes
3 answers

How do I come up with a formula to solve the following: If a cell is zero, add a number from a different cell to the total cost?

I need to add estimated costs and actual costs to a total budget. To start, we put the estimated cost of travel on the spreadsheet. When the person goes on travel, they invoice their actual travel costs when they return. We have to add the Room…
0
votes
1 answer

how to get Resource and Resource groups Cost information, from azure rest API'S

I am using Microsoft azure rest API'S to get Information. I want to get Cost Information for Resources and Resource Groups for that subscription. I tried many apis but didn't work.. any help will be appreciated. Thanks