跳转至

AliYun OSS

What is Aliyun OSS ?

Fully managed object storage service to store and access any amount of data from anywhere

Environment


Note

If you need to use this data source, you need to upgrade the DataCap service to >= 1.6.x

Support Time: 2023-02-23

SQL statement syntax


This chapter describes the SQL syntax used in Aliyun OSS on DataCap.

SELECT

Synopsis

SELECT [ * | <Columns> ] select_expression [, ...]
FROM from_item [. ...]

where from_item is one of

table_name [ `a.b` | a.b | `a`.`b`]

Danger

When table_name is set to all the root directory is searched.

Select expressions

Each select_expression must be in one of the following forms:

expression [ column_alias ]
*

In the case of expression [ column_alias ], a single output column is defined.

In the case of *, all columns of the relation defined by the query are included in the result set.

    *
--------
   data

Danger

If it is a multi-level directory, such as /oss/id/2, it will be written `oss`.`id`.`2`, and use . to split between directories.

Configure


DataCap uses configuration files by default alioss.json

Note

If your Aliyun OSS service version requires other special configurations, please refer to modifying the configuration file and restarting the DataCap service.

Field Required Default Value
Name :material-check-circle: -
Host :material-check-circle: https://oss-cn-regison.aliyuncs.com
Field Required Description Default Value
Username :material-check-circle: access Id -
Password :material-check-circle: access Secret -
Field Required Description Default Value
Database :material-check-circle: bucket name default

Version (Validation)


Warning

The online service has not been tested yet, if you have detailed test results, please submit issues to us

  • all version

评论