Dear Experts,
I would appreciate your guidance on the following questions related to SAP Datasphere and SAP HANA Cloud:
When we create a table in SAP Datasphere:
What operations are performed on the underlying SAP HANA Cloud database?
Is a physical table immediately created in HANA Cloud?
Are there any additional metadata artifacts generated at this stage?
When we create a view in SAP Datasphere:
How is this view represented on the HANA Cloud database side (e.g., SQL view, calculation view)?
Is any temporary or runtime structure created immediately?
When we persist data:
Into a table:
What activities occur in HANA Cloud during data persistence into an existing Datasphere table?
Into a view (after enabling persistence):
How is the persisted data stored in the underlying database?
Is a new table automatically created? If yes, what is its structure relative to the original view definition?
Regarding Partitioning and Data Loading:
When partitions are created on a Datasphere table or persisted view:
When we load data into these partitions:
When we delete specific partitions or delete all partitions:
General Runtime Activities:
During all these operations (table/view creation, persistence, partitioning, deletion), what are the typical HANA Cloud runtime actions (e.g., commits, locks, internal optimizations, delta merges)?
Any insights, technical explanations, or references to SAP Datasphere documentation would be greatly appreciated.
Thanks in advance for your support!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.