Zoom is a cloud-based video conferencing platform that allows users to conduct virtual meetings, webinars, and other collaborative sessions over the internet.

Zoom’s features include video and audio conferencing, screen sharing, virtual backgrounds, breakout rooms for smaller group discussions, recording options, and more.

Connecting to Zoom

Mammoth allows you to connect to your Zoom account and get the data into Mammoth.

  1. Select API & Databases from the ‘Add Data’ menu and click on Zoom.

  2. Click on New Connection and log into your Zoom account.

  3. Select the account.

    zoom account

    Fig. 76 Selecting account

  4. Once your Zoom account is connected with Mammoth, you will be presented with a list of tables and views in that database.

    • Select the desired table to get a preview.

    • Write a SQL query or run a test query and preview the result.

    • Click on Next.

    zoom metrics

    Fig. 77 Zoom table selection

After you have selected the table you want to work on, you get options to schedule data imports as discussed in the next section.


Some tables in Zoom are ID dependent. They only return results when either userID or parameterID is defined. Here’s an example of how to write a query in such a case:

Scheduling your Data Pulls

You can start retrieving the data now or at a specific time. Further schedule the data imports to get the latest data from your Database at a certain time interval - just once, daily, weekly or monthly.

On every data pull from your Database, you also have an option to either replace the older data or combine with older data.

On choosing Combine with older data option, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.