New Features in Version 2021.23

Create Partitions on non-key Columns

For more information, see Partitioning Remote Table Data Loads.

Connection Type SAP HANA Cloud, Data Lake

With the new connection type you can connect a standalone SAP HANA Cloud, data lake to SAP Data Warehouse Cloud and use the connection for creating views, replicating data (snapshot), and creating data flows.

For more information, see SAP HANA Cloud, Data Lake Relational Engine Connections.

Use Cloud Connector to Connect to SAP HANA On-Premise for Remote Tables

To improve performance for federation and replication from SAP HANA on-premise, you can now use Cloud Connector to connect to an SAP HANA on-premise instance. The connection properties for the SAP HANA connection type provide a new property Data Provisioning Option for the Remote Tables feature where in addition to Data Provisioning Agent you can now select Cloud Connector. A new allowlist for trusted Cloud Connector IPs used for federation and replication from on-premise systems is available in the Configuration.

Receive Notifications About Data Provisioning Agent Status Changes

As an administrator who is monitoring the Data Provisioning Agent status you can now configure at the agent level to get notified when the agent’s status changes. This allows you to act immediately when an agent is disconnected.

For more information, see Receive Notifications About Data Provisioning Agent Status Changes.

Format and comment on SQL code

You can now format and comment on the code of your SQL view.

For more information, see Creating an SQL View.