Common MaxCompute SQL developer commands supported by Dataphin-Dataphin(Dataphin)-阿里云帮助中心

This topic describes the common MaxCompute SQL developer commands supported by Dataphin.

Category	Common command	Supported
Project operations	Enter a project	Support
	View project properties	No
	Set project properties	No
	View the account system of a project	Support
	Add a RAM account system	Support
	Delete a RAM account system	Support
set operations	set	Support
set operations	show flags	No
Security operations	Security operations	No
	Add a trusted project	No
	Remove a trusted project	No
	View trusted projects	No
	View the secure configuration of a project	No
User and role operations	Add a user	Support
	Delete a user	Support
	View the user list	Support
	Create a role	No
	View the role list	Support
	Grant a role to a user	Support
	Remove a user from a role	Support
	Delete a role	No
Authorization operations	Grant permissions to a role or user (grant)	Support
Authorization operations	Revoke permissions from a role or user (revoke)	Support
Table operations	Create a table (create table)	Support
	Change the owner of a table (alter table)	Support
	Delete a table (drop table)	Support
	View table or view information (desc)	Support
	View partition information (desc partition)	Yes
	List tables in a project (show tables)	Support
Partition and column operations	Add a partition	Support
	Delete a partition	Support
	Add a column or comment	Support
	Change a column name and comment (alter table change)	Support
Instance operations	View instance information (show)	No
	View instance status (status)	No
	View information about running instances (top instance)	No
	Stop an instance (kill)	No
	Obtain job information for an instance (desc)	No
	Obtain operational log information for a job (wait)	No
Resource operations	Add a resource	No
	View the resource list (list)	Support
	Create an alias for a resource (alias)	No
	Download a resource (get)	No
	Delete a resource (drop)	No
Function operations	Register a function (create function)	No
	Unregister a function (drop function)	No
	View a function (desc function)	No
	View the function list (list function)	No
Tunnel operations	Upload data (Tunnel upload)	No
Tunnel operations	Download data (Tunnel download)	No
Time zone configuration operations	Time zone configuration operations	No
Other operations	Cost estimation	No

上一篇: MaxCompute SQL and function support 下一篇: SQL limits