What is the EDW?
The External Data Warehouse (EDW) gives you direct, self-service access to your Betterview platform data. Connect to it in one of these ways depending upon your setup:
- Azure SQL: A SQL Server database hosted by Nearmap, which you connect to with credentials we issue.
- Snowflake: A private listing that you accept into your own Snowflake account.
The EDW is designed to reduce dependency on Customer Success Managers for routine data requests, and to complement existing API functionality by exposing property data in a flexible format that can be queried easily. For a list of frequently asked questions, see this article.
What you can do with the EDW
The EDW supports a range of reporting and integration use cases:
- Ad hoc reporting - Run custom SQL queries against your property data on demand.
- BI tool connectivity - Connect directly to tools like Tableau, Power BI, and other analytics platforms.
- Enterprise data warehouse integration - Add Betterview data to your existing internal data warehouse.
- Self-service analytics - Build and maintain your own dashboards without engaging Nearmap support.
- API supplementation - Surface data with minimal custom programming alongside existing API integrations.
- Query in place (Snowflake only) - Nothing is copied into your account, so there is no pipeline to maintain and no storage cost.
- Join directly to your own data (Snowflake only) - The share is read-only, so you can join it to your own tables but can’t alter Nearmap data.
Connecting to the EDW
Access to the EDW is restricted by IP allowlist. You must provide up to five IP ranges (preferably VPN or office networks) to be whitelisted before connecting.
If you run into any issues while connecting to the EDW, refer to the troubleshooting article for more information.
Azure SQL
You can connect to the EDW with the following details:
Field | Value |
|---|
Server Name | Provided by Nearmap |
Database Name | Provided by Nearmap - must be explicit in the connection string |
User Name | Unique to you, provided by Nearmap |
Password | Unique to you, provided by Nearmap |
Snowflake
To access EDW with Snowflake:
- Send Nearmap your Snowflake account identifier - (format
ORG-ACCOUNT). Find it by running select current_organization_name() || '-' || current_account_name();. - Nearmap adds your account to the data share.
- You can now mount the share. For example,
create database EDW_SHARE
from share <NEARMAP_ORG>.<NEARMAP_ACCOUNT>.EDW_SHARE; - Grant your team privileges on the database to provide access.
Data Structure
The data dictionary is available from two sources with the same content:
- The spreadsheets attached below.
- Snowflake only - A dedicated data dictionary on the Snowflake private listing. It is generated from the live tables, so it always matches what you can query.
It covers the EDW only, not the full Betterview detections catalogue or partner integrations. Each layer represents a relational table in the database. The full table structure and field definitions are documented in the Betterview Data Warehouse Data Dictionary (attached as a downloadable file below).
Data Refresh
- Azure SQL - Refreshed nightly, based on all transactions completed within 24 hours of midnight UTC. Refreshed data is reliably available from 2:00 AM PST /5:00 AM EST.
- Snowflake - Refreshed nightly on the same schedule. Reliably available from 2:00 AM PST / 5:00 AM EST.
Any batch orders submitted after 3:00 PM local time will be included in the following night's EDW load for both endpoints.
Example visualizations
Given below are a couple of example visualizations to give you an idea of the dashboards you can build with the data in EDW and your BI/analytics platform.