Error creating Iceberg Table in S3

Dremio Cloud
1

I have added a glue dataLake in DremioCLoud, and trying to create an iceberg table, dremio threw “Unable to create Table for Glue. Please set the default ware house location”

2

You will need to specify the s3 bucket that you want to create your tables in.

Follow the steps here to set the default ware house location:

  1. In Dremio Cloud, click the Amazon Glue datasource.
  2. Click the gear icon in the top-right corner above the list of the datasource’s contents.
  3. On the Advanced Options page of the Edit Source dialog, add this connection property: hive.metastore.warehouse.dir
  4. Set the value to the S3 address of an S3 bucket.