Nodle Dashboards¶
Overview¶
Nodle is a parachain on Polkadot focused on providing connectivity and data liquidity for the Internet of Things (IoT). It enables devices to securely connect, interact, and transact with efficiency.
Featured Dashboards on Dune¶
Here you will find a variety of dashboards that help visualize data from the Nodle parachain:
- Nodle Dashboard: A comprehensive view of IoT connectivity and transactions within the Nodle ecosystem.
Please also visit our dashboards for Nodle on Dune Analytics.
Key Tables¶
Data from the Nodle parachain is organized into several key tables:
nodle.balancesnodle.blocksnodle.callsnodle.eventsnodle.extrinsicsnodle.transfers
Start building your own queries using granular data on Dune here.
Useful Queries¶
Some useful queries for Nodle are provided:
| Title | Query | Description |
|---|---|---|
| Nodle Mint Uniques | query_3753531 | This query retrieves data on Unique NFTs minted within the Nodle ecosystem. |
Getting Started with Queries¶
To get started with querying data from Unique, you are welcome to use the mentioned materialized queries. You can use the following DuneSQL queries as examples:
sql title="Nodle Mint Uniques" showLineNumbers
SELECT DISTINCT
block_time,
JSON_EXTRACT_SCALAR(call_args, '$.owner.id') AS owner,
JSON_EXTRACT(call_args, '$.collection') AS collection,
JSON_EXTRACT(call_args, '$.item') AS item
FROM
nodle.calls
WHERE
(call_section = 'nodleUniques' OR call_section = 'uniques')
AND call_method = 'mint'
AND extrinsic_id NOT IN (
SELECT
extrinsic_id
FROM
nodle.events
WHERE
method = 'ExtrinsicFailed'
);
Query result:
DuneSQL Reference
For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.