show_parsed_schemas(query)
The show_parsed_schema
function is designed to provide a structured representation of the schema. This function is particularly useful in Structured Data Extraction after you have extracted layout from the document to understand the schema output of a sub-query or a complex SQL statement without executing it against the actual database.
Syntax
SELECT * FROM show_parsed_schemas(query);
Usage Example
Following the example in extract_layout
CREATE TABLE pdf_blocks_billionaires
ENGINE = Memory AS
SELECT * FROM extract_layout(
(select * from load (
'https://en.wikipedia.org/api/rest_v1/page/pdf/The_World%27s_Billionaires'
)), type=> 'PDF', page_range=> [2,3])
select * from show_parsed_schemas((select * from pdf_blocks_billionaires)) where schema<> ''
Output
| table_index | schema |
|-------------|----------------------------------------------------------------------------------------------------------------------------|
| 0 | `No.` String,`Age` String,`Primary source(s) of wealth` String,`Name` String,`Net worth (USD)` String,`Nationality` String |