AWS Billing Report files are improperly formatted (contains columns with no headers)
We are trying to ingest AWS billing data from the billing reports generated in S3 by AWS into our Snowflake datawarehouse. We are using a data extraction tool (Fivetran) to get this task done. The tool is working perfectly for every billing report except one file where we have additional columns with no data and no headers (just additional commas in csv file). Can AWS provide csv files which are properly formatted? it would save us some development time/effort to write code to parse the manifest file.
That would be very frustrating. I would highly recommend opening a support ticket or reaching out to your account team to have us investigate this.
If you would like support to investigate your specific issue, you are encouraged to raise a Billing Support Case, in the AWS Console, click on the ? with a circle -> Support Center -> Create Case -> Account and Billing Support. The support folks should be able to investigate your specific account and situation.
Relevant questions
AWS Organization Billing
asked 2 months agoReserved Instance, then become our billing double.
Accepted Answerasked 3 months agoS3 To Glacier Lifecycle configuration - preventing billing shock
Accepted Answerasked 2 years agoIAM -billing access
Accepted Answerasked a year agoTransfer AWS Billing to another account within Organization
asked 6 months agoAWS backups conformance reports are empty
asked 5 months agoWorkspaces billing
Accepted Answerasked 3 years agoAWS Billing Report files are improperly formatted (contains columns with no headers)
asked a month agoBilling data for each day individually
asked 2 months agoAWS Backup DynamoDB billing
asked 2 months ago