Flipside Docs
  • Welcome to Flipside!
    • Welcome to Flipside
    • Growth Services
    • Data
      • Choose your Flipside plan
        • Free
        • Builder
        • Pro
          • Get Started in Snowflake
          • Incremental Table Pattern
          • Copy Data from Snowflake to AWS
          • Copy Data from Snowflake to GCP
          • Copy Data from Snowflake to Azure
        • Snowflake Data Shares
          • Mounting a Snowflake Data Share
    • Earn
    • Community
  • Data
    • Flipside Data
      • Table Docs by Chain
      • Data Modeling Approach
      • Labels
        • Centralized Exchange Label Type
        • Decentralized Exchange Label Type
        • Operator Label Type
        • Chain Admin Label Type
        • Decentralized Finance Label Type
        • NonFungible Tokens Label Type
        • Games Label Type
        • Bridge Label Type
        • Decentralized Applications Label Type
        • Token Label Type
        • Flotsam Label Type
      • Tags
      • Table Freshness Targets
      • Contribute to Our Data
        • Contract Decoding & ABIs
        • How to Add Your Own Tags
        • Community Curation
          • Getting Started
            • Contribution Workflow
          • Model Standards
            • dbt Tips
          • PR Checklist
    • Data Products
      • Data Studio (SQL Analysts)
        • Get Started
          • Write/fork your first query
        • Flipside AI
        • Studio in Depth
          • Query Editor
            • Query Referencing
            • Pro Tips for Querying
            • Keyboard Shortcuts
            • Hex-to-Integer Function
          • Create a Chart
            • Advanced Visualization
          • Build a Dashboard
            • Markdown Reference
          • Team Accounts
        • Tutorials
          • How to Analyze Web3 Data
          • Video Tutorials
            • Overview of Schemas & Tables
            • Ethereum Tutorials
              • Getting Started with Decoded Ethereum Events
              • Getting Started with Ethereum Balances
              • Block Level and Daily Balances
              • Finding Centralized Exchange Flows
            • Solana Tutorials
              • Solana Schema & Tables: Video Walkthrough
              • Solana Specialty Tables: Video Walkthrough
              • Exploring Transactions in solana.events
            • THORChain Tutorials
              • THORChain Schema & Tables
              • Calculating IL for THORChain
          • More Tools & Resources
        • Get Inspired
      • LiveQuery
        • Get Started
        • LiveQuery in Depth
          • Functions
            • 🤝Partner Functions
            • 🧙‍♂️EVM Functions
              • 💡Seaport: Real-time Orders
              • 💡WETH Pool Balances
              • 💡General EVM Node Queries
            • 🤖API Functions
              • 💡Query TheGraph
              • 💡Query Defi Llama
            • ⚙️Utility Functions
              • 💡Hex Converters
              • 💡JSON RPC Request Builder
              • 💡EVM Logs Decoder
              • 💡Keccak256 Encoder
          • QuickNode Setup Guide
        • Secrets Manager
        • Get Inspired
      • Snowflake
      • API/SDK (Developers)
        • Get Started - Your first API call in < 2 min
        • SDK in Depth
          • JSON RPC methods
          • Run A Query
          • Query Results
          • Pagination
          • Sorting
          • Filtering
          • Query Seconds
          • Caching (maxAgeMinutes)
          • Rate Limits
          • Errors
          • More Examples
          • Archive
            • [ARCHIVED] JS/TS SDK
            • ShroomDK Migration Guide
            • [LEGACY] R
        • Tutorials
          • Have Questions?
        • Get Inspired
    • Insights and Tools
  • Earn
    • Flipside Earn
    • Onchain Rewards
      • Quests
    • Analyst Rewards
      • Top Dashboards
        • Top Dashboard Guidelines
        • Skill Tree
      • Ambassador Program
      • Direct to Analyst Commissions
    • Wallet Management
    • Tax Center
  • Support
    • General Support
    • Open a Ticket
      • That email doesn't look quite right
    • 🌟Product Special Releases
      • 2025
        • 2025-02-06 | EVM Blockchain Standardization
          • Table Change Overview
      • 2024
        • 2024-06-13 | Solana native and wrapped addresses
        • 2024-05-01 | Improvements to Pricing Data
          • Actions for Data Studio Users
          • Actions for API Users
          • Action for Data Share Users
    • 🗒️Release Notes
      • 2025
        • 2025-05-01 | Release Notes
        • 2025-04-17 | Release Notes
        • 2025-04-03 | Release Notes
        • 2025-03-20 | Release Notes
        • 2025-03-06 | Release Notes
        • 2025-02-20 | Release Notes
        • 2025-02-06 | Release Notes
        • 2025-01-23 | Release Notes
      • 2024
        • 2024-12-24 | Release Notes
        • 2024-12-12 | Release Notes
        • 2024-11-27 | Release Notes
        • 2024-11-14 | Release Notes
        • 2024-10-31 | Release Notes
        • 2024-10-03 | Release Notes
        • 2024-10-17 | Release Notes
        • 2024-09-19 | Release Notes
        • 2024-09-05 | Release Notes
        • 2024-08-22 | Release Notes
        • 2024-08-08 | Release Notes
        • 2024-07-25 | Release Notes
        • 2024-07-11 | Release Notes
        • 2024-06-27 | Release Notes
        • 2024-06-14 | Release Notes
        • 2024-05-30 | Release Notes
        • 2024-05-16 | Release Notes
        • 2024-05-02 | Release Notes
        • 2024-04-18 | Release Notes
        • 2024-04-05 | Release Notes
        • 2024-03-18 | Release Notes
        • 2024-03-05 | Release Notes
        • 2024-02-20 | Release Notes
        • 2024-02-05 | Release Notes
    • 📊Studio Change log
  • Flipside Community
    • Get Started
    • Ambassador Program
    • Join Our Discord
    • Join Our Guild
Powered by GitBook
On this page
  • Log in to your Snowflake Account
  • Snowflake Data Tour
  • Run your First Query
  • Build On Top Of Flipside Data

Was this helpful?

  1. Welcome to Flipside!
  2. Data
  3. Choose your Flipside plan
  4. Pro

Get Started in Snowflake

PreviousProNextIncremental Table Pattern

Last updated 1 year ago

Was this helpful?

Complex data is now simple. The Snowflake UI has everything you need to integrate Flipside data with your existing architecture, query programmatically, build internal tooling, and more. Get the data you want, in whatever environment you need.

Get started by following the demo video or written guide below:


Log in to your Snowflake Account

  1. Log in to Snowflake by clicking on the Account URL

  2. Enter your credentials and click "Sign in"

  3. Set a new password for your account


Snowflake Data Tour

Now that you have your snowflake account set up, let's take a look at the data available.

  1. Navigate to the left-hand side of the screen to find the "Data" section

  2. Browse through all of the Flipside Data Shares that have been share with your snowflake account where

    • Each database represents a blockchain. And each database follows a similar schema design pattern to reduce the learning curve for analyzing different chains

  3. Now, let's take a look at the "Ethereum" database and expand the "Core" schema. Here you're find:

    • Fact tables: akin to primatives of a blockchain. Think blocks, transactions, events, or traces.

    • Dim tables: dimensions of data that make querying easier. For example, contracts, liquidity pools, or labels that have been developed by Flipside's data science team.

    • Ez tables: combination of fact and dim tables that allow syou to access highly curated slices of data.


Run your First Query

  1. Navigate to the left-hand side of the screen again to find the "Worksheet" section

  2. Create a new worksheet by clicking on the "+" button in the top-right corner

  3. As an example, let's find the answer to the following question with the example query below:

Over the past week, how is USD Volume distributed among Decentralized Exchanges (DEXs) across Ethereum, Polygon, Optimism, Arbitrum, Avalanche & BSC?

-- 1. Aggregate swaps across Ethereum, Polygon,Optimism, Arbitrum, Avalanche, BSC 

WITH dex_swaps AS (
    SELECT 'ethereum' chain, * FROM ethereum.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'polygon' as chain, * FROM polygon.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'optimism' as chain, * FROM optimism.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION
    SELECT 'arbitrum' as chain, * FROM arbitrum.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'avalanche' as chain, * FROM avalanche.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'bsc' as chain, * FROM bsc.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
)
-- 2. Aggregate volume and unique users across blockchains

SELECT
    platform as dex_platform,
    count(distinct(origin_from_address)) as total_users, 
    sum(amount_in_usd) as usd_volume
FROM dex_swaps
GROUP BY dex_platform

Build On Top Of Flipside Data

In your trial sandbox (that is private to you), you can create any views or tables on top of Flipside's data shares.

In the dropdown, at the top of the new worksheet, ensure that you've selected your sandbox database so you are operating in this worksheet in the right context.

  1. Create a new SQL worksheet to write the code to generate a view

CREATE SCHEMA cross_chain;

CREATE VIEW cross_chain.latest_weekly_dex_volume AS (
WITH dex_swaps AS (
    SELECT 'ethereum' chain, * FROM ethereum.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'polygon' as chain, * FROM polygon.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'optimism' as chain, * FROM optimism.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION    
    SELECT 'arbitrum' as chain, * FROM arbitrum.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'avalanche' as chain, * FROM avalanche.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
    UNION 
    SELECT 'bsc' as chain, * FROM bsc.defi.ez_dex_swaps WHERE block_timestamp > current_date - 7
)
-- 2. Aggregate volume and unique users across blockchains

SELECT
    platform as dex_platform,
    count(distinct(origin_from_address)) as total_users, 
    sum(amount_in_usd) as usd_volume
FROM dex_swaps
GROUP BY dex_platform

)
  1. Access the last seven days of all major dex volume with one line of SQL

-- Query the newly created view 
SELECT * FROM cross_chain.latest_weekly_dex_volume;
  1. Find your newly created view in the Data Explorer:

    • Expand your sandbox database

    • Expand the cross_chain schema

    • Expand Views

Access your Snowflake credentials in your account Settings:

https://flipsidecrypto.xyz/settings/snowflake
How to access my Snowflake account?
Where do I access Flipside's data in Snowflake?
How do I run my first query in Snowflake?
How to build on top of Flipside's data in Snowflake?