Skip to main content

SQL Notes

Intro

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",
profile_id
FROM "AwsDataCatalog"."name_of_database"."name_of_table"

WHERE CAST(profile_id as bigint) = 1363579156439011

limit 10;

Recent Work

Free desktop AI Chat client, designed for developers and businesses. Unlocks advanced model settings only available in the API. Includes quality of life features like custom syntax highlighting.

Learn More
slide-6
slide-5
slide-2
slide-1
slide-3
slide-4
Technologies Used
TypeScript
Electron
React

BidBear

bidbear.io

Bidbear is a report automation tool. It downloads Amazon Seller and Advertising reports, daily, to a private database. It then merges and formats the data into beautiful, on demand, exportable performance reports.

Learn More
slide-1
slide-2
slide-5
slide-3
slide-4

Technologies Used

Front End
JavaScript
Docker
React
Redux
Vite
Next
Docusaurus
Stripe
Sentry
D3
React-Flow
TipTap
Back End
JavaScript
Python
AWS CognitoCognito
AWS API GatewayAPI Gateway
AWS LambdaLambda
AWS AthenaAthena
AWS GlueGlue
AWS Step FunctionsStep Functions
AWS SQSSQS
AWS DynamoDBDynamo DB
AWS S3S3
AWS CloudwatchCloudWatch
AWS CloudFrontCloudFront
AWS Route 53Route 53
AWS EventBridgeEventBridge