0

I'm getting the error beneath while writing in AWS Timestream.

ValidationException: An error occurred (ValidationException) when calling the WriteRecords operation: 
You have reached the maximum number of Multi measureValue names for a record. 
See Quotas in the developer guide for additional information. 
still moving on

There are 395 columns in my Data frame which I tried to split into two lists: one with 200 and another with 195 columns.

According to AWS Timestream documentation the max number of multi measure names should be 256 which is satisfying my condition. This is the code to split the columns:

col_list = [col_names[i:i + n] for i in range(0, num_cols, n)]
col_list1 = col_list[0]
col_list2 = col_list[1]

This is the length of the 2 col_lists: [1]: https://i.stack.imgur.com/QBRzT.png

SwissCodeMen
  • 4,222
  • 8
  • 24
  • 34
Anisha Choudhury
  • 1
  • 3
  • Do you understand that there's a hard limit on the amount of measurement columns your Timestream table have, right? So, it doesn't matter if you try to split the write, it'll never accept more than 256 columns of measures. And, to be honest, if you have 395 columns of metrics, Timestream is probably not the solution you're looking for. Welcome to the community and feel free to ask more questions! :D good luck! – Eduardo Elias Saléh Feb 07 '23 at 11:10

0 Answers0