Create SCW factory mapping

[ccerv1]

What is it?

Here's the basic query from Bundle Bear:

SELECT 
'base' AS CHAIN,
TO_ADDRESS AS ADDRESS,
FROM_ADDRESS AS FACTORY_CONTRACT,
l.NAME AS FACTORY_NAME
FROM BASE.RAW.TRACES t
INNER JOIN BUNDLEBEAR.DBT_KOFI.ERC4337_LABELS_FACTORIES f
ON t.FROM_ADDRESS = f.ADDRESS
WHERE TRACE_TYPE IN ('create','create2')
AND BLOCK_TIMESTAMP > DATE('2023-01-01')

UNION ALL
SELECT 
'optimism' AS CHAIN,
TO_ADDRESS AS ADDRESS,
FROM_ADDRESS AS FACTORY_CONTRACT,
l.NAME AS FACTORY_NAME
FROM OPTIMISM.RAW.TRACES t
INNER JOIN BUNDLEBEAR.DBT_KOFI.ERC4337_LABELS_FACTORIES f
ON t.FROM_ADDRESS = f.ADDRESS
WHERE TRACE_TYPE IN ('create','create2')
AND BLOCK_TIMESTAMP > DATE('2023-01-01')

UNION ALL
-- REPEAT FOR ALL CHAINS IN SUPERCHAIN DATASET

[linear[bot]]

OSO-726 Create SCW factory mapping