Skip to content

Latest commit

 

History

History
29 lines (21 loc) · 1022 Bytes

README-file.md

File metadata and controls

29 lines (21 loc) · 1022 Bytes
Raw

Filesystem catalog

Catalog URL

frostbow -u s3://warehouse

For the Filesystem catalog you have to specify a bucket. The File catalog then translates SQL identifiers into file paths (object prefixes). If you use the table identifier staging.sales.orders the table location will be translated to s3://warehouse/staging/sales/orders.

Credentials

Frostbow uses the aws-sdk to determine your credentials. Please read the official AWS documentation on how to obtain your credentials.

Location

The Filesystem catalog automatically determines the LOCATION parameter for the table creation. However, you still have to add an empty string in the SQL command, like so:

CREATE TABLE iceberg.public.orders (
      id BIGINT NOT NULL,
      order_date DATE NOT NULL,
      customer_id INTEGER NOT NULL,
      total_price DOUBLE NOT NULL
)
STORED AS ICEBERG
LOCATION ''
PARTITIONED BY ( "month(order_date)" );