Snowflake Data Share: access Cleeng reporting data in Snowflake

Cleeng Snowflake Data Share gives your data team direct, read-only access to Cleeng reporting datasets in a Snowflake environment.

Instead of scheduling files from the Cleeng Dashboard, you can query the shared data using Structured Query Language (SQL) or connect it to Snowflake-compatible analytics and business intelligence (BI) tools.

The data is refreshed every six hours. The initial release includes six reporting views:

• User Report
• Subscription Report
• Pass Report
• Transactions Report
• Refunds Report
• Gift Report

How the Integration Works

When you activate the connector, Cleeng provides a dedicated Snowflake reader account for your organization and makes your Cleeng reporting data available in that account.

You do not need to provide an existing Snowflake account. Snowflake reader accounts are designed to let data consumers query shared data without maintaining a separate Snowflake customer account. Shared data is read-only and cannot be updated or deleted by the consumer.

Your Snowflake account is:

• provisioned and managed by Cleeng
• restricted to data belonging to your Cleeng publisher account
• configured with a warehouse for running queries
• supplied with initial administrator credentials
• refreshed with Cleeng reporting data every six hours

Data Available in Snowflake

The following secure views are currently included:

These datasets correspond to the reports available under Analytics > Data Export in the Cleeng Dashboard.

For definitions of individual fields, see the How to Understand Exported Data article and the dedicated documentation for each report.

Cleeng may extend the Snowflake share with additional fields or datasets in future releases. For production pipelines, select the columns you need explicitly rather than relying on SELECT *.

Before You Start

Make sure that:

• Snowflake Data Share has been enabled for your Cleeng publisher account
• you have access to Admin & Tools > Integration Hub > Snowflake Sharing
• you have an email address that can securely receive the initial Snowflake credentials
• the person receiving the credentials is authorized to administer access to your reporting data

If you cannot see the Snowflake connector in the Integration Hub, contact your Cleeng Account Manager.

Connect Snowflake Data Share

1. Open Integration Hub

Sign in to the Cleeng Dashboard and go to:

Admin & Tools > Integration Hub

Cleeng uses Integration Hub as the central location for configuring supported third-party integrations.

2. Select Snowflake Sharing

Open the Snowflake Sharing connector.

3. Complete the Configuration Form

Enter the following information:

Snowflake Credit Quota
The quota is set to 100 and is displayed as a read-only field. You cannot change it during connector setup.

Email for Credentials
Enter the email address that should receive the Snowflake account details and initial password.

Confirm Email
Enter the same email address again. Both email fields must match.

Use an address that belongs to the person responsible for managing your data access. Do not use a shared or publicly accessible mailbox.

4. Select Connect

Select Connect to start provisioning.

The setup runs automatically. You can leave the page while Cleeng prepares the Snowflake reader account.

5. Retrieve Your Credentials

Once provisioning has completed, Cleeng sends an email containing:

• the Snowflake sign-in information
• the reader-account username
• a link for retrieving the initial password

The password link:

• can be opened only once
• expires after seven days
• will no longer display the password after you use it

Open the link only when you are ready to store the credentials securely.

6. Sign In to Snowflake

Use the account details and credentials from the email to sign in. During your first login, Snowflake requires you to replace the temporary password.

The account includes:

• the shared Cleeng reporting database
• the six reporting views
• a default Snowflake warehouse
• an initial administrator user

Query the Shared Data

After signing in, open a Snowflake worksheet.

Start by checking the objects available in your account:

USE ROLE ACCOUNTADMIN;
USE WAREHOUSE <warehouse_name>;

SHOW DATABASES;

Once you identify the shared database, inspect its schemas and views:

SHOW SCHEMAS IN DATABASE <shared_database>;

SHOW VIEWS IN SCHEMA <shared_database>.<shared_schema>;

You can then query a reporting view:

SELECT *
FROM <shared_database>.<shared_schema>.EXP__USER_REPORT
LIMIT 100;

Another example:

SELECT *
FROM <shared_database>.<shared_schema>.EXP__TRANSACTIONS_REPORT
LIMIT 100;

Replace <shared_database> and <shared_schema> with the names shown in your Snowflake account.

Connect Analytics Tools

You can use the Snowflake credentials with tools that support Snowflake connections, subject to the capabilities and access settings of the selected tool.

You will generally need to provide:

• Snowflake account identifier or URL
• username
• password
• warehouse
• database
• schema
• role

For routine access, we recommend creating individual Snowflake users and appropriate roles instead of sharing the initial administrator credentials. Snowflake reader-account administrators can configure additional users and roles for accessing the shared data.

Data Refresh Schedule

Cleeng refreshes the six reporting views every six hours.

This means:

• data is not updated immediately after an event occurs
• recent purchases, subscriptions or refunds may appear during the next refresh
• Cleeng manages the refresh schedule and it cannot currently be changed
• reports and dashboards built on top of the share should allow for this delay

When you validate the integration immediately after activation, allow time for the first scheduled data refresh.

Data Access and Security

The shared views are restricted to the publisher account associated with your Snowflake reader account.

You cannot:

• see records belonging to other Cleeng publishers
• insert, update or delete records in the shared views
• change Cleeng's source reporting data
• share the imported database with another Snowflake account

Snowflake imported databases and reader-account shares are designed primarily for querying provider-controlled data.

You remain responsible for:

• controlling who receives the credentials
• creating and removing users in the reader account
• securing data downloaded or copied into your own systems
• ensuring that access complies with your organization's privacy and security policies

Disconnect Snowflake Data Share

Disconnecting Snowflake Data Share from production or sandbox requires assistance from Cleeng. For security reasons, this step is restricted to Cleeng administrators, to limit the risk of accidental account deletion.

Contact Cleeng Support or your Account Manager and specify:

• your Cleeng publisher ID
• the relevant environment
• that you want the Snowflake Data Share reader account removed

Reactivating the connector creates a new Snowflake account. It does not restore the previous account, credentials or customer-created objects.

Troubleshooting

I Did Not Receive the Credentials Email

Check:

• that the email address entered in Integration Hub is correct
• your spam or junk folder
• whether your organization blocks automated emails
• whether connector provisioning has finished

Cleeng sends the email only after provisioning completes. Contact Cleeng Support if it still does not arrive.

The Password Link Does Not Work

The link may already have been opened or may have expired after seven days.

Contact Cleeng Support to request assistance with new credentials. Do not disconnect the connector unless instructed to do so.

I Can Sign In, But I Cannot Run a Query

Make sure that:

• you are using a role that can access the imported database
• you are querying one of the shared views
• the database and schema names are correct

You can inspect your current session using:

SELECT
    CURRENT_ACCOUNT(),
    CURRENT_USER(),
    CURRENT_ROLE(),
    CURRENT_WAREHOUSE();

The Views Contain No Rows

Confirm that:

• you connected the correct Cleeng environment
• the publisher account contains reportable data
• the first six-hour refresh has completed
• your query uses the shared reporting database

The share intentionally returns only records belonging to your publisher account.

Recent Activity Is Missing

Snowflake Data Share refreshes every six hours. Activity that occurred after the last completed refresh appears during a subsequent refresh.

I Cannot See a Disconnect Button

For production and sandbox environments, disconnection is restricted to Cleeng administrators. Contact Cleeng Support or your Account Manager.

Frequently Asked Questions

Do I need my own Snowflake account?
No. Cleeng provides a dedicated Snowflake reader account when you connect the integration.

Is the data read-only?
Yes. You can query the shared Cleeng views, but you cannot change the underlying data.

How frequently is the data updated?
Every six hours.

Can I change the refresh frequency?
Not currently.

Can I change the Snowflake credit quota?
The connector currently displays a fixed quota of 100 credits. Contact your Cleeng Account Manager if your use case requires a different arrangement.

Can several people access the data?
Yes. The initial user is the account administrator and can create additional Snowflake users and roles. Avoid sharing one administrator password among multiple users.

Can I use the share with a BI tool?
Yes, when the tool supports Snowflake connections. Configure it using the account, user, warehouse, database, schema and role information from your Snowflake account.

Are the datasets identical to downloaded Cleeng reports?
They represent the same six reporting areas. Refer to the documentation for the corresponding Cleeng Data Export report for field definitions and reporting logic.