The customer_all view is used to direct query a small portion of the full cost and usage report.
Modify the following SQL query for View0 - Account Map:
On line 5, replace (database.table_name) with your Cost & Usage Report database and table name
CREATE OR REPLACE VIEW customer_all AS
WHERE (CAST("concat"("year", '-', "month", '-01') AS date) >= ("date_trunc"('month', current_date) - INTERVAL '3' MONTH))
Confirm the view is working, run the following Athena query and you should receive 10 rows of data:
select * from costmaster.customer_all