Example on how to process DLT csv detailed billing reports with AWS Athena
Switch branches/tags
Nothing to show
Latest commit c581131 Dec 11, 2017
Paul Crum
Paul Crum First write-up
Permalink
Failed to load latest commit information.
README.md First write-up Dec 11, 2017
create_table_example.sql First write-up Dec 11, 2017
query_example.sql First write-up Dec 11, 2017

README.md

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.