We are excited to announce the transition from V1 tables to temporary views and the deprecation of V1 endpoints and tables. The views allow equivalent (or close) queries to be performed with relatively low-performance overheads. This change is part of our efforts to reduce the operational, resource, and infrastructure burden on those who perform indexing, especially as we anticipate increased TPS events on the mainnet in the future.

Migration Timeline

June 24, 2024

• Ecosystem Indexer stop writing the following tables to AlloyDB:
  • move_resources
  • transactions
  • write_set_changes
  • table_items

June 20, 2024

• Ecosystem indexers should migrate to the v2 Aptos core processors
  • How to migrate if you’re running an Aptos core processor
• Migrate API users to calling the v2 API queries
  • v1 API queries will still work, but we highly recommend API users migrate to v2 queries as soon as possible since we plan to turn off the v1 queries within 1 month.
  • How to migrate for Indexer API users

July 22, 2024

• We will deprecate support for v1 migration views

How to migrate if you’re running an Aptos core processor

• If you’re running default_processor
  • A new flag will be available in the config for those who wish to discontinue writing to these tables. To take advantage of this option, please upgrade your processor and enable the new flag provided. see here
• If you’re running coin_processor
  • coin_processor will be deprecated. You will need to run fungible_asset_processor and backfill
    • Mainnet: 0
    • Testnet: 0
  • The migration views will support coin_processor queries backwards compatibility. These views are built on top of the fungible_asset_processor tables.
• If you’re running token_processor
  • token_processor will be deprecated. You will need to run token_v2_processor and backfill
    • Mainnet: 0
    • Testnet: 0
  • The migration views will support token_processor queries backwards compatibility. These views are built on top of the token_v2_processor tables.

How to migrate for Indexer API users

where: {`address`: {_eq: $address}}
order_by: {transaction_version: desc}
distinct_on: transaction_version
limit: $limit
offset: $offset

) { transaction_version __typename } } | query AccountTransactionsData($account_address: String, $limit: Int, $offset: Int) { account_transactions( where: {account_address: {_eq: $account_address}} order_by: {transaction_version: desc} distinct_on: transaction_version limit: $limit offset: $offset ) { transaction_version __typename } } | | | coin_activities | query CoinActivitiesQuery ( $addresses: [String], $contractAddresses: [String], $limit: Int ) { coin_activities( limit: $limit where: {
_and: { owner_address: { _in: $addresses }, coin_type: { _in: $contractAddresses }, is_gas_fee: {_eq: false}, is_transaction_success: {_eq: true}, activity_type: {_eq: "0x1::coin::DepositEvent"} }
} order_by: {block_height: asc} ) { amount coin_type owner_address block_height transaction_version } } | query CoinActivitiesQuery( $addresses: [String], $contractAddresses: [String], $limit: Int) { fungible_asset_activities(limit: $limit, where: {owner_address: {_in: $addresses}, asset_type: {_in: $contractAddresses}, is_gas_fee: {_eq: false}, is_transaction_success: {_eq: true}, type: {_eq: "0x1::coin::DepositEvent"}}, order_by: {block_height: asc}) { amount type owner_address block_height transaction_version } } | | | coin_infos | query GetCoinInfos($in: [String!], $offset: Int) { coin_infos(where: {coin_type: {_in: $in}}, offset: $offset, limit: 100) { symbol name decimals coin_type __typename } } | query MyQuery($address: String) { fungible_asset_metadata( where: {owner_address: {_eq: $address}} ) { asset_type amount

owner_address
transaction_timestamp
transaction_version

} } | | | current_coin_balances | query AccountCoinBalances($address: String) { current_coin_balances(where: {owner_address: {_eq: $address}}) { amount coin_type coin_type_hash last_transaction_version last_transaction_timestamp } } | query GetCoinBalances($address: String, $offset: Int) { current_fungible_asset_balances( where: {owner_address: {_eq: $address}} offset: $offset limit: 100 order_by: {amount: desc} ) { asset_type amount token_standard

} } | | | token_activities | query MyQuery1 {token_activities(where: {current_token_data: {current_collection: {collection_id: {_eq: ""}}}, entry_function_id_str: {_like: "%list%"}} order_by: {transaction_version: desc} offset:10 limit: 10) { token_data_id, transaction_timestamp } } | query MyQuery1 {token_activities_v2(where: {current_token_data: {current_collection: {collection_id: {_eq: ""}}}, entry_function_id_str: {_like: "%list%"}} order_by: {transaction_version: desc} offset:10 limit: 10) { token_data_id, transaction_timestamp } } | | | token_ownerships | query MyQuery($version: bigint) { token_ownerships(where: {transaction_version: {_eq: $version }}) { transaction_version owner_address amount } } | query MyQuery($version: bigint) { token_ownerships_v2(where: {transaction_version: {_eq: $version }}) { transaction_version owner_address amount } } | | | current_token_ownerships | query GetAccountNftListByCreatorAccount($address: String, $creatorAddress: String, $limit: Int, $offset: Int) { current_token_ownerships( where: {owner_address: {_eq: $address}, amount: {_gt: "0"}, creator_address: {_eq: $creatorAddress}} limit: $limit offset: $offset order_by: {name: asc} ) { amount collection_data_id_hash collection_name creator_address property_version last_transaction_timestamp last_transaction_version name owner_address property_version table_type token_data_id_hash token_properties __typename } } | query GetAccountNftListByCreatorAccount($address: String, $creatorAddress: String, $limit: Int, $offset: Int) { current_token_ownerships( where: {owner_address: {_eq: $address}, amount: {_gt: "0"}, creator_address: {_eq: $creatorAddress}} limit: $limit offset: $offset order_by: {name: asc} ) { amount collection_data_id collection_name creator_address proverty_version_v1 last_transaction_timestamp last_transaction_version token_name owner_address property_version table_type_v1 token_data_id_hash token_properties_muated_v1 __typename } } | | | current_token_datas | query getTokenMetadata($collection: String!, $creator: String!, $name: String!) { current_token_datas( where: {creator_address: {_eq: $creator}, collection_name: {_eq: $collection}, name: {_eq: $name}} ) { description largest_property_version maximum maximum_mutable properties_mutable royalty_mutable description_mutable uri_mutable name royalty_points_denominator royalty_points_numerator supply metadata_uri default_properties token_data_id_hash creator_address collection_name } } | query getTokenMetadata($collection: String!, $creator: String!, $name: String!) { current_token_v2_metadata( where: {creator_address: {_eq: $creator}, collection_name: {_eq: $collection}, name: {_eq: $name}} ) {

} | | | token_datas | query NftInfoByName($creator_address:String,$collection_name:String,$nftName:String) { token_datas( where: {name: {_eq: $nftName}, creator_address: {_eq: $creator_address},collection_name: {_eq: $collection_name}} ) { collection_name description name metadata_uri token_data_id_hash creator_address } } | query NftInfoByName($creator_address:String,$collection_name:String,$nftName:String) { token_datas_v2( where: {name: {_eq: $nftName}, creator_address: {_eq: $creator_address},collection_name: {_eq: $collection_name}} ) { collection_name description token_name token_uri token_data_id creator_address } } | | | current_token_datas | query getTokenMetadata($collection: String!, $creator: String!, $name: String!) { current_token_datas( where: {creator_address: {_eq: $creator}, collection_name: {_eq: $collection}, name: {_eq: $name}} ) { description largest_property_version maximum maximum_mutable properties_mutable royalty_mutable description_mutable uri_mutable name royalty_points_denominator royalty_points_numerator supply metadata_uri default_properties token_data_id_hash creator_address collection_name } tokens( where: {creator_address: {_eq: $creator}, collection_name: {_eq: $collection}, name: {_eq: $name}} ) { token_properties } } | query getTokenMetadata($collection: String!, $creator: String!, $name: String!) { current_token_datas_v2( where: {creator_address: {_eq: $creator}, collection_name: {_eq: $collection}, token_name: {_eq: $name}} ) { description largest_property_version_v1 maximum maximum_mutable properties_mutable royalty_mutable description_mutable uri_mutable token_name royalty_points_denominator royalty_points_numerator supply metadata_uri default_properties token_data_id_hash creator_address collection_name } tokens( where: {creator_address: {_eq: $creator}, collection_name: {_eq: $collection}, name: {_eq: $name}} ) { token_properties } } | | | current_collection_datas | query CollectionInfo($creator_address:String,$collection_name:String) { current_collection_datas( where: {creator_address: {_eq: $creator_address}, collection_name: {_eq: $collection_name}} limit: 1 ) { collection_name metadata_uri creator_address description supply maximum table_handle } } | query CollectionInfo($creator_address:String,$collection_name:String) { current_collections_v2( where: {creator_address: {_eq: $creator_address}, collection_name: {_eq: $collection_name}} limit: 1 ) { collection_name uri creator_address description current_supply max_supply table_handle_v1 } } | | | coin_balances | DEPRECATED | DEPRECATED | | | | | | |

‣