Skip to content
Permalink
 
 
Cannot retrieve contributors at this time
8 lines (6 sloc) 609 Bytes

dlt-billing-csv-processing-with-aws-athena

Example on how to query DLT csv detailed billing reports with AWS Athena

Contents:

  • create_table_example.sql: Creates a table that matches the column format of a DLT details billing csv file. Due to the potential for quotes, OpenCSVSerde (http://docs.aws.amazon.com/athena/latest/ug/csv.html) must be used. The result is all field values are imported as STRINGS. Conversion of field values to different data types are possible on querying of data.

  • query_example.sql: A sample query to retrieve the first ten 'LineItem' rows found in the database.

You can’t perform that action at this time.