Introduction
Amazon Redshift is Digitail's data warehouse. Digitail Redshift is the add-on that gives a clinic (or group) read-only access to their own data in it, so they can build their own reports and BI dashboards outside of the standard Digitail product.
How access works
- You get a Digitail-specific Redshift login and IP whitelisting on your end.
- Digitail creates a set of non-materialized views scoped to your clinic(s) — you never query raw tables directly.
- From there, you own the query and report building. Digitail doesn't build or maintain reports on your behalf.
Additional monthly and support fees apply to this add-on.
Naming convention
Every view you're granted is prefixed with your client code, e.g. client1_sale, vsrep_pet. A small set of global reference tables (species, breeds, countries, measurement units, etc.) are shared across all clients and are not prefixed — see All views for the full breakdown.
Query frequency
Views refresh on a 24-hour cycle. Please don't poll more often than once a day unless you've arranged a shorter frequency with us — contact us if your use case needs it.
What's covered on the following pages
The pages in this space are organized by business domain, not by raw table name, because that's how the data actually relates to itself:
Section | Covers |
|---|---|
How the domains connect to each other — start here if you're new | |
Sales, charges, payments, invoices, discounts | |
Products, inventory batches, service packages | |
Clients | Client/owner demographics and clinic relationships |
Patients | Pet demographics and clinical archive status |
Medical | SOAP records, diagnostics, prescriptions, custom fields |
Operational | Appointments, scheduling, rooms, reminders, notifications |
All views | Full list of every view you have access to |
Which timestamp columns are UTC vs. clinic-local | |
Architecture and limitations if you're connecting via Power BI |
Scope of access
Digitail can't grant access to every table in the platform — some data is excluded for privacy and security reasons. The All views page is the authoritative list of what you can query. If a table you need isn't on that list, contact us; expanded access is considered case by case.
Please contact us if you experience difficulty with your existing access.