1 of 1

Configuration

Plugin Parameters

A single configuration file is needed. The config file should be placed in the catalog folder (e.g.,/etc/trino/conf/catalog on EMR) and named tiledb.properties.

Sample file contents:

connector.name=tiledb
# Set read buffer to 10M per attribute
read-buffer-size=10485760

The following parameters can be configured in the tiledb.properties and are plugin-wide.

Session Parameters

These can be set as follows:

set session tiledb.<param>=<value>
// E.g., set session tiledb.splits=10

Unset session parameters inherit the plugin configuration defaults. The list of session parameters is summarized below"

Table properties

These are set upon table creation as follows:

create table my_table(
  ...
  ) with (uri = '<array-uri>', type='SPARSE', cell_order='ROW_MAJOR`, ...);

Column Parameters

These are set upon table creation as follows:

create table my_table(
  dim0 bigint with (dimension=true, lower_bound=0, upper_bound=100, extent=10),
  ...
  ) with (uri = '<array-uri>', type = 'SPARSE');

Configuration

Plugin Parameters

A single configuration file is needed. The config file should be placed in the catalog folder (e.g.,/etc/trino/conf/catalog on EMR) and named tiledb.properties.

Sample file contents:

connector.name=tiledb
# Set read buffer to 10M per attribute
read-buffer-size=10485760

The following parameters can be configured in the tiledb.properties and are plugin-wide.

Session Parameters

These can be set as follows:

set session tiledb.<param>=<value>
// E.g., set session tiledb.splits=10

Unset session parameters inherit the plugin configuration defaults. The list of session parameters is summarized below"

Table properties

These are set upon table creation as follows:

create table my_table(
  ...
  ) with (uri = '<array-uri>', type='SPARSE', cell_order='ROW_MAJOR`, ...);

Column Parameters

These are set upon table creation as follows:

create table my_table(
  dim0 bigint with (dimension=true, lower_bound=0, upper_bound=100, extent=10),
  ...
  ) with (uri = '<array-uri>', type = 'SPARSE');