HTTP Parquet Import

SereneDB can read Parquet files over http(s):

SQL

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

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

For example:

SQL

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

 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:

SQL

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

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