Secrets
Create an AWS SQS secret with the following CLI command:Secret requires
sqs:SendMessage permission. Refer to AWS SQS permissions
documentation
for more information.Processing Data
Typically, you would use SQS sync to cue data up and process for one reason or another. The data will have two high level fields:op: The operation type likecfor create,ufor update,dfor delete)body: The actual row data
op = d, typically it means it’s processing a fork or reorganization.
By default, the id of each of our datasets is consistent and meant for deterministic processing of blockchain forks. If you see a d, you can issue a delete for your downstream logic to negate the writing or processing of the data. The full body is provided for easy negation of aggregations.
If you’re enriching the data and then writing it into a database, you can just do upsert logic for c and u and then delete for d.