@lancedb/lancedb •Docs

@lancedb/lancedb / Connection

Class:abstract Connection

A LanceDB Connection that allows you to open tables and create new ones.

Connection could be local against filesystem or remote against a server.

A Connection is intended to be a long lived object and may hold openresources such as HTTP connection pools. This is generally fine anda single connection should be shared if it is going to be used manytimes. However, if you are finished with a connection, you may callclose to eagerly free these resources. Any call to a Connectionmethod after it has been closed will result in an error.

Closing a connection is optional. Connections will automaticallybe closed when they are garbage collected.

Any created tables are independent and will continue to work even ifthe underlying connection has been closed.

Methods

cloneTable()

abstractcloneTable(targetTableName,sourceUri,options?):Promise<Table>

Clone a table from a source table.

A shallow clone creates a new table that shares the underlying data fileswith the source table but has its own independent manifest. This allowsboth the source and cloned tables to evolve independently while initiallysharing the same data, deletion, and index files.

Parameters

• targetTableName:string The name of the target table to create.

• sourceUri:string The URI of the source table to clone from.

• options? Clone options.

• options.isShallow?:boolean Whether to perform a shallow clone (defaults to true).

• options.sourceTag?:string The tag of the source table to clone.

• options.sourceVersion?:number The version of the source table to clone.

• options.targetNamespace?:string[] The namespace for the target table (defaults to root namespace).

Returns

Promise<Table>

close()

abstractclose():void

Close the connection, releasing any underlying resources.

It is safe to call this method multiple times.

Any attempt to use the connection after it is closed will result in an error.

Returns

void

createEmptyTable()

createEmptyTable(name, schema, options)

abstractcreateEmptyTable(name,schema,options?):Promise<Table>

Creates a new empty Table

Parameters

• name:string The name of the table.

• schema:SchemaLike The schema of the table

• options?:Partial<CreateTableOptions> Additional options (backwards compatibility)

Returns

Promise<Table>

createEmptyTable(name, schema, namespace, options)

abstractcreateEmptyTable(name,schema,namespace?,options?):Promise<Table>

Creates a new empty Table

Parameters

• name:string The name of the table.

• schema:SchemaLike The schema of the table

• namespace?:string[] The namespace to create the table in (defaults to root namespace)

• options?:Partial<CreateTableOptions> Additional options

Returns

Promise<Table>

createTable()

createTable(options, namespace)

abstractcreateTable(options,namespace?):Promise<Table>

Creates a new Table and initialize it with new data.

Parameters

• options:object &Partial<CreateTableOptions> The options object.

• namespace?:string[] The namespace to create the table in (defaults to root namespace)

Returns

Promise<Table>

createTable(name, data, options)

abstractcreateTable(name,data,options?):Promise<Table>

Creates a new Table and initialize it with new data.

Parameters

• name:string The name of the table.

• data:TableLike |Record<string,unknown>[] Non-empty Array of Records to be inserted into the table

• options?:Partial<CreateTableOptions> Additional options (backwards compatibility)

Returns

Promise<Table>

createTable(name, data, namespace, options)

abstractcreateTable(name,data,namespace?,options?):Promise<Table>

Creates a new Table and initialize it with new data.

Parameters

• name:string The name of the table.

• data:TableLike |Record<string,unknown>[] Non-empty Array of Records to be inserted into the table

• namespace?:string[] The namespace to create the table in (defaults to root namespace)

• options?:Partial<CreateTableOptions> Additional options

Returns

Promise<Table>

display()

abstractdisplay():string

Return a brief description of the connection

Returns

string

dropAllTables()

abstractdropAllTables(namespace?):Promise<void>

Drop all tables in the database.

Parameters

• namespace?:string[] The namespace to drop tables from (defaults to root namespace).

Returns

Promise<void>

dropTable()

abstractdropTable(name,namespace?):Promise<void>

Drop an existing table.

Parameters

• name:string The name of the table to drop.

• namespace?:string[] The namespace of the table (defaults to root namespace).

Returns

Promise<void>

isOpen()

abstractisOpen():boolean

Return true if the connection has not been closed

Returns

boolean

openTable()

abstractopenTable(name,namespace?,options?):Promise<Table>

Open a table in the database.

Parameters

• name:string The name of the table

• namespace?:string[] The namespace of the table (defaults to root namespace)

• options?:Partial<OpenTableOptions> Additional options

Returns

Promise<Table>

tableNames()

tableNames(options)

abstracttableNames(options?):Promise<string[]>

List all the table names in this database.

Tables will be returned in lexicographical order.

Parameters

• options?:Partial<TableNamesOptions> options to control the paging / start point (backwards compatibility)

Returns

Promise<string[]>

tableNames(namespace, options)

abstracttableNames(namespace?,options?):Promise<string[]>

List all the table names in this database.

Tables will be returned in lexicographical order.

Parameters

• namespace?:string[] The namespace to list tables from (defaults to root namespace)

• options?:Partial<TableNamesOptions> options to control the paging / start point

Returns

Promise<string[]>