Why AWS Athena?
Amazon Athena is an interactive query service provided by Amazon Web Services (AWS) that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. It simplifies the process of analyzing large-scale datasets stored in S3 by allowing users to execute SQL queries directly against their data without the need for complex ETL (Extract, Transform, Load) processes. This service is designed to provide quick insights from data stored in Amazon S3, offering a flexible and cost-effective solution for data analysis. Our ERPL connector enhances this capability by seamlessly integrating SAP data with Athena, enabling efficient analytics and data processing directly from SAP systems into the scalable environment of AWS.
Replicate you SAP data to AWS S3
In the first step following our tutorial SAP Integration in AWS Athena for creating a SAP data extract in AWS S3.
Query your SAP data using AWS Athena
Simply apply the following query for your SAP data extract:
CREATE EXTERNAL TABLE IF NOT EXISTS sflights (
`year` SMALLINT,
`month` SMALLINT,
`day_of_month` SMALLINT,
`flight_date` STRING,
`op_unique_carrier` STRING,
`flight_num` STRING,
`origin` STRING,
`destination` STRING,
`crs_dep_time` STRING,
`dep_time` STRING,
`dep_delay` DOUBLE,
`taxi_out` DOUBLE,
`wheels_off` STRING,
`arr_delay` DOUBLE,
`cancelled` DOUBLE,
`cancellation_code` STRING,
`diverted` DOUBLE,
`air_time` DOUBLE,
`carrier_delay` DOUBLE,
`weather_delay` DOUBLE,
`nas_delay` DOUBLE,
`security_delay` DOUBLE,
`late_aircraft_delay` DOUBLE
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
ESCAPED BY '"'
LINES TERMINATED BY 'n'
LOCATION 's3://[YOUR BUCKET]/sflight.parquet'
TBLPROPERTIES (
'skip.header.line.count'='1',
'serialization.null.format'=''
);With one line of code your SAP data is placed on AWS Athena. Happy analyzing.