How to Access and Use SupportLogic's Shared Data in Snowflake

Introduction

SupportLogic provides a secure way for customers to access reporting data through Snowflake’s private data sharing feature. This guide outlines the steps customers need to follow to access shared data, along with important information about the secure connection and how data is managed.

Steps to Access the Shared Data

To access the SupportLogic shared data in Snowflake, follow these steps:

1. Navigate to Data Products and select Private Sharing in your Snowflake account.

2.  accept the Snowflake Provider and Consumer Terms of Service if prompted. More details can be found in Snowflake’s documentation.

3. In the Shared with Me section, under Private Listings, locate the listing named <CUSTOMER_NAME>_-_SUPPORTLOGIC_REPORTS.

4. Click the Get button. You will have options to:

   • Change the target database name.

   • Specify additional roles that require access to this data.

5. Once you complete these steps, data syncing into your Snowflake instance will begin. More details can be found in Snowflake’s documentation.

How the Snowflake Private Data Share Works

With Snowflake’s private data share, a secure connection is maintained between your Snowflake account and the SupportLogic Snowflake account. Here’s how the data sharing process works:

• SupportLogic pushes Snowflake reporting data to your Snowflake account based on Account ID.

• The data remains stored in SupportLogic’s Snowflake account, but you get read-only access to it.

• You must accept the data share within your Snowflake account to start receiving data.

• Once accepted, you can choose the database where the shared data will appear in your Snowflake instance.

• You can then copy the data or run reports on it within your own Snowflake environment.

Security and Access Control

Security is managed through both SupportLogic’s and your Snowflake accounts. Here’s how access control works:

• Customer Access: You control user access to your Snowflake account, including MFA, SSO, and role-based permissions.

• SupportLogic Access: SupportLogic manages user access on its own Snowflake account with MFA, SSO, and internal security policies.

• Snowflake Security: Snowflake ensures a secure private share connection between both accounts, which can be managed from the Private Sharing section within Snowflake.

Useful Resources

• Snowflake Data Sharing Documentation: Read more here

• How to Get Your Snowflake Account ID (it would be required to share this with Supportlogic): Follow this guide
  

Conclusion

By following these steps, you can easily access and analyze your SupportLogic reporting data in Snowflake. If you encounter any issues or have questions about your data share setup, feel free to reach out to SupportLogic for assistance.