Question

Is there a way to rename mydb tables?

Answer 1

The latest version of the Data Lab client package contains a "mydb_rename(<old>,<new>)" method in the queryClient to rename tables.  For example,

>>> from dl import queryClient as qc
>>> print(qc.list())
test
>>> qc.mydb_rename('test','foo')
'OK'
>>> print(qc.list())
foo
 

You can install the package using 'pip' with:

    pip install --upgrade noaodatalab

See also http://github.com/noaodatalab/datalab

Comments

And when you have the datalab package installed, you can also do the rename from the CMD line (after logging in):

datalab mydb_rename old=test new=foo