https://github.com/johnny-chivers/pyspark-glue-tutorial
customers
id,firstname,lastname,fullname
293,Catherine,Abel,Catherine Abel
295,Kim,Abercrombie,Kim Abercrombie
297,Humberto,Acevedo,Humberto Acevedo
291,Gustavo,Achong,Gustavo Achong
299,Pilar,Ackerman,Pilar Ackerman
305,Carla,Adams,Carla Adams
301,Frances,Adams,Frances Adams
307,Jay,Adams,Jay Adams
309,Ronald,Adina,Ronald Adina
311,Samuel,Agcaoili,Samuel Agcaoili
313,James,Aguilar,James Aguilar
315,Robert,Ahlering,Robert Ahlering
319,Kim,Akers,Kim Akers
441,Stanley,Alan,Stanley Alan
323,Amy,Alberts,Amy Alberts
325,Anna,Albright,Anna Albright
327,Milton,Albury,Milton Albury
329,Paul,Alcorn,Paul Alcorn
orders
sales_order_id,sales_order_detail_id,order_date,due_date,ship_date,employee_id,customer_id,sub_total,tax_amt,freight,total_due,product_id,order_qty,unit_price,unit_price_discount,line_total
43659,1,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,776,1,2024.994,0,2024.994
43659,2,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,777,3,2024.994,0,6074.982
43659,3,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,778,1,2024.994,0,2024.994
43659,4,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,771,1,2039.994,0,2039.994
43659,5,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,772,1,2039.994,0,2039.994
43659,6,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,773,2,2039.994,0,4079.988
43659,7,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,774,1,2039.994,0,2039.994
43659,8,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,714,3,28.8404,0,86.5212
43659,9,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,716,1,28.8404,0,28.8404
43659,10,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,709,6,5.7,0,34.2
43659,11,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,712,2,5.1865,0,10.373
43659,12,5/31/2011,6/12/2011,6/7/2011,279,1045,20565.6206,1971.5149,616.0984,23153.2339,711,4,20.1865,0,80.746
43660,13,5/31/2011,6/12/2011,6/7/2011,279,721,1294.2529,124.2483,38.8276,1457.3288,762,1,419.4589,0,419.4589
43660,14,5/31/2011,6/12/2011,6/7/2011,279,721,1294.2529,124.2483,38.8276,1457.3288,758,1,874.794,0,874.794
employees
employee_id,manager_id,firstname,lastname,fullname,job_title,organization_level,martial_status,gender,territory,country,group
274,NULL,Stephen,Jiang,Stephen Jiang,North American Sales Manager,2,M,M,NULL,NULL,NULL
275,274,Michael,Blythe,Michael Blythe,Sales Representative,3,S,M,Northeast,US,North America
276,274,Linda,Mitchell,Linda Mitchell,Sales Representative,3,M,F,Southwest,US,North America
277,274,Jillian,Carson,Jillian Carson,Sales Representative,3,S,F,Central,US,North America
278,274,Garrett,Vargas,Garrett Vargas,Sales Representative,3,M,M,Canada,CA,North America
279,274,Tsvi,Reiter,Tsvi Reiter,Sales Representative,3,M,M,Southeast,US,North America
280,274,Pamela,Ansman-Wolfe,Pamela Ansman-Wolfe,Sales Representative,3,S,F,Northwest,US,North America
281,274,Shu,Ito,Shu Ito,Sales Representative,3,M,M,Southwest,US,North America
282,274,Josh,Saraiva,Josh Saraiva,Sales Representative,3,M,M,Canada,CA,North America
283,274,David,Campbell,David Campbell,Sales Representative,3,S,M,Northwest,US,North America
284,274,Tete,Mensa-Annan,Tete Mensa-Annan,Sales Representative,3,M,M,Northwest,US,North America
285,NULL,Syed,Abbas,Syed Abbas,Pacific Sales Manager,2,M,M,NULL,NULL,NULL
286,285,Lynn,Tsoflias,Lynn Tsoflias,Sales Representative,3,S,F,Australia,AU,Pacific
287,NULL,Amy,Alberts,Amy Alberts,European Sales Manager,2,M,F,NULL,NULL,NULL
288,287,Rachel,Valdez,Rachel Valdez,Sales Representative,3,S,F,Germany,DE,Europe
289,287,Jae,Pak,Jae Pak,Sales Representative,3,M,F,United Kingdom,GB,Europe
290,287,Ranjit,Varkey Chudukatil,Ranjit Varkey Chudukatil,Sales Representative,3,S,M,France,FR,Europe
Customers | Customerid | Firstname | Lastname| Fullname | | ———– | ———– |———–|———–| | 293 | Catherine | Abel | Catherine Abel | | 295 | Kim | Abercrombie | Kim Abercrombie | | 297 | Humberto | Acevedo | Humberto Acevedo |
Orders
| SalesOrderID | SalesOrderDetailID | OrderDate | DueDate | ShipDate | EmployeeID | CustomerID | SubTotal | TaxAmt | Freight | TotalDue | ProductID | OrderQty | UnitPrice | UnitPriceDiscount | LineTotal |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71782 | 110667 | 5/1/2014 | 5/13/2014 | 5/8/2014 | 276 | 293 | 33319.986 | 3182.8264 | 994.6333 | 37497.4457 | 714 | 3 | 29.994 | 0 | 89.982 |
| 44110 | 1732 | 8/1/2011 | 8/13/2011 | 8/8/2011 | 277 | 295 | 16667.3077 | 1600.6864 | 500.2145 | 18768.2086 | 765 | 2 | 419.4589 | 0 | 838.9178 |
| 44131 | 2005 | 8/1/2011 | 8/13/2011 | 8/8/2011 | 275 | 297 | 20514.2859 | 1966.5222 | 614.5382 | 23095.3463 | 709 | 6 | 5.7 | 0 | 34.2 |
Employees
| EmployeeID | ManagerID | FirstName | LastName | FullName | JobTitle | OrganizationLevel | MaritalStatus | Gender | Territory | Country | Group |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 276 | 274 | Linda | Mitchell | Linda Mitchell | Sales Representative | 3 | M | F | Southwest | US | North America |
| 277 | 274 | Jillian | Carson | Jillian Carson | Sales Representative | 3 | S | F | Central | US | North America |
| 275 | 274 | Michael | Blythe | Michael Blythe | Sales Representative | 3 | S | M | Northeast | US | North America |