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

sql
SELECT [ * | <Columns> ] select_expression [, ...]
FROM from_item [. ...]
where from_item is one of
sql
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:
sql
expression [ column_alias ]
sql
*
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.
sql
    *
--------
   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 -
Host https://oss-cn-regison.aliyuncs.com
Version (Validation)

Warning

The online service has not been tested yet, if you have detailed test results, please submit issues to us
  • all version
提交于 2025年2月19日 13:48
修改于 2025年2月19日 13:48
首次提交 (b1e5f80c)
末次提交 (b1e5f80c)
贡献者
qianmoQ
qianmoQ
1 次提交

目录