Update dataset custom query automatically

Question & Answer
,
1

Hi,

We have built a CUR dashboard and we have a dataset like this

SELECT
bill_period,
cost,
account_id,
awsservice,
region
FROM CUR.CostSummary
WHERE
year IN (‘2025’)
AND account_id in (accountlist)

Our problem is that our accountlist is growing, new accounts are being added every often and we want to make sure that our dashboard are up to date once new account is added. How do we automate the addition of new account number in the accountlist?

2

Hi @EJRD

My suggestion is to set up have a table in your database (or excel if you want) where you can keep the list of your accounts. Whenever you have new additions update the account in the table and use that table in a join with your CostSummary table

Regards,
Giri

3

Thank you. This make sense.