This document outlines the technical details of the Database Access Suite as introduced in Third Party Data Access and Analytics Integration
Table of Contents |
---|
What is the Database Access Suite?
...
Code Block | ||
---|---|---|
| ||
SELECT COUNT(*) AS number_of_latino_visitors, pva.total_members FROM l2f_test_program_visit_household_member_ethnicity_types AS pvhmet LEFT JOIN l2f_test_data_types AS dt ON pvhmet.ethnicity_type_id = dt.id LEFT JOIN l2f_test_program_visit_household_members AS pvhm ON pvhmet.program_visit_household_member_id = pvhm.id LEFT JOIN l2f_test_program_visit_activities AS pva ON pvhm.program_visit_activity_id = pva.id LEFT JOIN l2f_test_programs AS p ON pva.program_id = p.id WHERE dt.name = 'hispanic_latino' AND pva.visit_date BETWEEN '2020-01-01' AND '2020-12-31' AND p.type = 'csfp_food_bank' GROUP BY pva.total_members; |
Video Demonstrations
Connecting with MySQL Workbench and MySQL Command Line Interface (CLI)
MySQL Workbench: https://drive.google.com/file/d/1Ql2e0y5cwrxpgN3RQox5f41ZPw9JPxQN/view?usp=drive_link
MySQL Command Line Interface: https://drive.google.com/file/d/1fwqTSa2ac3Aw5lkbKRT0OOUd0lPeBaSV/view?usp=drive_link
Connecting with DBeaver
Connecting and Using Tableau Desktop
Connecting with Tableau Desktop: https://drive.google.com/file/d/1nWYE4tFuvO7fEV58BRF29Tcp_l1eg2m2/view?usp=drive_link
Using Tableau Desktop: https://drive.google.com/file/d/1vX2bUU8FZsve749rkkcdzzC4k3YAzyMn/view?usp=drive_link