Skip to content
Contact us

Release 24.07 Data Management

Release 24.07 Data Management

new module

Cloud Data Warehouse – Snowflake Source Schema for importing external data

Cloud (Snowflake) Data Warehouse clients will now have the ability to create their own Snowflake Source Schema, within the same database as the SimCorp Data Warehouse. Tables on this schema can act as a Data Source to a table in the SimCorp Data Warehouse.

Prior to 24.07, clients could only import external (Non-SimCorp Dimension) Data via Files placed directly onto the Azure blob storage. The new Snowflake Source schema provides a new means by which clients can import external data, leveraging native Snowflake functionality. 

Benefits

  • Allows clients to leverage native Snowflake functionality for importing external data directly into the database for use as a data source to the SimCorp Data Warehouse.
  • Provides a means of staging data in Snowflake Source Schema enabling clients to manage and validate external data within the Snowflake environment before integrating it with the SimCorp Data Warehouse
  • Enables a greater level of governance around defining how external data is mapped to corresponding Data Warehouse table.

DWH - Schema Model

Snowflake Data Warehouse Database model with Source Schema Included

DWH - Fact Table Definition - Snowflake Source Schema

Tables can now specify Snowflake Source Schema as a data source

DWH - Load Plan Definition

Tables with Snowflake Schema as a source can be executed within a load plan. Data is loaded from the source schema table to the staging and target table in the SimCorp Data Warehouse

Please note: there may be implications to increased Snowflake consumption in terms of storage and credits. Also for the SimCorp SaaS clients where this is to be implemented there needs to be consideration for SaaS configuration to enable firewalls and whitelisting where specific connectivity to Snowflake is required thus please contact your CX to provide additional information and dependencies.

Subscription based licensing

Data Warehouse Manager

Sales module dependency

Snowflake extension to DWH

Browse the Release Portal

IBOR

Learn more

Front Office

Learn More

Portfolio Analytics & Reporting

Learn More

ABOR

Learn More

Alternative Investments

Learn More

Data Management

Learn More

ESG

Learn More

  • Privacy policy
  • Cookie Policy
  • Terms of Use
  • Trademark guidelines
  • Copyright © 2024 SimCorp A/S