Share Alation Analytics Data with Your Snowflake Account

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Available from version 2025.3.1

Important

You are viewing documentation for Alation’s Classic User Experience.

Overview

Alation Analytics allows you to access a read-only replica of the analytics database directly within your own Snowflake account. This feature uses Snowflake’s native Data Sharing to enable powerful cross-reporting, allowing you to join Alation Analytics data with your own datasets to create customized reports.

Alation automatically determines the best sharing method based on your account’s location:

  • Direct Share: Used when your Snowflake account is in the same cloud and region as Alation’s.

  • Secure Data Share (via Marketplace Listing): Used when your Snowflake account is in a different cloud or region.

Cost Considerations

Enabling this feature may incur compute and storage costs from Snowflake.

  • Compute Costs: You will be charged for virtual warehouse usage when you query the shared database from your Snowflake account.

  • Storage Costs: For shares established via the Secure Data Share (Listing) method, you will incur storage costs for the replicated data in your Snowflake account.

Prerequisites

Before you begin, ensure the following conditions are met:

  • The Snowflake replication feature must be enabled for your Alation instance.

    Note

    Alation Cloud Service customers can request server configuration changes through Alation Support.

  • The Snowflake Replica feature must be enabled for your Alation instance.

  • No previous data sharing or listing for the Alation Analytics database should already be active for your account.

  • You must have Server Admin privileges to access the Alation Analytics Settings page.

  • You must have your Snowflake account details:

    • Organization Name

    • Account Name

    • Snowflake Region

Enable Snowflake Data Sharing

  1. In Alation, navigate to Admin Settings > Platform Settings > Alation Analytics Settings.

  1. In Alation, navigate to Admin Settings > Alation Analytics Settings.

  1. Scroll to the Snowflake Data Sharing section.

  2. Enter the following details:

    • Organization name: Your Snowflake organization name. In Snowflake, run the query SELECT CURRENT_ORGANIZATION_NAME(); and then copy-paste the value here.

    • Account name: Your Snowflake account name. In Snowflake, run the query SELECT CURRENT_ACCOUNT_NAME(); and then copy-paste the value here.

    • Region name: This is the region where your account is hosted. In Snowflake, run the query SELECT CURRENT_REGION(); and then copy-paste the value here.

  1. Click Enable data sharing.

    A dialog will appear with the next steps for accepting the share in your Snowflake account.

Access the Shared Data in Snowflake

After initiating the share in Alation, you must accept it in your Snowflake account.

  1. Log in to your Snowflake account.

  2. Navigate to Data Sharing > Private Sharing.

  3. Locate the share from Alation.

    Depending on the type of share, the Alation data could be in one of the following locations:

    • Privately Shared Listings

    • Direct Shares

  4. (Optional) Customize the Database name and choose which roles can access it.

For more information, see the Snowflake Documentation for a private share and direct share.

Considerations for Disabling Snowflake Data Sharing

The data sharing feature permits sharing with only one Snowflake account at a time. To connect to a different account, you must first disable the existing share.

  • For a Direct Share: Access is immediately revoked, and the shared database is removed from your Snowflake account.

  • For a Secure Data Share (Listing): The database will remain in your Snowflake account, but it will no longer receive data updates.

You can also consider the following scenarios for disabling data sharing:

  • Cost Management: To stop incurring ongoing compute and storage costs from Snowflake, you would disable the share. This is a crucial step for managing your cloud data warehouse budget, especially if the shared data is not being actively used.

  • Revoking Data Access: You may need to permanently or temporarily revoke access for security or data governance reasons. This could be required at the end of a specific project, during a security audit, or if internal data policies change.

  • Troubleshooting the Connection: If you encounter issues with data synchronization or the connection itself, a standard troubleshooting step is to disable the feature and then re-enable it. This process can help re-establish a clean connection and resolve underlying sync problems.

You can disable the data share feature from Alation Analytics Settings > Snowflake Data Sharing > Disable data sharing. The effect of disabling the share depends on the method used.

Limitations

  • If new tables are added to the source Alation Analytics database after the share is established, they are not automatically added to your shared database.