Meraki DataMagic - Using SQL Queries
Introduction
As well as viewing your data in the user interface, you may want to use SQL queries. Magic Suite uses PostgreSQL.
Remote access to port 5432
To keep your data secure, contact us to set up access as follows:
- Click the Feedback icon (speech bubble)
- From the Type drop-down, select Support Request
- In the Summary box, enter your company name followed by "Remote SQL Access"
- In the Description, enter:
- The IP address range or ranges of the machines you will access the database from
- The user names that need access
- Any table restrictions you want for each user
- Click Submit and wait to hear from us. Requests are dealt with in UK business hours
Database schema
The DataMagic database schema is documented in the Database Schemas folder of the Library. It is an interactive document, which you should download onto your own machine. Once downloaded, you can pan, zoom and rearrange tables, and download a copy of the view you want.