Get Started in Snowflake
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
Access your Snowflake credentials in your account Settings: https://flipsidecrypto.xyz/settings/snowflake
Log in to Snowflake by clicking on the Account URL
Enter your credentials and click "Sign in"
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.
Navigate to the left-hand side of the screen to find the "Data" section
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
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
Navigate to the left-hand side of the screen again to find the "Worksheet" section
Create a new worksheet by clicking on the "+" button in the top-right corner
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?
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.
Create a new SQL worksheet to write the code to generate a view
Access the last seven days of all major dex volume with one line of SQL
Find your newly created view in the Data Explorer:
Expand your sandbox database
Expand the cross_chain schema
Expand Views
Last updated