Preparations Before Using Hudi

Prerequisites

You have created an OBS agency and OBS data source. For details, see Managing OBS Data Sources.

Authorizing the Use of OBS Data Sources

Run the GRANT command to grant a user the permission to use OBS data sources.

1

GRANT USAGE ON FOREIGN SERVER server_name TO role_name;

Example:

Run the following command to grant user sbi_fnd the permission to access data source obs_hudi:

1

GRANT USAGE ON FOREIGN SERVER obs_hudi TO sbi_fnd;

Granting Permissions for Using Foreign Tables

Run the following command to grant a user the permission to use foreign tables:

1

ALTER USER role_name USEFT;

Example:

Run the following command to grant the foreign table access permission to user sbi_fnd:

1

ALTER USER sbi_fnd USEFT;