Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Customer
|   Customer Key |   Geography Key | Customer Alternate Key   | Title   | First Name   | Middle Name   |  Last Name   | Name Style   | Birth Date              | Marital Status   | Suffix   | Gender   | Email Address                   |   Yearly Income |   Total Children |   Number Children At Home | English Education   | Spanish Education                  | French Education   | English Occupation   | Spanish Occupation   | French Occupation   |   House Owner Flag |   Number Cars Owned | Address Line1           | Address Line2   | Phone               | Date First Purchase     | Commute Distance   |
|---------------:|----------------:|:-------------------------|:--------|:-------------|:--------------|:-------------|:-------------|:------------------------|:-----------------|:---------|:---------|:--------------------------------|----------------:|-----------------:|--------------------------:|:--------------------|:-----------------------------------|:-------------------|:---------------------|:---------------------|:--------------------|-------------------:|--------------------:|:------------------------|:----------------|:--------------------|:------------------------|:-------------------|
|          11602 |             135 | AW00011602               |         | Larry        |               | Gill         | False        | 1977-04-13 00:00:00.000 | S                |          | M        | larry16@adventure-works.com     |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | Am Gallberg 645         |                 | 1 (11) 500 555-0125 | 2008-01-11 00:00:00.000 | 2-5 Miles          |
|          11603 |             244 | AW00011603               |         | Geoffrey     |               | Gonzalez     | False        | 1977-02-06 00:00:00.000 | S                |          | M        | geoffrey16@adventure-works.com  |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | 1538 Golden Meadow      |                 | 1 (11) 500 555-0131 | 2006-07-21 00:00:00.000 | 0-1 Miles          |
|          11610 |             269 | AW00011610               |         | Blake        |               | Collins      | False        | 1975-04-23 00:00:00.000 | S                |          | M        | blake47@adventure-works.com     |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | 4519 Lydia Lane         |                 | 1 (11) 500 555-0140 | 2006-07-13 00:00:00.000 | 0-1 Miles          |
|          12517 |             133 | AW00012517               |         | Alexa        |               | Watson       | False        | 1977-08-25 00:00:00.000 | S                |          | F        | alexa0@adventure-works.com      |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | Residenz Straße 98      |                 | 1 (11) 500 555-0191 | 2008-04-21 00:00:00.000 | 2-5 Miles          |
|          12518 |             161 | AW00012518               |         | Jacquelyn    |               | Dominguez    | False        | 1977-09-27 00:00:00.000 | S                |          | F        | jacquelyn13@adventure-works.com |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | Werftstr 544            |                 | 1 (11) 500 555-0134 | 2008-02-02 00:00:00.000 | 2-5 Miles          |
|          12519 |             265 | AW00012519               |         | Casey        |               | Gutierrez    | False        | 1977-12-17 00:00:00.000 | S                |          | M        | casey34@adventure-works.com     |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | 2035 Emmons Canyon Lane |                 | 1 (11) 500 555-0115 | 2007-11-12 00:00:00.000 | 0-1 Miles          |
|          12714 |             157 | AW00012714               |         | Colleen      |               | Lu           | False        | 1973-07-17 00:00:00.000 | S                |          | F        | colleen11@adventure-works.com   |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | Hüttenstr 20995         |                 | 1 (11) 500 555-0174 | 2008-01-20 00:00:00.000 | 2-5 Miles          |
|          12728 |             131 | AW00012728               |         | Jeremiah     |               | Stewart      | False        | 1979-06-26 00:00:00.000 | S                |          | M        | jeremiah44@adventure-works.com  |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | Alte Landstr 9902       |                 | 1 (11) 500 555-0129 | 2007-10-09 00:00:00.000 | 1-2 Miles          |
|          12871 |             233 | AW00012871               |         | Leah         |               | Li           | False        | 1976-10-06 00:00:00.000 | S                |          | F        | leah2@adventure-works.com       |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | 9405 Curletto Dr.       |                 | 1 (11) 500 555-0122 | 2008-05-12 00:00:00.000 | 2-5 Miles          |
|          13671 |             173 | AW00013671               |         | Frank        |               | Ramos        | False        | 1974-02-07 00:00:00.000 | S                |          | M        | frank25@adventure-works.com     |           30000 |                0 |                         0 | Partial College     | Estudios universitarios (en curso) | Baccalauréat       | Clerical             | Administrativo       | Employé             |                  0 |                   1 | Carlsplatz 43           |                 | 1 (11) 500 555-0146 | 2008-07-31 00:00:00.000 | 1-2 Miles          |


Table: Date (Order)
|   DateKey | Date                    |   Day Number Of Week | English Day Name Of Week   | Spanish Day Name Of Week   | French Day Name Of Week   |   Day Number Of Month |   Day Number Of Year |   Week Number Of Year | English Month Name   | Spanish Month Name   | French Month Name   |   Month Number Of Year |   Calendar Quarter |   Year |   Calendar Semester |   Fiscal Quarter |   Fiscal Year |   Fiscal Semester |
|----------:|:------------------------|---------------------:|:---------------------------|:---------------------------|:--------------------------|----------------------:|---------------------:|----------------------:|:---------------------|:---------------------|:--------------------|-----------------------:|-------------------:|-------:|--------------------:|-----------------:|--------------:|------------------:|
|  20050701 | 2005-07-01 00:00:00.000 |                    6 | Friday                     | Viernes                    | Vendredi                  |                     1 |                  182 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050702 | 2005-07-02 00:00:00.000 |                    7 | Saturday                   | Sábado                     | Samedi                    |                     2 |                  183 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050703 | 2005-07-03 00:00:00.000 |                    1 | Sunday                     | Domingo                    | Dimanche                  |                     3 |                  184 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050704 | 2005-07-04 00:00:00.000 |                    2 | Monday                     | Lunes                      | Lundi                     |                     4 |                  185 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050705 | 2005-07-05 00:00:00.000 |                    3 | Tuesday                    | Martes                     | Mardi                     |                     5 |                  186 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050706 | 2005-07-06 00:00:00.000 |                    4 | Wednesday                  | Miércoles                  | Mercredi                  |                     6 |                  187 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050707 | 2005-07-07 00:00:00.000 |                    5 | Thursday                   | Jueves                     | Jeudi                     |                     7 |                  188 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050708 | 2005-07-08 00:00:00.000 |                    6 | Friday                     | Viernes                    | Vendredi                  |                     8 |                  189 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050709 | 2005-07-09 00:00:00.000 |                    7 | Saturday                   | Sábado                     | Samedi                    |                     9 |                  190 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |
|  20050710 | 2005-07-10 00:00:00.000 |                    1 | Sunday                     | Domingo                    | Dimanche                  |                    10 |                  191 |                    29 | July                 | Julio                | Juillet             |                      7 |                  3 |   2005 |                   2 |                1 |          2006 |                 1 |


Table: Date (Ship)
|   DateKey | Date                    |   Day Number Of Week | English Day Name Of Week   | Spanish Day Name Of Week   | French Day Name Of Week   |   Day Number Of Month |   Day Number Of Year |   Week Number Of Year | English Month Name   | Spanish Month Name   | French Month Name   |   Month Number Of Year |   Calendar Quarter |   Year (Ship) |   Calendar Semester |   Fiscal Quarter |   Fiscal Year |   Fiscal Semester |
|----------:|:------------------------|---------------------:|:---------------------------|:---------------------------|:--------------------------|----------------------:|---------------------:|----------------------:|:---------------------|:---------------------|:--------------------|-----------------------:|-------------------:|--------------:|--------------------:|-----------------:|--------------:|------------------:|
|  20050701 | 2005-07-01 00:00:00.000 |                    6 | Friday                     | Viernes                    | Vendredi                  |                     1 |                  182 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050702 | 2005-07-02 00:00:00.000 |                    7 | Saturday                   | Sábado                     | Samedi                    |                     2 |                  183 |                    27 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050703 | 2005-07-03 00:00:00.000 |                    1 | Sunday                     | Domingo                    | Dimanche                  |                     3 |                  184 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050704 | 2005-07-04 00:00:00.000 |                    2 | Monday                     | Lunes                      | Lundi                     |                     4 |                  185 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050705 | 2005-07-05 00:00:00.000 |                    3 | Tuesday                    | Martes                     | Mardi                     |                     5 |                  186 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050706 | 2005-07-06 00:00:00.000 |                    4 | Wednesday                  | Miércoles                  | Mercredi                  |                     6 |                  187 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050707 | 2005-07-07 00:00:00.000 |                    5 | Thursday                   | Jueves                     | Jeudi                     |                     7 |                  188 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050708 | 2005-07-08 00:00:00.000 |                    6 | Friday                     | Viernes                    | Vendredi                  |                     8 |                  189 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050709 | 2005-07-09 00:00:00.000 |                    7 | Saturday                   | Sábado                     | Samedi                    |                     9 |                  190 |                    28 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |
|  20050710 | 2005-07-10 00:00:00.000 |                    1 | Sunday                     | Domingo                    | Dimanche                  |                    10 |                  191 |                    29 | July                 | Julio                | Juillet             |                      7 |                  3 |          2005 |                   2 |                1 |          2006 |                 1 |


Table: Internet Sales
|   ProductKey |   OrderDateKey |   DueDateKey |   ShipDateKey |   CustomerKey |   PromotionKey |   CurrencyKey |   SalesTerritoryKey | Sales Order Number   |   Sales Order Line Number |   Revision Number |   Order Quantity |   Unit Price |   Extended Amount |   Unit Price Discount Pct |   Discount Amount |   Product Standard Cost |   Total Product Cost |   Sales Amount |   Tax Amt |   Freight | Carrier Tracking Number   | Customer PO Number   | Order Date              | DueDate                 | ShipDate                |
|-------------:|---------------:|-------------:|--------------:|--------------:|---------------:|--------------:|--------------------:|:---------------------|--------------------------:|------------------:|-----------------:|-------------:|------------------:|--------------------------:|------------------:|------------------------:|---------------------:|---------------:|----------:|----------:|:--------------------------|:---------------------|:------------------------|:------------------------|:------------------------|
|          528 |       20071229 |     20080110 |      20080105 |         11024 |              1 |           100 |                   4 | SO60998              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2007-12-29 00:00:00.000 | 2008-01-10 00:00:00.000 | 2008-01-05 00:00:00.000 |
|          528 |       20070910 |     20070922 |      20070917 |         11049 |              1 |           100 |                   4 | SO54129              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2007-09-10 00:00:00.000 | 2007-09-22 00:00:00.000 | 2007-09-17 00:00:00.000 |
|          528 |       20080623 |     20080705 |      20080630 |         11086 |              1 |           100 |                   4 | SO73610              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2008-06-23 00:00:00.000 | 2008-07-05 00:00:00.000 | 2008-06-30 00:00:00.000 |
|          528 |       20070920 |     20071002 |      20070927 |         11140 |              1 |           100 |                   4 | SO54694              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2007-09-20 00:00:00.000 | 2007-10-02 00:00:00.000 | 2007-09-27 00:00:00.000 |
|          528 |       20080510 |     20080522 |      20080517 |         11159 |              1 |           100 |                   4 | SO70285              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2008-05-10 00:00:00.000 | 2008-05-22 00:00:00.000 | 2008-05-17 00:00:00.000 |
|          528 |       20080206 |     20080218 |      20080213 |         11163 |              1 |           100 |                   4 | SO63663              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2008-02-06 00:00:00.000 | 2008-02-18 00:00:00.000 | 2008-02-13 00:00:00.000 |
|          528 |       20080206 |     20080218 |      20080213 |         11164 |              1 |           100 |                   4 | SO63662              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2008-02-06 00:00:00.000 | 2008-02-18 00:00:00.000 | 2008-02-13 00:00:00.000 |
|          528 |       20080327 |     20080408 |      20080403 |         11169 |              1 |           100 |                   4 | SO66984              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2008-03-27 00:00:00.000 | 2008-04-08 00:00:00.000 | 2008-04-03 00:00:00.000 |
|          528 |       20080504 |     20080516 |      20080511 |         11188 |              1 |           100 |                   4 | SO69830              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2008-05-04 00:00:00.000 | 2008-05-16 00:00:00.000 | 2008-05-11 00:00:00.000 |
|          528 |       20080719 |     20080731 |      20080726 |         11190 |              1 |           100 |                   4 | SO74750              |                         1 |                 1 |                1 |         4.99 |              4.99 |                         0 |                 0 |                  1.8663 |               1.8663 |           4.99 |    0.3992 |    0.1248 |                           |                      | 2008-07-19 00:00:00.000 | 2008-07-31 00:00:00.000 | 2008-07-26 00:00:00.000 |


Table: Product
|   Product Key | Product Alternate Key   | Product Subcategory Key   | Weight Unit Measure Code   | Size Unit Measure Code   | English Product Name   | Spanish Product Name   | French Product Name   | Standard Cost   | Finished Goods Flag   | Color   |   Safety Stock Level |   Reorder Point | List Price   | Size   | Size Range   | Weight   |   Days To Manufacture | Product Line   | Dealer Price   | Class   | Style   | Model Name   | Large Photo   | English Description   | French Description   | Chinese Description   | Arabic Description   | Hebrew Description   | Thai Description   | German Description   | Japanese Description   | Turkish Description   | Start Date              | End Date   | Status   |
|--------------:|:------------------------|:--------------------------|:---------------------------|:-------------------------|:-----------------------|:-----------------------|:----------------------|:----------------|:----------------------|:--------|---------------------:|----------------:|:-------------|:-------|:-------------|:---------|----------------------:|:---------------|:---------------|:--------|:--------|:-------------|:--------------|:----------------------|:---------------------|:----------------------|:---------------------|:---------------------|:-------------------|:---------------------|:-----------------------|:----------------------|:------------------------|:-----------|:---------|
|             1 | AR-5381                 |                           |                            |                          | Adjustable Race        |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|             2 | BA-8327                 |                           |                            |                          | Bearing Ball           |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            12 | CR-9981                 |                           |                            |                          | Crown Race             |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            14 | DC-8732                 |                           |                            |                          | Decal 1                |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            15 | DC-9824                 |                           |                            |                          | Decal 2                |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            22 | FW-1000                 |                           |                            |                          | Flat Washer 1          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            23 | FW-1200                 |                           |                            |                          | Flat Washer 6          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            24 | FW-1400                 |                           |                            |                          | Flat Washer 2          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            25 | FW-3400                 |                           |                            |                          | Flat Washer 9          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |
|            26 | FW-3800                 |                           |                            |                          | Flat Washer 4          |                        |                       |                 | False                 | NA      |                 1000 |             750 |              |        | NA           |          |                     0 |                |                |         |         |              |               |                       |                      |                       |                      |                      |                    |                      |                        |                       | 1998-06-01 00:00:00.000 |            | Current  |


Table: Sales Territory
|   Sales Territory Key |   SalesTerritoryAlternateKey | Sales Territory Region   | Sales Territory Country   | Sales Territory Group   | Sales Territory Image   |
|----------------------:|-----------------------------:|:-------------------------|:--------------------------|:------------------------|:------------------------|
|                     1 |                            1 | Northwest                | United States             | North America           |                         |
|                     2 |                            2 | Northeast                | United States             | North America           |                         |
|                     3 |                            3 | Central                  | United States             | North America           |                         |
|                     4 |                            4 | Southwest                | United States             | North America           |                         |
|                     5 |                            5 | Southeast                | United States             | North America           |                         |
|                     6 |                            6 | Canada                   | Canada                    | North America           |                         |
|                     7 |                            7 | France                   | France                    | Europe                  |                         |
|                     8 |                            8 | Germany                  | Germany                   | Europe                  |                         |
|                     9 |                            9 | Australia                | Australia                 | Pacific                 |                         |
|                    10 |                           10 | United Kingdom           | United Kingdom            | Europe                  |                         |


Table: Temperature
| Region    | Month   |   MonthNumber | Key         |   Avg Temp | Temperature Range   |
|:----------|:--------|--------------:|:------------|-----------:|:--------------------|
| Northeast | Jan     |             1 | Northeast1  |       26.3 | Cold                |
| Northeast | Feb     |             2 | Northeast2  |       25.4 | Cold                |
| Northeast | Mar     |             3 | Northeast3  |       31.4 | Cold                |
| Northeast | Apr     |             4 | Northeast4  |       48.1 | Cool                |
| Northeast | May     |             5 | Northeast5  |       52.8 | Cool                |
| Northeast | June    |             6 | Northeast6  |       66.8 | Warm                |
| Northeast | Jul     |             7 | Northeast7  |       70.4 | Hot                 |
| Northeast | Aug     |             8 | Northeast8  |       66   | Warm                |
| Northeast | Sep     |             9 | Northeast9  |       61.2 | Warm                |
| Northeast | Oct     |            10 | Northeast10 |       47.2 | Cool                |

 


tables: name: Customer
data: Customer.csv
name: Date (Order)
data: Date (Order).csv
name: Date (Ship)
data: Date (Ship).csv
name: Internet Sales
data: Internet Sales.csv
name: Product
data: Product.csv
name: Sales Territory
data: Sales Territory.csv
name: Temperature
data: Temperature.csv
label: Internet Sales
CustomerKey
Customer
Customer Key
Internet Sales
ProductKey
Product
Product Key
Internet Sales
SalesTerritoryKey
Sales Territory
Sales Territory Key
Internet Sales
Order Date
Date (Order)
Date
Internet Sales
ShipDate
Date (Ship)
Date
output: {
    "joins": [
        {
            "from_table": "Internet Sales",
            "from_column": "CustomerKey",
            "to_table": "Customer",
            "to_column": "Customer Key"
        },
        {
            "from_table": "Internet Sales",
            "from_column": "ProductKey",
            "to_table": "Product",
            "to_column": "Product Key"
        },
        {
            "from_table": "Internet Sales",
            "from_column": "SalesTerritoryKey",
            "to_table": "Sales Territory",
            "to_column": "Sales Territory Key"
        },
        {
            "from_table": "Internet Sales",
            "from_column": "Order Date",
            "to_table": "Date (Order)",
            "to_column": "Date"
        },
        {
            "from_table": "Internet Sales",
            "from_column": "ShipDate",
            "to_table": "Date (Ship)",
            "to_column": "Date"
        }
    ]
}