Question Re: Creating table in SAP DWC using CLI in Technology Q&A

Creating table in SAP DWC using CLI

atharvapangerkar — Fri, 17 Feb 2023 07:02:24 GMT

I can create tables and views in the UI also I can read the space and table definitions using dwc-cli, but I am not able to create the table using the dwc-cli . I am getting this error "Required privileges are missing for the user to execute the request."

Is there any additional privilege required for DW modeler to create tables and views using dwc-cli?

Re: Creating table in SAP DWC using CLI

jascha_meiswinkel — Fri, 17 Feb 2023 08:48:47 GMT

Hi Atharva,

thanks for reaching out! I can see in the logs that the user executing the request is missing the Update privilege on spaces. Can you check whether the user has this privilege assigned?

Thank you!

Re: Creating table in SAP DWC using CLI

former_member946027 — Fri, 17 Feb 2023 10:13:38 GMT

Creating a table in SAP Data Warehouse Cloud (DWC) using Command Line Interface (CLI) is a straightforward process. The following steps should be followed to create a table in DWC:

Login to your DWC account using the command line interface (CLI).
Run the "create table" command followed by the table name, column name, data type, and column length. For example, to create a table named "Employee" with columns "Name" and "Age", the command would be:

CREATE TABLE Employee (Name VARCHAR(20), Age INT);

The table is then created in DWC.
Insert data into the table using the "INSERT" command. This command is used to add values to the columns. For example, to insert a record into the previously created table, the command would be:

INSERT INTO Employee VALUES ('John', 24);

To verify the data, use the "SELECT" command. This command is used to retrieve data from the table.

By following these steps, you can easily create a table in DWC using CLI.

Re: Creating table in SAP DWC using CLI

jascha_meiswinkel — Fri, 17 Feb 2023 10:56:51 GMT

Hi Atharva,

please make sure to not include the spaceDefinition property in case you only want to update the definitions. If you include the spaceDefinition property, the user is required to have update privilege on spaces. If you don't include it, DW Modeler privileges are sufficient.

Thanks,
Jascha

Re: Creating table in SAP DWC using CLI

atharvapangerkar — Fri, 17 Feb 2023 12:39:21 GMT

Hi Jascha,

Thanks for replying so quickly. Yes, it is working now after removing the space definition property.

Re: Creating table in SAP DWC using CLI

tmeyer — Tue, 21 Feb 2023 14:58:06 GMT

Hi Arusi,

I can logon but I don't find any command for the create table? I only see the spaces function. Can you explain it in more detail?