CREATE BLOB TABLE
- Synopsis
- Description
  - blobs_path

`CREATE BLOB TABLE`

Define a new table for storing binary large objects.

Table of Contents

Synopsis
Description
- blobs_path

Synopsis

CREATE BLOB TABLE table_name
[CUSTERED [ BY (routing_column) ] INTO num_shards SHARDS ]
[ WITH ( storage_parameter [= value] [, ... ] ) ]

Description

CREATE BLOB TABLE will create a new table for holding BLOBS. For details and examples see Blobs.

The CLUSTERED and WITH clauses follow the same semantics described under CLUSTERED and WITH.

Additional to the storage parameter described at WITH, following parameters are supported here:

`blobs_path`

Specifies a custom path for storing blob data of a blob table.

blobs_path:	The custom path for storing blob data as a string literal value or string parameter. The path can be either absolute or relative and must be creatable/writable by the user CrateDB is running as. A relative path value is relative to CRATE_HOME. This path take precedence over any global configured value.

blobs_path:

The custom path for storing blob data as a string literal value or string parameter.

The path can be either absolute or relative and must be creatable/writable by the user CrateDB is running as. A relative path value is relative to CRATE_HOME. This path take precedence over any global configured value.