Free Delivery

Overview

Assign Free Delivery promotion to large set of customers

Repository

Free Delivery

Google Forms

The 1st step of Free Delivery app is to upload of CSV file containing CustomerIds into BigQuery table.

Below Google Form can be used for it.

https://docs.google.com/forms/d/1iUt8Auk9bj9rfAa3oxOd-azHvjCEOCv5Gh4zu0xFcPQ

When the data are uploaded into BigQuery table, then the 2nd step is to trigger Step Functions execution which get data from BigQuery table and process CustomerIds assigning them Free Delivery promotion.

Support Documents

Technical Design

How to process Free Delivery semi-manually

Useful scripts

Useful scripts for debugging issues of this project are placed in Support Scripts repo.

Repo: Support Scripts

Especially script aws_insights_query.py is useful for analysis mixing, sorting by timestampe and analysing of logs of related multiple CloudWatch log groups.

Config file

It requires authentication using API KEY:

Path to Config File

Related CloudWatch Log Groups

"/aws/lambda/lmb-euw1-{env}-strpck-bigquery_get_data-001",
"/aws/lambda/lmb-euw1-{env}-strpck-bigquery_update_data-001",
"/aws/lambda/lmb-euw1-{env}-strpck-freedelivery_generate_input-001",
"/aws/lambda/lmb-euw1-{env}-strpck-freedelivery_generate_output-001",
"/aws/lambda/lmb-euw1-{env}-strpck-freedelivery_initialize-001",
"/aws/lambda/lmb-euw1-{env}-strpck-osp_add_customers_to_group-001",
"/aws/lambda/lmb-euw1-{env}-strpck-osp_create_customer_group-001",
"/aws/lambda/lmb-euw1-{env}-strpck-osp_create_or_update_promotion-001",
"/aws/lambda/lmb-euw1-{env}-strpck-osp_filter_customers-001",
"/aws/lambda/lmb-euw1-{env}-strpck-event_writer-001",

JIRA tickets

Main story - SPDP-2135

Business story - SPDP-2138

Known BigQuery slow update defect - SPDP-2446