LogoLogo
  • User Guide
    • Getting Started
      • Building a Usage-Based Product in Revenium
      • Setting Up & Using API Analytics & Observability
      • Setting Up & Using Product Analytics
      • Sending Data to Revenium's Metering API
      • Key Concepts & Relationships
    • Connect Your Data
      • cURL Commands for Testing
      • Container-Native Metering
      • Kong
        • Kubernetes Installation
      • Salesforce
        • Revenium Unmanaged Package
          • Anypoint API Experience Hub (AEH)
            • Anypoint API Experience Hub Unmanaged Package Post Installation Instructions
          • Anypoint Community Manager (ACM)
            • Anypoint Community Manager Package Post Installation Instructions
        • Revenium Lightning Web Components
          • Add Components to Experience Cloud site
          • Drop-In Storefront
          • Product Card
          • Product Card (Anypoint)
          • Product Checkout
          • Product Details Button
          • Usage History
          • API Access Requester
      • MuleSoft
        • Metering Policy Configuration
        • Offline Metering Policy Configuration
        • Anypoint API & API Group Synchronization
        • Revenium Connector
        • Disable Default Anypoint Community Manager (ACM) Email Notifications
      • Gravitee
      • Istio
      • Envoy
      • AWS API Gateway
      • Python & Django
      • Golang
      • Spring Boot
      • .Net
      • NodeJs
      • Java/JVM
      • Snowflake
      • Azure API Management
      • IBM
      • Custom Integrations Using Metering Beacons
        • JWT Enrichment
      • Offline Metering via Log Parsing
    • Sources
      • Metering Elements
      • Alerts
        • Alert History
    • API Keys
    • Products & Pricing
      • Product Lines
      • Pricing Rules
        • Revenium Scripting Language
          • RSL Reference
        • Execution Logs
      • SLA Definitions
      • SLA Violation Review
    • Customers
      • Customers
      • Subscribers
      • Subscriptions
      • Subscribers Credentials
      • Subscribers Notifications
    • Billing and Invoicing
      • Manage Refunds
    • Analytics
      • Revenue Analytics
      • Product Analytics
        • Custom Reports (Products)
      • Subscriber Analytics
        • New Subscribers
        • (Daily/Weekly/Monthly) Active Subscribers
        • Most Engaged Subscribers & Customers
        • Historical Usage
      • API Analytics
        • Performance & Availability
        • Compare Periods
        • Traffic by Geography
        • Advanced Search
        • Custom Reports
    • Profile
      • Profile
      • Revenium API Documentation
    • Settings
      • Revenium Users & Organizations
        • Access Permissions by User Type
      • Revenium Subscription
      • Revenium Organizations
      • Notification Templates
      • Transactions Logs
        • Analytics Transaction Log
        • Product Transaction Log
        • Subscription Audit Log
        • No Code Transaction Testing
      • Integrations
        • Data Sync
        • Export Configurations
        • Notification Providers
        • Payment Configurations
          • Customer VAT ID Support
        • ERP Configurations
        • External Integration Logs
        • Identity Providers
      • System Logs
      • Default Configuration Limits
Powered by GitBook

© Revenium - www.revenium.io

On this page
  • Configuring a Data Warehouse
  • Create a Source
  1. User Guide
  2. Connect Your Data

Snowflake

Revenium enables the metering of SQL queries to enable the granular monetization and analytics of data contained in Snowflake data warehouses.

Last updated 2 months ago

Revenium periodically introspects a view created over Snowflake's table to infer query telemetry used for monetization, analytics and reporting.

Configuring a Data Warehouse

A Data Warehouse provides the necessary configuration for Revenium to poll external data sources like Snowflake to convert usage history into a format that allows for granular metering and advanced monetization models. To configure a Data Warehouse follow these steps:

Search for Integrations in the search bar -> choose data warehouse -> add new

Provide the configuration options:

Click "Next" and define the details for the Data Warehouse to be monetized:

Configuration Parameter
Description

hostname

The Snowflake URL

username

The username

password

The password

database

The database to create the billing view over

warehouse

The warehouse name

Click "Next". While you shouldn't need to do this unless otherwise instructed by the Revenium Team, you can edit the Schema Creation SQL and Billing Query SQL in this screen:

Create a Source

Navigate to Sources -> Add New and create a Subscriber Data Source. Columns that are to be tracked or monetized should be comma separated in the "Resource" field.

In the image above, Snowflake resources can be defined using either "COLUMN" or "TABLE:COLUMN" syntax. For example "SYMBOL" will meter any query that includes the SYMBOL column in its query. "MARKET_DATA:SYMBOL" will constrain metering only to the "SYMBOL" column in the "MARKET_DATA" table.

Next click on the "Custom Metadata" of the Source and set the "External Source ID" field to match the corresponding Snowflake warehouse:

All Snowflake sources must share the same warehouse when grouped as a Product.

The Schema Creation SQL created the view over Snowflake's table that is queried periodically with the Billing Query SQL. The Billing Query SQL results are converted into that are used for metering, analytics and reporting.

A , in the context of Snowflake, defines the columns of a table to be monetized. Defining columns and tables as sources allows you to create more complex monetization models, i.e. charging differently based on which columns and tables are accessed.

Snowflake Sources are interchangeable with other Source types, including APIs. This allows you to build sophisticated digital products that include a combination of API access and Snowflake access if desired. You can read more about & creation in the relevant documentation sections.

QUERY_HISTORY
transactions
Source
product
subscription
QUERY_HISTORY
Configure the Consumer Data Configuration
Configure the Date Warehouse
Optionally edit the Schema Creation and Billing Query SQL
Creating a Consumer Data Asset
Set the External Source ID to match the associated Snowflake warehouse