django-app-console.rst

Console App

primary(s): Gina Yuan
maintainer(s): Gina Yuan
location: src/apps/console

Console is a database terminal for datahub. It provides a way for users to interact directly with their database and repos/schemas, and is a consumer of the DataHub API.

How to use

• Run DataHub
• Navigate to apps/console
• Type SQL or bash commands

Available Commands:

help: lists available commands
e.g. help

connect <repo-base>: connect to a datahub user
e.g. connect username

mkrepo <repo-name>: create a new repository
e.g. mkrepo myrepo

rm <repo-name [-f]>: remove a repository
e.g. rm myrepo

ls : list repositories
e.g. ls

collab <repo-name> : list collaborators of a repository
e.g. collab myrepo

ls <repo-name> : list tables and views in a repository
e.g. ls myrepo

desc <table-name [-l]> : print schema info of a table [with data type]
e.g. schema myrepo.mytable

<other DML>: execute arbitrary DML on a repo.tablename in your currently connected repo-base
e.g. select * from myrepo.mytable