Getting Started: Web App

Last updated 2 years ago

Getting Started: Web App

Here we'll show you how to get started with Nansen Query in less than 5 mins. Please note that Nansen Query is a paid feature, and requires action to be taken prior to use. If you're interested in a trial, please don't hesitate to .

Visit and log in with your Nansen.ai account, you'll land on the home page.
Click on the "New Query" Icon on the upper right to start writing SQL in the Web IDE
The IDE has three major functionalities:
- A Schema Browser: For finding the relevant dataset to run queries against
- The SQL Editor: To write and execute specific SQL commands
- A Data Visualization section: To display results in tabular or graphical format
In the SQL Editor, type in the sample code below and click on the Execute button at the bottom of the SQL Editor. This query will return the top 50 addresses by their ETH balance on Ethereum

SELECT
    SUM(CAST(balance / 1e18 AS FLOAT64)) AS eth_balance,
    address
FROM `nansen-query.raw_ethereum.balances`
GROUP BY address
ORDER BY eth_balance DESC
LIMIT 50

Once the query is completed, the result will appear in the Data Visualization section
To create a visualization for the query results, click on the "Add Visualization" button at the top of the Data Visualization section. This will lead you to the Visualization Editor
Nansen Query supports multiple chart types. In this example, we will select: "Pie" as the Chart Type "address" as the X Column "eth_balance" as the Y Column A preview of the chart should appear in the editor, click "Save" to exit the Visualization Editor
The chart will be saved and will now appear in the Data Visualization section
For each visualization (table or chart), clicking on the vertical ellipsis [⋮] icon on the lower left section will bring up additional functionalities such as adding the visualization to a Dashboard or downloading the result as a CSV, TSV, or Excel file

The above are the major functionalities of the Web Editor. For more detailed documentaiton, please visit the detailed documentation guide for each major functionality.

PreviousOverview NextMy Queries

Last updated 2 years ago

Visit and log in with your Nansen.ai account, you'll land on the home page.
Click on the "New Query" Icon on the upper right to start writing SQL in the Web IDE
The IDE has three major functionalities:
- A Schema Browser: For finding the relevant dataset to run queries against
- The SQL Editor: To write and execute specific SQL commands
- A Data Visualization section: To display results in tabular or graphical format
In the SQL Editor, type in the sample code below and click on the Execute button at the bottom of the SQL Editor. This query will return the top 50 addresses by their ETH balance on Ethereum

SELECT
    SUM(CAST(balance / 1e18 AS FLOAT64)) AS eth_balance,
    address
FROM `nansen-query.raw_ethereum.balances`
GROUP BY address
ORDER BY eth_balance DESC
LIMIT 50

Once the query is completed, the result will appear in the Data Visualization section
To create a visualization for the query results, click on the "Add Visualization" button at the top of the Data Visualization section. This will lead you to the Visualization Editor
Nansen Query supports multiple chart types. In this example, we will select: "Pie" as the Chart Type "address" as the X Column "eth_balance" as the Y Column A preview of the chart should appear in the editor, click "Save" to exit the Visualization Editor
The chart will be saved and will now appear in the Data Visualization section
For each visualization (table or chart), clicking on the vertical ellipsis [⋮] icon on the lower left section will bring up additional functionalities such as adding the visualization to a Dashboard or downloading the result as a CSV, TSV, or Excel file

The above are the major functionalities of the Web Editor. For more detailed documentaiton, please visit the detailed documentation guide for each major functionality.