📌
MBPY: Schools Technology
  • About this Resource
  • Installation
    • Requirements
    • Getting Started Local Install
    • Getting Started using Docker
    • Further instructions with Docker
    • Updating with Docker
  • Tutorials
    • Configuration
    • Importing
    • Extracting
    • Streaming
    • Pipelines
    • Scripting
    • Big Query
  • Querying & Tranformations
    • Querying Commands
    • Querying the Database
    • Querying via Script
    • Querying via an SQLite Client
  • Scripts
    • Daily Homeroom Attendance Report
  • Pipelines
    • Dataframes with pandas
    • Pipelines
    • Example Pipelines
      • Bulk Change Email domain
      • Enrollment by Gender
  • Plugins
    • mbpy_powerschool_plugin
      • PowerSchool Plugin
        • API reference
      • mbpy Plugin
        • mbpy plugin source code
    • Plugins Overview
    • mbpy_plugin_example
    • mbpy_plugin_destiny
    • mbpy_plugin_attendance_reports
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Querying & Tranformations

Querying via an SQLite Client

Querying the data using SQL

PreviousQuerying via ScriptNextDaily Homeroom Attendance Report

Last updated 2 years ago

Was this helpful?

The mbpy import command extracts the data from APIs, and puts it into an SQLite database.

This database is located inside the mbpy/data folder. Thus, you can use any database client to navigate the table structures, or execute select statements, joins, etc.

This is an example of using a database client to look for students with a particular domain name: