检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
- Enable SSL If Enable SSL is selected, the client can use SSL to encrypt connections. The SSL connection mode is more secure than common modes, so you are advised to enable SSL connection. - If Enable SSL is selected, download the SSL certificate and decompress it.
You can use pgcrypto to encrypt data. Developer Guide > Database Security Management> Sensitive Data Management> Use pgcrypto to Encrypt Data The object_name column in the audit log records all read and write objects in the SQL statement.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 DROP FOREIGN TABLE product_info_ext; CREATE FOREIGN TABLE product_info_ext
(Optional) Database encryption key (DEW) If you have enabled the Encrypt DataStore function for a cluster and purchased a key on DEW, the key is not deleted after you delete the cluster. Manually unsubscribe from and delete the key to stop billing.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. TYPE indicates the server type. Retain the value OBS. Create the OBS foreign table json_f and define the column names.
port=''][human_resource][2017-07-21 16:06:31]: dump database human_resource successfully gs_dump[port=''][human_resource][2017-07-21 16:06:31]: total time: 2522 ms Example 5: Use gs_dump to run the following command to export the object definitions of the hr and public schemas, encrypt
This feature is supported in 8.1.2 or later. encrypt Specifies whether data is encrypted. This parameter is available only when type is OBS. The default value is off.
For security, encrypt your AK/SK and store them in the configuration file or environment variables. If the message "ERROR: schema "xxx" does not exist Position" is displayed when you create a foreign table, the schema does not exist.
For security, encrypt your AK/SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 CREATE FOREIGN TABLE obs_from_store_sales_001 ( ss_sold_date_sk
gs_dump[port=''][human_resource][2018-11-14 11:32:02]: dump database human_resource successfully gs_dump[port=''][human_resource][2018-11-14 11:32:02]: total time: 1645 ms Example 8: Use gs_dump to run the following command to export data and definition of the hr.staffs table, encrypt
SSL authentication is used to encrypt communication data between the client and the server. It safeguards sensitive data transmitted over the Internet. You can download a self-signed certificate file on the GaussDB(DWS) management console.
Therefore, no error is reported when a field is missing or the format is incorrect. auth_server Specifies a server, which is used for user identity authentication when KMS is used to encrypt data in the Hudi foreign table.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 DROP FOREIGN TABLE IF EXISTS product_info_ext; CREATE FOREIGN TABLE product_info_ext
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 DROP FOREIGN TABLE IF EXISTS OBS_ft; NOTICE: foreign table "obs_ft" does not exist, skipping DROP FOREIGN TABLE CREATE
For security, encrypt your AK/SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 CREATE FOREIGN TABLE ORDERS01 ( LIKE orders ) SERVER gsmpp_server OPTIONS ( ENCODING 'utf8', LOCATION 'obs://<obs_bucket_name>/tpch
The value cannot contain the following characters: *<>\,|/ value01 Encrypt DataStore If this function is enabled, Key Management Service (KMS) encrypts the cluster and the cluster's snapshot data.
CREATE SERVER obs_server FOREIGN DATA WRAPPER DFS_FDW OPTIONS ( address 'obs.example.xxx:xxx', encrypt 'true', access_key 'xxxxxxxxx', secret_access_key 'xxxxxxxxxxxxxx', type 'obs' ); -- Invoke this function to generate a foreign table for audit logs.
For security, encrypt your AK/SK and store them in the configuration file or environment variables. If the message "ERROR: schema "xxx" does not exist Position" is displayed when you create a foreign table, the schema does not exist.
For security, encrypt your AK/SK and store them in the configuration file or environment variables. If the message "ERROR: schema "xxx" does not exist Position" is displayed when you create a foreign table, the schema does not exist.
Refer to Table 1 to turn on/off backup, define time interval to save the data, and encrypt the saved data. Unsaved changes of each SQL Terminal/PL/SQL Viewer are taken as backup and stored in DataStudio\UserData\<user name>\Autosave folder.
