Creating table in SAP DWC using CLI

[atharvapangerkar]

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?

[jascha_meiswinkel]

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!

[jascha_meiswinkel · Accepted solution]

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

[atharvapangerkar · Accepted solution]

Hi Jascha,

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

[former_member946027]

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:

1. Login to your DWC account using the command line interface (CLI).

2. 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);

1. The table is then created in DWC.

2. 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);

1. 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.

[tmeyer]

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?