Snowflake data share provides direct, read-only access to Restaurant365 reporting data from an organization’s Snowflake environment.
Connecting an organization’s Snowflake environment to R365 is completed in two stages:
Restaurant365 uses Snowflake account details provided by the organization to establish a secure data share.
The organization accesses the private listing shared by Restaurant365 in Snowflake to accept the connection.
Once the data share is established, database creation and data querying occur in Snowflake.
In Beta
This feature is in beta for select customers. Contact your CSM for more information.
Snowflake Account Details
To establish the secure data share, R365 Support or the assigned Customer Success Manager will request the following Snowflake account details:
Account ID
Account Share ID
Cloud Platform
Account Region
These details are available in Snowflake either in Account Details or by running a query.
Learn more about Snowflake Account Identifiers [docs.snowflake.com].
Account ID
The Snowflake Account ID is the account locator for the organization’s Snowflake environment.
The Account ID is found in Snowflake in the ‘Account locator’ field or by running the following query:
SELECT CURRENT_ACCOUNT() AS ACCOUNT_ID;
Example: RFC35873
Account Share ID
The Account Share ID is a combined identifier that includes the organization name and the Snowflake Account ID.
The Account Share ID is found in Snowflake in the 'Data sharing account identifier’ field or by running the following query:
SELECT CURRENT_ORGANIZATION_NAME() || '.' || CURRENT_ACCOUNT_NAME() AS ACCOUNT_IDENTIFIER_FOR_SHARING;
Example: GISPOCS.YWC18486
Cloud Platform
The Cloud Platform is the platform that hosts the organization’s Snowflake account, such as Amazon Web Services (AWS), Microsoft Azure (AZURE), or Google Cloud Platform (GCP). It is the provider prefix in the Snowflake account identifier value (for example, aws in aws_us_east_1).
The Could Platform is found in Snowflake in the ‘Cloud platform’ field or by running the following query:
SELECT CURRENT_REGION() AS ACCOUNT_REGION;
Example: AWS
Account Region
The Account Region is the cloud region where the organization’s Snowflake account is hosted. It is the portion of the Snowflake account identifier value that appears after the cloud provider prefix (for example, us_east_1 in aws_us_east_1).
The Account Region is found in Snowflake by running the following query:
SELECT CURRENT_REGION() AS ACCOUNT_REGION;
Example: us-east-1
Accessing Shared Data in Snowflake
After Restaurant365 creates the private listing, it must be accepted in Snowflake to complete the connection and access the shared data.
Learn more about viewing private listings [docs.snowflake.com].
Once the private listing has been accepted in Snowflake, the shared Restaurant365 data is available to query in the organization’s Snowflake environment.
Learn more managing private listings [docs.snowflake.com].