This dbt package creates models on top of Datawaves Decoded Projects Data that:
- Translate smart contract function calls and events into domain models
- Enrich trades and mints with details about associated the such as USD price for a token
- Provide balance table at different time granularity
The pre-built abstractions data models can be divided into two categories. The project abstractions are project-level models built on top of the Decoded Projects Data in Datawaves. And the sector abstractions combine models from multiple projects into one table representing a domain, e.g., NFT.
| Project | Models | description | Supported Chains |
|---|---|---|---|
| ens | ens_registrations | Each record represents a registration on ENS | Ethereum |
| ens | ens_reverse_registrars | Each record represents a reverse registrar on ENS | Ethereum |
| opensea | opensea_trades | Each record represents a trade in OpenSeas, enriched with USD price of the trade. | Ethereum |
| cryptopunks | cryptopunks_trades | Each record represents a trade in CryptoPunksMarket, enriched with USD price of the trade. | Ethereum |
| Sector | Models | description | Supported Chains |
|---|---|---|---|
| nft | nft_trades | Each record represents a trade, enriched with USD price of the trade. | Ethereum |
| nft | nft_mints | Each record represents an ERC721/ERC1155 token that has been minted. | Ethereum |
| erc20 | erc20_ethereum_transfers | Each record represents an ERC20 token transfer event. | Ethereum |
| erc721 | erc721_ethereum_transfers | Each record represents an ERC721 token transfer event. | Ethereum |
| erc1155 | erc1155_ethereum_transfers | Each record represents an ERC1155 token transfer event. | Ethereum |
To use this dbt project, you must have the following:
- Use Datawaves ETL Cloud to sync data into your destination.
- Make sure every source defined in
*_source.ymlexists in your destination. You can rundbt source freshnesscommand to ensure they are "fresh".
Include in your packages.yml:
packages:
- git: "https://github.com/datawaves-xyz/dbt_datawaves"
revision: "0.0.1"Additional contributions to this package are very welcome! Please create issues or open PRs against main.
This package has been tested on Databricks.