SFI Snowflake Data Warehouse

Sustainable Finance and Investment (SFI) data is available via Snowflake. Alongside additional feeds such as LSEG Data Platfom (LDP) and workspace. Using the unique identifier QA ID clients can combine ESG, FTSE Russell Green Revenues, Climate and EU Taxonomy with 3^rd party datasets from Quantitative Analytics.

The availability of sustainability datasets in Snowflake allows you to leverage the power of the Snowflake environment to efficiently manage and analyse large datasets, and in addition combine them with LSEG datasets such as Historical Analytics and Pricing & Reference Data on a single platform. By integrating data sourced from LDP Bulk up-to-date repository. This setup facilitates seamless data retrieval, manipulation, and export, enabling users to execute complex SQL queries, create dashboards, and perform in-depth analysis with ease.

The platform supports various data access methods, including direct SQL queries, Python integration, and local development environments using Snowflake connectors and Snowpark. With robust access control mechanisms, we ensure that users can only access authorized data, maintaining data security and integrity. Additionally, the performance testing and user acceptance testing (UAT) processes validate the system’s efficiency and reliability, ensuring that you can effectively utilize the data for their specific needs.

Furthermore, SFI’s architecture is designed to handle high volumes of data with optimal performance. Users can perform complex joins, aggregations, and filtering conditions to retrieve specific subsets of data quickly. The ability to create and customize dashboards allows for real-time data visualization, making it easier to derive actionable insights. The platform also supports exporting query results to various file formats, facilitating data integration with other systems and tools.

Overall, LSEGs distribution of data via Snowflake provides a robust, scalable, and secure environment for data management and analytics, empowering you to make data-driven decisions with confidence.

I would like to subscribe to SFI Warehouse content.

By submitting this form, you agree to your personal data being shared within the London Stock Exchange Group of companies (LSEG) for the purpose of receiving communications via post, phone and electronic means from LSEG about event, resources, products, and/or services.

For more information on how LSEG uses your data, see our Privacy Statement. You can adjust your preferences at any time through the preference link in any electronic communication that you receive from us.