connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

how to query temporary table?

Open wonb168 opened this issue 1 year ago • 1 comments

Connector-X is renowned for its swift data table queries, but I need to retrieve results that require several steps of computation through temporary tables, like

CREATE TEMP TABLE t1 AS ...; 
CREATE TABLE t2 AS ...; 
...
SELECT * FROM tn ...; 

CANNOT use the WITH clause approach; there is too much historical code, and the workload to refactor it would be too large. How can I utilize Connector-X for this situation?

wonb168 avatar Oct 12 '24 01:10 wonb168