HTTP Parquet Import

SereneDB can read Parquet files over http(s):

Query

SELECT * FROM read_parquet('https://⟨domain⟩/path/to/file.parquet');

Result

 id | name  | value----+-------+-------  1 | alpha |    10  2 | beta  |    20

For example:

Query

SELECT * FROM read_parquet('https://⟨domain⟩/data/prices.parquet');

Result

 a | b     | c---+-------+----- 1 | [2,3] | 4.5 2 | [5,8] | 9.5

Moreover, the read_parquet function itself can also be omitted thanks to the replacement scan mechanism:

Query

SELECT * FROM 'https://⟨domain⟩/data/holdings.parquet';

Result

 a | b     | c---+-------+----- 1 | [2,3] | 4.5 2 | [5,8] | 9.5