Amazon SageMaker, Athena 및 Quick을 활용한 에이전틱 AI 분석 구현

CREATE EXTERNAL TABLE IF NOT EXISTS blog_qs_athena_tpc_h_db_sql.customer_csv (
 C_CUSTKEY INT,
 C_NAME STRING,
 C_ADDRESS STRING,
 C_NATIONKEY INT,
 C_PHONE STRING,
 C_ACCTBAL DOUBLE,
 C_MKTSEGMENT STRING,
 C_COMMENT STRING
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
STORED AS TEXTFILE
LOCATION 's3://redshift-downloads/TPC-H/2.18/100GB/customer/'
TBLPROPERTIES ('classification' = 'csv');

CREATE TABLE blog_qs_athena_tpc_h_db_sql.orders_iceberg
WITH (
 table_type = 'ICEBERG',
 format = 'PARQUET',
 is_external = false,
 partitioning = ARRAY['o_orderdate'],
 location = 's3://amzn-s3-demo-bucket/tpch_iceberg/orders/')
AS SELECT * FROM blog_qs_athena_tpc_h_db_sql.orders_csv
WHERE O_ORDERDATE BETWEEN '1998-06-01' AND '1998-12-31';