Data Sources

Create lightning-fast pipelines with your subgraphs or live streams by Goldsky and the community.

Dataset

Decoded Logs

Chain

Immutable Testnet

Example data

1

Column	Type	Value
`address`	string	0x0000000000000000000000000000000000001010
`decode_strategy`	string	abi
`event_params`	array	0x0101010101010101010101010101010101010101, 0x0000000000000000000000000000000000000105, 0
`event_signature`	string	Approval(address,address,uint256)
`id`	string	decoded_log_0xe52cfcfdbae0635c5b8d0323842b18dd7d4c46a568bdbae005a30dbef96007d2_1
`raw_log`	record	{"address":"0x0000000000000000000000000000000000001010","block_hash":"0xe52cfcfdbae0635c5b8d0323842b18dd7d4c46a568bdbae005a30dbef96007d2","block_number":4302600,"block_timestamp":1700426597,"data":"0x0000000000000000000000000000000000000000000000000000000000000000","id":"log_0xe52cfcfdbae0635c5b8d0323842b18dd7d4c46a568bdbae005a30dbef96007d2_1","log_index":1,"topics":"0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925,0x0000000000000000000000000101010101010101010101010101010101010101,0x0000000000000000000000000000000000000000000000000000000000000105","transaction_hash":"0x29c198b5c0a7ddc70ce1eea4404074bf7982501c9401a7a4782d1b3c7b3ba7ad","transaction_index":1}
`transaction_hash`	string	0x29c198b5c0a7ddc70ce1eea4404074bf7982501c9401a7a4782d1b3c7b3ba7ad

Configuration

To create a pipeline with this configuration, download the configuration below and replace YOUR_DATABASE_SECRET with your database secret. Then, run goldsky pipeline apply immutable-testnet-decoded-logs.yaml to create the pipeline.

immutable-testnet-decoded-logs.yaml

Loading editor...

name: immutable-testnet-decoded-logs
apiVersion: 3
sources:
  immutable_testnet.decoded_logs:
    dataset_name: immutable_testnet.decoded_logs
    type: dataset
    version: 1.0.0
transforms:
  immutable_testnet_decoded_logs:
    primary_key: id
    sql: |-
      SELECT 
      address, 
      event_signature, 
      event_params, 
      raw_log.block_number       as block_number, 
      raw_log.block_hash         as block_hash, 
      raw_log.log_index          as log_index, 
      raw_log.transaction_hash   as transaction_hash, 
      raw_log.transaction_index  as transaction_index, 
      id 
      FROM immutable_testnet.decoded_logs
    description: Unnesting raw_log
sinks:
  postgres_immutable_testnet_decoded_logs:
    type: postgres
    table: immutable_testnet_decoded_logs
    schema: public
    secret_name: YOUR_DATABASE_SECRET
    description: 'Postgres sink for: immutable_testnet_decoded_logs'
    from: immutable_testnet_decoded_logs

Docs

Pricing