get_cost_and_usage method pagination

[peixeirodata]

Describe the feature

get_cost_and_usage method returns a 'NextPageToken' field in the response body, but when using the test paginator as below an OperationNotPageableError is raised:

import boto3

client = boto3.client(
                      'ce',
                      aws_access_key_id = '<KEY_ID>',
                      aws_secret_access_key = '<KEY_SECRET>')

params = {"TimePeriod": {"Start": "2024-06-01", "End": "2024-12-31"},
          "Granularity": "DAILY",
          "Metrics": ["UNBLENDED_COST", "USAGE_QUANTITY"],
          "GroupBy": [{"Type": "DIMENSION", "Key": "SERVICE"}, {"Type": "DIMENSION", "Key": "USAGE_TYPE"}]}

paginator = client.get_paginator('get_cost_and_usage')

for page in paginator.paginate(**params):
    print(page)

Use Case

Retrieve a wide range of dates with this method

Proposed Solution

No response

Other Information

I checked this document and this indicates me that the paginator is not implemented for this method:
https://github.com/boto/botocore/blob/master/botocore/data/ce/2017-10-25/paginators-1.json

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

SDK version used

boto3 1.35.99

Environment details (OS name and version, etc.)

Databricks environment

[RyanFitzSimmonsAK]

Hi @peixeirodata, thanks for reaching out. I've recently reached out to the Cost Explorer service team about adding several paginators, including GetCostAndUsage. You can see that issue here. I'll be closing this issue as a duplicate. Please refer to an SDK or AWS CLI changelog for updates about this going forward. Thanks!