Search
⌃K
Links
❄

Snowflake

Introduction

Snowflake is the ultimate data warehouse solution. With Snowflake, you'll have access to comprehensive historical data as well as smaller datasets, all in one convenient place.
Snowflake operates on a pay-per-use model, meaning you'll only be charged for the computation and storage of data within your account. Data shared by us, on the other hand, will not incur any storage fees. All the profit will be redirected to our Coherent multisig to fund more public goods!!
😄
​
This guide will provide a quick overview of how to sign up for Snowflake and access our data sets. The guide is divided into three sections, each covering a specific aspect of the Snowflake experience.
  1. 1.
    Sign up for a new Snowflake account
  2. 2.
    Decide what data sets you are most interested in
  3. 3.
    How we recommend using our data sets

Getting Started with Coherent shares on the Snowflake Marketplace

1. Sign Up for Snowflake

After verifying your email, follow these steps to activate your Snowflake account and retrieve your account identifier for later use:
  1. 1.
    Click on the "Click to activate" button in the email from Snowflake.
  2. 2.
    Create a username and password for your Snowflake account.
  3. 3.
    Log in to your Snowflake account using your new credentials.
  4. 4.
    Locate your account identifier. This can be found in the "Welcome to Snowflake" email, where it is the hyphenated string that precedes the snowflakecomputing.com URL. Alternatively, you can build it by concatenating the organization identifier, a hyphen, and then the account name. The resulting string should look like this: "pigmauz-pb71576".
  5. 5.
    Save your account identifier for later. You will need it for your connection parameters.
Once you have retrieved your account identifier, you can proceed to access Coherent on the Snowflake Marketplace.

2. Locate and set up Coherent data from the Snowflake Marketplace

  1. 1.
    Navigate to the Snowflake Marketplace at https://app.snowflake.com/marketplace.
  2. 2.
    In the Snowflake Marketplace, search for Coherent as your data provider
  3. 3.
    Click any of the available datasets.
  4. 4.
    Click "Get" and setup your privileges for your dataset. Make sure to not change the name of the database, this will cause issues when running Coherent's DBTs.
  5. 5.
    Your dataset is now ready to be queried/transformed!
Note: If you wish to run our sample DBTs from our repository, you must add the following data sources from the marketplace:
  1. 1.
    Ethereum Raw Data
  2. 2.
    EVM Contract Fragments Data

3. Agree to the Snowflake Third Party Terms

Coherent DBTs depend on Anaconda 3rd party packages, and Anaconda terms must be accepted by ORGADMIN to use Anaconda 3rd party packages.
  1. 1.
    Sign in to Snowsight. Make sure you are logged into an account with the ORGADMIN role.
  2. 2.
    Select Admin » Billing & Terms.
  3. 3.
    In the Anaconda section, select Enable.
  4. 4.
    In the Anaconda Packages dialog, click the link to review the Snowflake Third Party Terms page.
  5. 5.
    If you agree to the terms, select Acknowledge & Continue.
Once you've successfully set up the Coherent Dataset through the Snowflake Marketplace, you can start using the product within your Snowflake environment. For more information on how to use our open-source DBTs, consult the product documentation provided on the listing page or visit the Coherent website.