Skip to main content

SQL Notes


This is not going to be a full SQL tutorial (expansive topic) but mostly just notes for myself to reference for a specific project, they may be useful for others however. I am going to be working mostly with a partitioned Data Catalog in AWS Athena.

Query a specific partition

SELECT campaignid as "Campaign ID",
campaignname as "Campaign Name",
impressions as "Impressions",
FROM "AwsDataCatalog"."name_of_database"."name_of_table"

WHERE CAST(profile_id as bigint) = 1363579156439011

limit 10;

Automated Amazon Reports

Automatically download Amazon Seller and Advertising reports to a private database. View beautiful, on demand, exportable performance reports.