The option simply does not exist in the UI to provide these privileges to Open SQL schema users. However, remote tables, at time of writing, cannot directly be exposed to the Open SQL schema or to an HDI container. Another requirement was that HDI containers would be able to read these remote tables. Apart from modelling these tables within SAP Datasphere, the objective was to make them accessible to external tools as well, using a database user that connects to the Open SQL schema. Recently, I handled a case where a customer used SAP Datasphere to create a considerable amount of remote tables. Let’s set the stage with some background. ![]() Most of the text in this blog consists of the actual Python code that accomplishes this task. Welcome to this technical blog post where we’ll delve into generating SAP Datasphere SQL views from SAP Datasphere remote tables, and subsequently deploying them into SAP Datasphere using the SAP Datasphere Command-Line Client (CLI).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |