CREATE TABLE MwAction(                                                                                                      
    revids integer, -- this field will be part of the query string (revids=<val>). It's name should match the action api param    
    domain string, -- special field (not part of action api) that we need to set in the request Host header when hitting internal endpoints.           
    response string -- special field (not part of action api) that will store the action api response content.              
) WITH (                                                                                                                    
    'connector' = 'mediawiki-http',                                                                                         
    'format' = 'json', -- TODO: we don't need really this, since internally we don't need to serialize data as Json.        
    'url' = 'https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&formatversion=2&rvprop=content&rvslots=main', -- the base url to query. Can contain defaults query string params. Query parameters could also be declared as table columns, and used in where clauses (... where rvslots = 'main');            
    -- 'fields.domain' = 'domain', -- Optional field that stores the domain (default: `domain`). When present, it will      
    -- be used to set the Host request header.                                                                              
    'fields.response' = 'response', -- Field stores the response payload (default: `response`).                             
    'http.client.header.user-agent' = 'wmf-mediawiki-stream-enrichment/1.0-SNAPSHOT bot'                                    
);

SELECT                                                                                                                  
    mw_action.revids,                                                                                                   
    mw_action.domain,                                                                                                   
    JSON_VALUE(mw_action.response, '$.query.pages[0].revisions[0].slots.main.content') as wikitext -- parse response content and extract wikitext.
FROM MockRevisionCreate AS revision_create JOIN MwAction FOR SYSTEM_TIME AS OF revision_create.proc_time AS mw_action   
ON revision_create.rev_id = mw_action.revids                                                                            
where mw_action.domain = 'en.wikipedia.org'; -- this should be a field we join on, extracted from `meta`.

+----+-------------+--------------------------------+--------------------------------+
| op |      revids |                         domain |                       wikitext |
+----+-------------+--------------------------------+--------------------------------+
| +I |        1000 |               en.wikipedia.org | <table align=center><tr val... |
| +I |        1001 |               en.wikipedia.org |                         <NULL> |
| +I |        1002 |               en.wikipedia.org | I teach math at Metropolita... |
| +I |        1003 |               en.wikipedia.org | '''Richard Nixon''' was the... |
| +I |        1004 |               en.wikipedia.org | '''Apoptosis''' describes t... |
| +I |        1005 |               en.wikipedia.org | The city of [[Tallinn]] is ... |
+----+-------------+--------------------------------+--------------------------------+