Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
languagesql
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)

Connecting with DBeaver

Connecting and Using Tableau Desktop

Connecting with Azure Data Factory