Snowflake Data Share
Query Regal reporting data directly from your Snowflake account
Setting Up Snowflake Secure Data Share
Regal provides access to your Regal reporting data via Snowflake Secure Data Share, so you can view and query Regal's reporting tables directly from your Snowflake database.
Prerequisites
To get access to reporting data via Regal's Snowflake Secure Data Share, you must be a Snowflake customer and use AWS as your cloud provider.
What is Snowflake Data Share?
Snowflake enables the sharing of databases through shares, which are created by data providers (Regal, in this case) and “imported” by data consumers (You). All database objects shared between accounts are read-only (i.e. the objects cannot be modified or deleted, including adding or modifying table data).
With Secure Data Sharing, no actual data is copied or transferred between accounts. All sharing uses Snowflake’s services layer and metadata store. Shared data does not take up any storage in a consumer account and therefore does not contribute to the consumer’s monthly data storage charges. The only charges to consumers are for the compute resources (i.e. virtual warehouses) used to query the shared data.
Because no data is copied or exchanged, Secure Data Sharing setup is quick and easy for providers and access to the shared data is near-instantaneous for consumers.
To get started with Regal Reporting through Snowflake Secure Data Share, please email [email protected] with the following information:
-
Your Snowflake account and org names. These are Snowflakes “preferred identifiers”. See docs here.
-
Which cloud provider and region your Snowflake account is on. Note: Regal currently supports AWS us-east-1, us-east-2 and us-west-2. Please double check this before providing to us because it will significantly delay set up time if we need to switch after the fact.
-
Which data tables you want to access.
Available tables listed below:
| Table | Description |
|---|---|
| aggregated_contacts | Single record for every contact in your account - columns include identifying information, opt in, contact attributes, etc. |
| aggregated_tasks | Single record for every task in your account - columns contain information about the task's lifecycle, disposition, notes, recording, etc. |
| model_agent_activity_event | Single record for every activity status change of an agent - columns include previous status to calculate total time in each activity status. |
| model_regal_voice_event | Single record for every reporting event out of Regal. Reporting events and schema are documented here |
Data Policy
Tables are updated hourly from 7am to 11pm ET. We retain the last 18 months of data.
Once we have this information, we will create the share and notify you when it is ready.
After, you'll need to configure your side of the share. The exact steps will depend on your account configuration, what you use to manage Snowflake, etc. but the Snowflake docs here are a good place to start.
If your Snowflake instance is in a different AWS region than what Regal current supports or have any other questions about setting up Snowflake Secure Data Share set up, email [email protected].
Updated 6 months ago