databasename-databasename文档介绍内容-阿里云

ALIYUN:PolarDBX:Database

DBInstanceId"]} },"DatabaseName":{"Description":"The name of the database.","Value":{"Fn:GetAtt":["ExtensionResource","DatabaseName"]} },"DatabaseDescription":{"Description":"Database description information.","Value":{...

GetMetaDBTableList

调用GetMetaDBTableList获取引擎实例中的表。调试您可以在OpenAPI Explorer中直接运行该接口，免去您计算.......tname</TableGuid> <DatabaseName>abc</DatabaseName></TableEntityList></Data></GetMetaDBTableListResponse>JSON 格式...

ListPermissions-获取权限列表

{"DatabaseName":"default","DatabaseWildcard":"*"},"TableResource":{"DatabaseName":"database_test","TableName":"test_parquet"},"FunctionResource":{"DatabaseName":"default","FunctionName":"default"},"ColumnResource":{...

GetSensitiveData

Name String 是[{"dbType":"hologres","instanceName":"ABC","databaseName":"abc"},{"dbType":"ODPS.ODPS","projectName":"adbc"}]获取访问记录的条件设置。可选的参数如下：dbType：数据类型。instanceName：实例名称。databaseName：...

GetTable-查询表信息

[{"Name":"name","Type":"long","Comment":"comment","DatabaseName":"databaseName","TableName":"tableName","MappedName":"mappedName","DataType":"long","CreateTime":"2023-01-05 13:17:55","UpdateTime":"2023-01-05 13:17:55",...

GetMetaTableBasicInfo

调用GetMetaTableBasicInfo接口获取表的...Action=GetMetaTableBasicInfo&TableGuid=odps.engine_name.table_name&ClusterId=abc&DatabaseName=abc&TableName=abc&DataSourceType=emr&Extension=false&公共请求参数正常返回示例 XML 格式 ...

GetOpSensitiveData

Name String 是[{"dbType":"hologres","instanceName":"ABC","databaseName":"abc"},{"dbType":"ODPS.ODPS","projectName":"adbc"}]获取访问记录的条件设置。可选的参数如下：dbType：数据类型。instanceName：实例名称。databaseName：...

FieldSchemaModel

Name string 列名。name Type string 列类型。long Comment string 列描述。comment DatabaseName string 逻辑库名。databaseName TableName string 逻辑表名。tableName MappedName string 映射名。mappedName DataType string 列数据类型...

Spark UDF

class_name 完整的class_name需要携带package信息，它的开发规范可以参考Spark和Hive的 FUNCTION 开发规范。resource_location_list 这个方法使用到的JAR包或者文件放置的位置,需要显式指定依赖的是JAR还是FILE：USING JAR 'oss:/test/...

读写RDS SQLServer数据

由于RDS MySQL中Database和Schema是等价的，只有一层结构，而RDS SQLServer有Database和Schema两层结构，因此DLA中创建RDS SQLServer Schema和表时与RDS MySQL稍有不同。步骤一：创建RDS SQLServer Schema 登录 DLA控制台。单击左侧导航栏...

GetOpRiskData

Action=GetOpRiskData&PageSize=100&PageNo=1&Name=[{"dbType":"hologres","instanceName":"ABC","databaseName":"abc"},{"dbType":"ODPS.ODPS","projectName":"adbc"}]&Date=20210221&RiskType=手工识别&公共请求参数正常返回示例 XML ...

ACS:HBR:RestoreHanaDatabaseBackup

动作描述将源实例数据库的备份恢复到测试实例，并检查恢复状态语法 Action:ACS:HBR:RestoreHanaDatabaseBackup Properties:vaultId:String sourceClusterId:String clusterId:String masterClientId:String databaseName:String HANASID:...

BatchRevokePermissions-批量取消对User/数据湖角色...

},"TableResource":{"DatabaseName":"database_test","TableName":"test_parquet"},"FunctionResource":{"DatabaseName":"default","FunctionName":"default"},"ColumnResource":{"DatabaseName":"default","TableName":"test",...

CreateDatabase-创建数据库

this is a test database 返回参数名称类型描述示例值 object 请求的返回结果。RequestId string 请求 ID。EE205C00-30E4-*-*-87E3A8A2AA0C DatabaseName string 数据库名称。sms_pre 示例正常返回示例 JSON 格式 {"RequestId":"EE205...

迁移RDS PostgreSQL数据到本地PostgreSQL

pg_dump-U<username>-h<hostname>-p<port><databasename>-f<filename>-exclude-table=public.ha_health_check 参数说明如下：参数说明 username 云数据库高权限账号名。如何创建高权限账号，请参见创建账号。hostname 云数据库主机名。...

BatchGrantPermissions-批量对User/数据湖角色授予...

default","DatabaseWildcard":"*"},"TableResource":{"DatabaseName":"database_test","TableName":"test_parquet"},"FunctionResource":{"DatabaseName":"default","FunctionName":"default"},"ColumnResource":{"DatabaseName":"default...

SearchMetaTables

name</TableName><DatabaseName>abc</DatabaseName><EntityType>0</EntityType><ProjectName>test</ProjectName><ProjectId>323</ProjectId><TableGuid>odps.engine_name.test_name</TableGuid><OwnerId>123</OwnerId><ClusterId>abc...

ModifyDatabaseUserRoles-修改数据库用户角色

对于 MySQL 模式，角色为数据库（Database）级别，其有以下几类：ReadWrite：读写权限，包括 ALL PRIVILEGES；ReadOnly：只读权限，包括 SELECT；DDL:DDL 权限，包括 CREATE,DROP,ALTER,SHOW VIEW,CREATE VIEW；DML:DML 权限，包括 SELECT,...

GetFunction-获取元数据库的指定函数

CreateTime":1608863962,"DatabaseName":"database_test","FunctionName":"function1","FunctionType":"JAVA","OwnerName":"zhangsan","OwnerType":"USER","ResourceUri":[{"ResourceType":"JAR","Uri":"hdfs:/tmp/jar1.jar"}],...

Davinci

postgresql:name:postgresql desc:postgresql version:driver:org.postgresql.Driver keyword_prefix:\"keyword_suffix:\"alias_prefix:\"alias_suffix:\"重启Davinci，完成JDBC驱动安装和PostgreSQL数据源配置。连接Hologres 登录Davinci...

LockObj

名称类型描述示例值 object LockObj CatalogId string 数据库分类命名空间，默认填写主账号 Uid 1344371 DatabaseName string 元数据库名称 database_test PartitionName string 分区名称，非必填 dt TableName string 元数据表名称 ...

查询迁移实例列表及各实例详情

true,"StructureInitialization":true },"MigrationJobID":"dtson2z28evm33*","MigrationObject":{"SynchronousObject":[{"DatabaseName":"dtstest","WholeDatabase":false,"TableList":{"Table":["customer"]} }]},"DataInitialization":{...

DescribeHanaBackupSetting-查询符合条件的SAP HANA...

cl-00068btz*oku DatabaseName string 否数据库名称。SYSTEMDB 返回参数名称类型描述示例值 object Code string 返回码，200 表示成功。200 Message string 返回信息描述，成功一般返回 successful，错误时会返回相应错误信息。...

TableResource

名称类型描述示例值 object 鉴权资源结构-Table DatabaseName string 数据库的名称。database_test TableName string 表名称。test_parquet

ListOperationDatabases-获取已授权的数据库列表

15 示例正常返回示例 JSON 格式 {"Databases":[{"ActiveAddressType":"Private","Comment":"cpp","DatabaseId":"26","DatabaseName":"zDatabase","DatabasePort":3306,"DatabasePrivateAddress":"rm-b*9b.mysql.rds.aliyuncs.com",...

FunctionResource

名称类型描述示例值 object 鉴权资源结构-Table DatabaseName string 数据库的名称。default FunctionName string 函数名称 default

ColumnResource

名称类型描述示例值 object 鉴权资源结构-Column DatabaseName string 数据库的名称。default TableName string 表的名称。test ColumnNames array 字段名列表。string 字段名。name

Datastream JAR迁移

RDS RDS_URL URL的格式为：jdbc:mysql:/<内网地址>/<databaseName>，其中<databaseName>为对应的数据库名称。云数据库RDS版专有网络VPC地址，即内网地址，详情请参见查看或修改内外网地址和端口。RDS_USER_NAME 用户名。RDS_PASSWORD ...

DatabaseResource

名称类型描述示例值 object 鉴权资源结构-Database DatabaseName string 数据库的名称。default DatabaseWildcard string A wildcard member representing every resource under a database*

ListFunctions-获取元数据库的函数列表

com.xxx.xxxxFunction","CreateTime":1608863962,"DatabaseName":"database_test","FunctionName":"function1","FunctionType":"JAVA","OwnerName":"zhangsan","OwnerType":"USER","ResourceUri":[{"ResourceType":"JAR","Uri":"hdfs:/tmp...

DescribeHanaBackupPlans-查询符合条件的SAP HANA备份...

10 DatabaseName string 否数据库名称。SYSTEMDB ResourceGroupId string 否资源组 ID。rg-acfmvywqfey5njq 返回参数名称类型描述示例值 object RequestId string 请求 ID。F029C1C7-26B6-5ADD-A73E-D85CCD7C73A9 Success boolean ...

查询一个订阅实例状态

SynchronousObject DatabaseName String dtstestdata 订阅对象所属数据库的名称。TableList List test1 订阅对象的表名。WholeDatabase String false 是否订阅整库，返回值：true：是。false：否。Success String true 请求是否成功。...

ListDatabasesForUser-查询用户已授权的数据库列表

15 示例正常返回示例 JSON 格式 {"Databases":[{"ActiveAddressType":"Private","Comment":"comment","DatabaseId":"36","DatabaseName":"MySQL56","DatabasePort":3306,"DatabasePrivateAddress":"rm-wz97*","DatabasePublicAddress":"rm...

DescribeHanaRetentionSetting-查询符合条件的SAP ...

cl-0003jyv*fsku5m 示例正常返回示例 JSON 格式 {"RequestId":"280DD872-EE25-52E8-9CB4-491067173DD0","VaultId":"v-0006wkn7*zkn","Schedule":"I|0|P1D","Success":true,"DatabaseName":"Q01","Disabled":false,"Code":"200",...

GetTableVersion-获取元数据表指定版本

1608707407,"CreatedBy":"zhangsan","DatabaseName":"database_test","LastAccessTime":1608707407,"LastAnalyzedTime":1608707407,"Owner":"zhangsan","OwnerType":"USER","PartitionKeys":[{"Comment":"comment_day","Name":"day","Type...

Partition

名称类型描述示例值 object Partition CreateTime integer 创建时间，Unix 时间戳秒数 1608730999 DatabaseName string 元数据库名称 database_test LastAccessTime integer 上一次访问分区的时间 1608730999 LastAnalyzedTime integer ...

CheckMetaTable

调用CheckMetaTable检查表是否存在。调试您可以在OpenAPI Explorer...Action=CheckMetaTable&TableGuid=odps.engine_name.table_name&ClusterId=abc&DatabaseName=abc&TableName=abc&DataSourceType=emr&公共请求参数正常返回示例 XML 格式 ...

GetTable-获取元数据表详情

DatabaseName":"database_test","LastAccessTime":1608707407,"LastAnalyzedTime":1608707407,"Owner":"zhangsan","OwnerType":"USER","PartitionKeys":[{"Comment":"comment_day","Name":"day","Type":"int"}],"Privileges":{},...

ListDatabasesForUserGroup-查询用户组已授权的数据库...

15 示例正常返回示例 JSON 格式 {"Databases":[{"ActiveAddressType":"Private","Comment":"comment","DatabaseAccountCount":2,"DatabaseId":"2","DatabaseName":"MySQL0","DatabasePort":3306,"DatabasePrivateAddress":"rm-bp1*",...

GetTableProfile-获取表数据概况

请求语法 GET/webapi/metastorehouse/catalog/database/tableprofile 请求参数名称类型必填描述示例值 CatalogId string 否数据目录 ID，默认填写主账号 ID 1344371 DatabaseName string 是元数据库名称 test_db TableName string ...

databasename

新品推荐