Getting Started

This guide will walk you through the process of creating a Snowflake account and accessing the Coherent Ethereum Dataset, a decoded and enriched dataset provided by Coherent Open Source.

Step 1: Create a Snowflake Account

  1. 1.
  2. 2.
    Fill in the requested information, including your full name, company name, email address, and phone number. Choose a secure password.
  3. 3.
    Check the box to agree to Snowflake's terms and conditions and privacy policy.
  4. 4.
    Click on "Start Free Trial" to create your account.
  5. 5.
    Check your email inbox for a verification email from Snowflake. Click on the link in the email to verify your account.

Step 2: Log into Snowflake

  1. 1.
    Navigate to the Snowflake login page.
  2. 2.
    Enter the email address and password you used to create your account, then click "Log In."

Step 3: Access the Coherent Ethereum Dataset

  1. 1.
    Once you're logged in, navigate to the Coherent Ethereum Dataset page.
  2. 2.
    Click on the "Get Data" button on the right side of the page.
  3. 3.
    Follow the prompts to set up the data share. You may need to select a role with the necessary permissions to accept the data share.
  4. 4.
    Once the data share is set up, you can access the Coherent Ethereum Dataset from your Snowflake account.

Step 4: Query the Coherent Ethereum Dataset

  1. 1.
    From your Snowflake dashboard, click on "Worksheets" in the top navigation bar.
  2. 2.
    In the new worksheet, you can write and execute SQL queries on the Coherent Ethereum Dataset. For example, you might use the following query to get a preview of the data:
WHERE from_address = '0xe67b8ac0ccf95c6ebdd2f8800246d73ff5058932'
Remember to replace "YOUR_TABLE_NAME" with the actual name of the table you want to preview.
Congratulations! You're now able to access and query the Coherent Ethereum Dataset using Snowflake. With this powerful tool at your disposal, you're ready to start exploring Ethereum's rich, decoded, and enriched data.