lock\_table(table\_name=None, lock\_type='status', options={"{"}{"}"})\[source]

Manages global access to a table’s data. By default a table has a input parameter lock\_type of read\_write, indicating all operations are permitted. A user may request a read\_only or a write\_only lock, after which only read or write operations, respectively, are permitted on the table until the lock is removed. When input parameter lock\_type is no\_access then no operations are permitted on the table. The lock status can be queried by setting input parameter lock\_type to status.

Parameters

table\_name (str) –

Name of the table to be locked, in \[schema\_name.]table\_name format, using standard name resolution rules. It must be a currently existing table or view.

lock\_type (str) –

The type of lock being applied to the table. Setting it to status will return the current lock status of the table without changing it. Allowed values are:

status – Show locked status.
no\_access – Allow no read/write operations.
read\_only – Allow only read operations.
write\_only – Allow only write operations.
read\_write – Allow all read/write operations.

The default value is ‘status’.

options (dict of str to str) –

Optional parameters. The default value is an empty dict ( {"{"}{"}"} ).

Returns

A dict with the following entries–

lock\_type (str) –

Returns the lock state of the table.

info (dict of str to str) –

Additional information.