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: Date Buckets
|   DateKey |   SelectedSortOrder | Selected Days   |
|----------:|--------------------:|:----------------|
|  20401231 |                   0 | Future          |
|  20401230 |                   0 | Future          |
|  20401229 |                   0 | Future          |
|  20401228 |                   0 | Future          |
|  20401227 |                   0 | Future          |
|  20401226 |                   0 | Future          |
|  20401225 |                   0 | Future          |
|  20401224 |                   0 | Future          |
|  20401223 |                   0 | Future          |
|  20401222 |                   0 | Future          |


Table: Date
|   DateKey |   SeqDayNumber | Date                    |   Day Number | Day Name   | Day Abbreviation   |   Day of Week |   Day of Month | Day of Month Name   |   Day of Quarter |   Day of Year | Day of Year Name   |   Week of Year |   CalendarWeekKey |   CalendarMonthKey |   Month Number | Month Name   | Month Name (Short)   |   CalendarQuarterKey |   Quarter Number | Quarter Name   |   Year |   SeqCalendarWeekNumber |   SeqCalendarMonthNumber |   SeqCalendarQuarterNumber |   Number of Days in Month | US Holiday   | US Holiday Name   | Biz Day   | Current Date   |   Day Occurence of Month |
|----------:|---------------:|:------------------------|-------------:|:-----------|:-------------------|--------------:|---------------:|:--------------------|-----------------:|--------------:|:-------------------|---------------:|------------------:|-------------------:|---------------:|:-------------|:---------------------|---------------------:|-----------------:|:---------------|-------:|------------------------:|-------------------------:|---------------------------:|--------------------------:|:-------------|:------------------|:----------|:---------------|-------------------------:|
|  20070112 |           6222 | 2007-01-12 00:00:00.000 |            5 | Friday     | Fri                |             6 |             12 | Day 12              |               12 |            12 | Day 12             |              2 |            200702 |             200701 |              1 | Jan - 2007   | January              |               200701 |                1 | Q1 2007        |   2007 |                     905 |                      206 |                         70 |                        31 | False        |                   | True      | False          |                        2 |
|  20070309 |           6278 | 2007-03-09 00:00:00.000 |            5 | Friday     | Fri                |             6 |              9 | Day 9               |               68 |            68 | Day 68             |             10 |            200710 |             200703 |              3 | Mar - 2007   | March                |               200701 |                1 | Q1 2007        |   2007 |                     913 |                      208 |                         70 |                        31 | False        |                   | True      | False          |                        2 |
|  20070511 |           6341 | 2007-05-11 00:00:00.000 |            5 | Friday     | Fri                |             6 |             11 | Day 11              |               41 |           131 | Day 131            |             19 |            200719 |             200705 |              5 | May - 2007   | May                  |               200702 |                2 | Q2 2007        |   2007 |                     922 |                      210 |                         71 |                        31 | False        |                   | True      | False          |                        2 |
|  20070713 |           6404 | 2007-07-13 00:00:00.000 |            5 | Friday     | Fri                |             6 |             13 | Day 13              |               13 |           194 | Day 194            |             28 |            200728 |             200707 |              7 | Jul - 2007   | July                 |               200703 |                3 | Q3 2007        |   2007 |                     931 |                      212 |                         72 |                        31 | False        |                   | True      | False          |                        2 |
|  20070810 |           6432 | 2007-08-10 00:00:00.000 |            5 | Friday     | Fri                |             6 |             10 | Day 10              |               41 |           222 | Day 222            |             32 |            200732 |             200708 |              8 | Aug - 2007   | August               |               200703 |                3 | Q3 2007        |   2007 |                     935 |                      213 |                         72 |                        31 | False        |                   | True      | False          |                        2 |
|  20071012 |           6495 | 2007-10-12 00:00:00.000 |            5 | Friday     | Fri                |             6 |             12 | Day 12              |               12 |           285 | Day 285            |             41 |            200741 |             200710 |             10 | Oct - 2007   | October              |               200704 |                4 | Q4 2007        |   2007 |                     944 |                      215 |                         73 |                        31 | False        |                   | True      | False          |                        2 |
|  20071214 |           6558 | 2007-12-14 00:00:00.000 |            5 | Friday     | Fri                |             6 |             14 | Day 14              |               75 |           348 | Day 348            |             50 |            200750 |             200712 |             12 | Dec - 2007   | December             |               200704 |                4 | Q4 2007        |   2007 |                     953 |                      217 |                         73 |                        31 | False        |                   | True      | False          |                        2 |
|  20080111 |           6586 | 2008-01-11 00:00:00.000 |            5 | Friday     | Fri                |             6 |             11 | Day 11              |               11 |            11 | Day 11             |              2 |            200802 |             200801 |              1 | Jan - 2008   | January              |               200801 |                1 | Q1 2008        |   2008 |                     958 |                      218 |                         74 |                        31 | False        |                   | True      | False          |                        2 |
|  20080314 |           6649 | 2008-03-14 00:00:00.000 |            5 | Friday     | Fri                |             6 |             14 | Day 14              |               74 |            74 | Day 74             |             11 |            200811 |             200803 |              3 | Mar - 2008   | March                |               200801 |                1 | Q1 2008        |   2008 |                     967 |                      220 |                         74 |                        31 | False        |                   | True      | False          |                        2 |
|  20080509 |           6705 | 2008-05-09 00:00:00.000 |            5 | Friday     | Fri                |             6 |              9 | Day 9               |               39 |           130 | Day 130            |             19 |            200819 |             200805 |              5 | May - 2008   | May                  |               200802 |                2 | Q2 2008        |   2008 |                     975 |                      222 |                         75 |                        31 | False        |                   | True      | False          |                        2 |


Table: Event Sponsorship
|   SQLSaturdayEventSponsorID |   SQLSaturdayEventID |   SQLSaturdaySponsorID | Sponsorship Type   | Sponsorship Level   |   SponsorshipLevelNum |
|----------------------------:|---------------------:|-----------------------:|:-------------------|:--------------------|----------------------:|
|                          22 |                    2 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                          43 |                    5 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                          54 |                    7 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                          83 |                    9 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                         118 |                   13 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                         133 |                   14 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                         188 |                   22 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                         212 |                   26 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                         269 |                   29 |                   1177 | Gold Sponsor       | Gold                |                     3 |
|                         305 |                   32 |                   1177 | Gold Sponsor       | Gold                |                     3 |


Table: Event
|   SQLSaturdayEventID |   Event Number | Event Name                           |   AttendeeEstimate | Start Date              |   StartDateKey | Time Zone   | Event Description                                                                                         | Twitter Hashtag   | Venue Name                                  | Venue Street                 | Venue City      | Venue State   |   Venue Zip Code | Venue Country   |   Venue Latitude |   Venue Longitude |   SubmittedSessionCount | Event Status   | Event Type   | Attended Event   | Volunteered Event   |
|---------------------:|---------------:|:-------------------------------------|-------------------:|:------------------------|---------------:|:------------|:----------------------------------------------------------------------------------------------------------|:------------------|:--------------------------------------------|:-----------------------------|:----------------|:--------------|-----------------:|:----------------|-----------------:|------------------:|------------------------:|:---------------|:-------------|:-----------------|:--------------------|
|                   41 |             41 | SQLSaturday #41 - Atlanta 2010       |                250 | 2010-04-24 00:00:00.000 |       20100424 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat41         | Microsoft                                   | 1125 Sanctuary Parkway       | Alpharetta      | GA            |            30009 | United States   |          34.0693 |          -84.2964 |                      58 | Past/Present   | Standard     | False            | False               |
|                   51 |             51 | SQLSaturday #51 - Nashville 2010     |                250 | 2010-08-21 00:00:00.000 |       20100821 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat51         | 120 White Bridge Road                       |                              | Nashville       | TN            |            37209 | United States   |          36.1564 |          -86.8464 |                     111 | Past/Present   | Standard     | False            | False               |
|                   52 |             52 | SQLSaturday #52 - Colorado 2010      |                250 | 2010-09-25 00:00:00.000 |       20100925 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat52         | Cherry Creek Presbyterian Church            | 10150 E Belleview Ave        | Englewood       | CO            |            80111 | United States   |          39.623  |         -104.871  |                      57 | Past/Present   | Standard     | False            | False               |
|                   55 |             55 | SQLSaturday #55 - San Diego 2010     |                250 | 2010-09-18 00:00:00.000 |       20100918 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat55         | Provide Commerce                            | 4830 Eastgate Mall           | San Diego       | CA            |            92121 | United States   |          32.883  |         -117.205  |                      24 | Past/Present   | Standard     | False            | False               |
|                   62 |             62 | SQLSaturday #62 - Tampa 2011         |                250 | 2011-01-15 00:00:00.000 |       20110115 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat62         | K-Force                                     | 1001 E Palm Ave              | Tampa           | FL            |            33605 | United States   |          27.9613 |          -82.4493 |                     106 | Past/Present   | Standard     | False            | False               |
|                   68 |             68 | SQLSaturday #68 - Olympia 2011       |                250 | 2011-04-09 00:00:00.000 |       20110409 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat68         | South Puget Sound Community College         | 2011 Mottman Road SW         | Olympia         | WA            |            98512 | United States   |          47.0031 |         -122.921  |                      55 | Past/Present   | Standard     | False            | False               |
|                   70 |             70 | SQLSaturday #70 - Columbia 2011      |                250 | 2011-03-19 00:00:00.000 |       20110319 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat70         | Midlands Technical College - Airport Campus | 1260 Lexington Dr            | West Columbia   | SC            |            29170 | United States   |          33.9517 |          -81.1162 |                      92 | Past/Present   | Standard     | False            | False               |
|                   73 |             73 | SQLSaturday #73 - Orange County 2011 |                250 | 2011-04-09 00:00:00.000 |       20110409 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat73         | Golden West College                         | 15744 Goldenwest St          | Orange Township | PA            |            92647 | United States   |          41.0704 |          -76.42   |                      54 | Past/Present   | Standard     | False            | False               |
|                   77 |             77 | SQLSaturday #77 - Pensacola 2011     |                250 | 2011-06-04 00:00:00.000 |       20110604 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat77         | Pensacola Junior College, Main Campus       | 1000 College Blvd, Pensacola | Pensacola       | FL            |            32504 | United States   |          30.4904 |          -87.2053 |                      97 | Past/Present   | Standard     | False            | False               |
|                   81 |             81 | SQLSaturday #81 - Birmingham 2011    |                250 | 2011-07-30 00:00:00.000 |       20110730 | -05:00      | SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. | #sqlsat81         | Jefferson State Community College           | 4600 Valleydale Rd           | Birmingham      | AL            |            35242 | United States   |          33.3856 |          -86.7335 |                      61 | Past/Present   | Standard     | False            | False               |


Table: Session Speaker
|   SQLSaturdaySessionSpeakerID |   SQLSaturdaySessionID |   SQLSaturdaySpeakerID |
|------------------------------:|-----------------------:|-----------------------:|
|                            20 |                     -1 |                   1263 |
|                            21 |                     -1 |                   3073 |
|                            42 |                     -1 |                   2172 |
|                            90 |                     -1 |                   1318 |
|                            94 |                     -1 |                   2067 |
|                           113 |                     -1 |                    959 |
|                           124 |                     -1 |                   4061 |
|                           125 |                     -1 |                   1987 |
|                           134 |                     -1 |                   2786 |
|                           148 |                     -1 |                    405 |


Table: Session
|   SQLSaturdaySessionID |   SQLSaturdayEventID |   Event Number | Track   | Location   | Session Name                                      | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Start Time   | End Time   |   Duration (min) | Start Time (24h)   | End Time (24h)   | Track Type   | Attended Session   |   SessionNumber |
|-----------------------:|---------------------:|---------------:|:--------|:-----------|:--------------------------------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------|:-----------|-----------------:|:-------------------|:-----------------|:-------------|:-------------------|----------------:|
|                   4428 |                  162 |            162 | Track 1 | N/A        | SQL 2012 Always On-Deep Dive                      | Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits. During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery. This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.                                                              | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |           11522 |
|                   4430 |                  162 |            162 | Track 1 | N/A        | Windows Azure from a Data Perspective             | Windows Azure is an incredibly large set of features that technical professionals can use to solve almost any computing need. With that breadth of features, what can the data professional use to help their organizations with small, disconnected datasets all the way to "Big Data"? Buck Woody, Senior Technical Professional on the Windows Azure Platform at Microsoft and a technical professional with close to 30 years of data implementations shows you what you need to know to leverage Windows Azure from a data perspective - when to use it, when to leave your data on-site, and how to create hybrid solutions that encompass both architectures. | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |           15348 |
|                   4431 |                  162 |            162 | Track 1 | N/A        | Intro to Tabular Model in Analysis Services 2012  | The Tabular model in Analysis Services 2012 is the new alternative to building cubes: it’s easier to develop with (especially if you come from a relational database background) and its in-memory, column-store database provides blindingly fast performance. This session will provide a basic introduction to building Tabular models and discuss their strengths and weaknesses compared to cubes.                                                                                                                                                                                                                                                              | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |            7024 |
|                   4432 |                  162 |            162 | Track 1 | N/A        | Session Details not available                     | Session Details not available                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |           11204 |
|                   4440 |                  162 |            162 | Track 1 | N/A        | Mobile Business Intelligence for Everyone, Now!   | Microsoft has made serious commitments to mobile Business Intelligence, announced at SQLPass Summit 2011. What is the roadmap?  What's available right now, and how can it be implemented at your organisation?                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |            8595 |
|                        |                      |                |         |            |                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | Come to this session to learn about mobilising Business Intelligence using Sharepoint, Reporting Services, SQL Azure, Excel Services and Power Pivot. Yes, it is possible to have mobile Business Intelligence in your organisation, and come to this session in order to learn how!                                                                                                                                                                                                                                                                                                                                                                                 |              |            |                  |                    |                  |              |                    |                 |
|                   4453 |                  162 |            162 | Track 1 | N/A        | T-SQL : Bad Habits and Best Practices             | In this session we will go over several bad habits that are quite                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |           14205 |
|                        |                      |                |         |            |                                                   | pervasive in the SQL Server community, and show with demos and samples why                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | these habits can be bad.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   |   We'll also illustrate some good habits that are less common and why they                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | should be adopted.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   |   The goal is to have every user in the room walk away with immediately                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | actionable knowledge to improve their existing stored procedures, raise                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | their overall T-SQL skill, and change the way they think about writing                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | code.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |              |            |                  |                    |                  |              |                    |                 |
|                   4455 |                  162 |            162 | Track 1 | N/A        | SQL Server 2012 SSIS Change Data Capture          | We are storing more and more data FACT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |           11916 |
|                        |                      |                |         |            |                                                   | We have less time to move data around our environment FACT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | Businesses want close to real-time analytics FACT.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |              |            |                  |                    |                  |              |                    |                 |
|                        |                      |                |         |            |                                                   | We therefore need to plan our data movement strategy better.  In this session I will show you the improvements to CDC being made in SQL Server 2012 and suggest why this is something you will want to know.                                                                                                                                                                                                                                                                                                                                                                                                                                                         |              |            |                  |                    |                  |              |                    |                 |
|                   4457 |                  162 |            162 | Track 1 | N/A        | Designing an SSIS Framework                       | In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.                                                                                                                               | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |            4450 |
|                   6992 |                  259 |            259 | Track 1 | N/A        | Top 10 Performance Tips for SQL Server Developers | Performance of a SQL Server depends on many factors and due to the nature of development SQL Server developers sometimes miss basic performance tips. Easily implemented tips such as using an appropriate index or solving a data mismatch problem on where conditions could affect the application performance significantly. In this session, we will cover the top 10 tips to improve the performance of your SQL Server with real life examples.                                                                                                                                                                                                                | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |           13997 |
|                   6996 |                  259 |            259 | Track 1 | N/A        | In-Memory OLTP (Hekaton) в SQL Server 2014        | Одно из самых ожидаемых нововведений в SQL Server 2014 - это технология In-Memory OLTP, ранее известная под кодовым именем Hekaton. В этом докладе мы подробно рассмотрим ее архитектуру, особенности и ограничения. Также уделим внимание некоторым аспектам практического применения In-Memory OLTP.                                                                                                                                                                                                                                                                                                                                                               | 12:00 AM     | 01:00 AM   |               60 | 00:00              | 01:00            | Other        | False              |            6787 |


Table: Speaker
|   SQLSaturdaySpeakerID | Speaker Name        | Label   | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Twitter   | LinkedIn   | Contact URL   | Image URL                                                  |
|-----------------------:|:--------------------|:--------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------|:-----------|:--------------|:-----------------------------------------------------------|
|                     10 | Aaron Kruger        |         | Aaron Kruger serves as the Compliance Coordinator for Netchex. He has over 30 years of experience in securing classified and sensitive information in the military, public and private sectors. He is a certified HIPAA Compliance Officer and worked as a compliance consultant in the healthcare industry until he joined Netchex in 2018.                                                                                                                                                                        |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                     13 | Aaron Rigney        |         | Aaron Rigney is a Consulting Systems Engineer for Cisco focusing on datacenter technologies including UCS, Nexus, and Invicta solutions.                                                                                                                                                                                                                                                                                                                                                                            |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                     15 | Aashish Parekh      |         | Aashish Parekh is a consultant with Pariveda Solutions, where he plans, architects and delivers end-to-end Business Intelligence platforms for clients across a variety of industries in the Houston area. His areas of expertise include large-scale Enterprise Data Warehouses, ETL, Analytics, Reporting and Data Visualization. His deployed solutions span several technologies, including the Microsoft SQL Server BI stack as well as Oracle, SAP, Microstrategy, Informatica, Talend, QlikView and Tableau. |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                     18 | Abdullah Mamun      |         | I am the lead for SQL Server on Azure VM support at Microsoft.                                                                                                                                                                                                                                                                                                                                                                                                                                                      |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                     21 | Abhishek Srivastava |         | I have a total of 16 years of experience in IT. I work as a SharePoint architect Goldman Sachs. As a sharepoint architect, I has configured PowerPivot, PowerView and SSRS on SharePoint 2013. I also own the SQL Server infrastrcture for our multi-TB SharePoint farm. I engineered the resiliency, DR, Disk and Backup infrastructure for our SharePoint farm.                                                                                                                                                   |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                        |                     |         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |           |            |               |                                                            |
|                        |                     |         | I have extensive experience in SSAS, SSRS, SSIS, and Data Warehousing on SQL Server                                                                                                                                                                                                                                                                                                                                                                                                                                 |           |            |               |                                                            |
|                     22 | Abi Chapagai        |         | I am a Database Administrator at CR software in Fairfax, VA. I have 7 years of IT experience and about 6 years in Relational Database Management System, focusing in Microsoft SQL Server. I am Microsoft Certified IT Professional (MCITP 2005 Database Administrator). I enjoy learning SQL Server Internals, volunteer for the 2010 DC SQLSaturday.                                                                                                                                                              |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                     26 | Adam Aspin          |         | Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for nineteen years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite.                                                                                                                                                                                                                                             |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                        |                     |         | He is the author of quot;High Impact Data Visualization with Power View, Power Map, and Power BIquot;, “SQL Server Data Integration Recipes” and quot;Business Intelligence with SQL Server Reporting Servicesquot; - all with Apress                                                                                                                                                                                                                                                                               |           |            |               |                                                            |
|                     37 | Adam Marczak        |         | Azure Cloud Architect working at Lingaro. Passionate .NET developer and Azure evangelist. For many years delivering solutions in FMCG for global scale clients. Since 2014 working primarly in Azure and Cloud specific projects as a developer, tech leader and architect. In spare time writing on his personal blog and recently YouTube channel dedicated to Azure technologies.                                                                                                                                |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                     47 | Adi Cohn            |         | Work as a SQL Server DBA since 1997                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |
|                     51 | Adrian Chacon       |         | Adrian Chacon is a recent graduate who has a solid background in Hardware Design but has adopted the lifestyle of a Business Intelligence Developer. Throughout his educational career, he’s picked up an assortment of computer languages including HTML, Verilog, CSS, C, C#, Java, and Objective-C. Adrian received his bachelor’s degree in Electrical Engineering and his Master’s degree in Computer Engineering.                                                                                             |           |            |               | https://api.twitter.com/1/users/profile_image?screen_name= |


Table: Sponsor
|   SQLSaturdaySponsorID | Sponsor Name                             | Website                                                 | Image URL                                                                                               |
|-----------------------:|:-----------------------------------------|:--------------------------------------------------------|:--------------------------------------------------------------------------------------------------------|
|                      1 | #978 Cappuccino Insurance                | https://www.cappuccinoinsurance.com                     | https://sqlsaturdayfiles.blob.core.windows.net/978/EventSponsor_14519.jpg                               |
|                      2 | ????? ?????????? ????????                | http://usk.ru/                                          | https://i33.fastpic.ru/big/2014/0401/f5/20ec7141fb357e9143ba4f5b166172f5.jpg                            |
|                      3 | @Bill_Pearson (Island Technologies Inc.) | http://digital-duke.com                                 | https://digital-duke.com/wp-content/Digital-Duke.com/WhiteBak.jpg                                       |
|                      4 | @retracement                             | http://tenbulls.co.uk                                   | https://www.pass.org/files/c22db5eb-2516-4e4d-9740-b2a3f6b52b3e.png                                     |
|                      5 | @SQLBeat                                 | http://www.simple-talk.com/blogs/author/195835-sqlbeat/ | https://www.pass.org/files/1bd39ff4-0af3-49fa-8ce7-977d7d0adc6e.PNG                                     |
|                      6 | 1102 GRAND                               | http://www.1102Grand.com                                | https://www.carrierhotels.com/images/uploads/1102grand_logo2.jpg                                        |
|                      7 | 1nn0va                                   | http://www.innovazionefvg.net/                          | https://mug0.assets-yammer.com/mugshot/images/x100/xPGz5QWw87dDQzpGlTR36ggrFrRgB3q-?allow_upscale=false |
|                      8 | 1stidea                                  | http://www.1stidea.pt                                   | https://www.pass.org/files/043e7c50-0a06-4244-b54c-3755931ba37d.jpg                                     |
|                      9 | 2PC                                      | http://www.2pc.com.br                                   | https://www.2pc.com.br/wp-content/themes/brandnew/images/black/logo2.png                                |
|                     10 | 3 Business                               | http://www.3.dk/Business/Losninger/3Business/           | https://www.sqlsug.dk/sponsors/3_Business_Logo.png                                                      |

 


tables: name: Date Buckets
data: Date Buckets.csv
name: Date
data: Date.csv
name: Event Sponsorship
data: Event Sponsorship.csv
name: Event
data: Event.csv
name: Session Speaker
data: Session Speaker.csv
name: Session
data: Session.csv
name: Speaker
data: Speaker.csv
name: Sponsor
data: Sponsor.csv
label: Date Buckets
DateKey
Date
DateKey
Event
StartDateKey
Date
DateKey
Session
SQLSaturdayEventID
Event
SQLSaturdayEventID
Session Speaker
SQLSaturdaySpeakerID
Speaker
SQLSaturdaySpeakerID
Session Speaker
SQLSaturdaySessionID
Session
SQLSaturdaySessionID
Event Sponsorship
SQLSaturdayEventID
Event
SQLSaturdayEventID
Event Sponsorship
SQLSaturdaySponsorID
Sponsor
SQLSaturdaySponsorID
output: {
    "joins": [
        {
            "from_table": "Date Buckets",
            "from_column": "DateKey",
            "to_table": "Date",
            "to_column": "DateKey"
        },
        {
            "from_table": "Event",
            "from_column": "StartDateKey",
            "to_table": "Date",
            "to_column": "DateKey"
        },
        {
            "from_table": "Session",
            "from_column": "SQLSaturdayEventID",
            "to_table": "Event",
            "to_column": "SQLSaturdayEventID"
        },
        {
            "from_table": "Session Speaker",
            "from_column": "SQLSaturdaySpeakerID",
            "to_table": "Speaker",
            "to_column": "SQLSaturdaySpeakerID"
        },
        {
            "from_table": "Session Speaker",
            "from_column": "SQLSaturdaySessionID",
            "to_table": "Session",
            "to_column": "SQLSaturdaySessionID"
        },
        {
            "from_table": "Event Sponsorship",
            "from_column": "SQLSaturdayEventID",
            "to_table": "Event",
            "to_column": "SQLSaturdayEventID"
        },
        {
            "from_table": "Event Sponsorship",
            "from_column": "SQLSaturdaySponsorID",
            "to_table": "Sponsor",
            "to_column": "SQLSaturdaySponsorID"
        }
    ]
}