Spanish English German Portuguese
Spanish English German Portuguese

Snowflake Source Connector

Snowflake Source Connector

att_0_for_1846936454.png

Connector to integrate datasets, tables, and analytical data from Snowflake into GlobalSuite.

Tags: Data Warehouse | Cloud | Source

Tool or system

Snowflake

Tool manufacturer

Snowflake

Connector provider

Confluent Cloud

Connector name

Snowflake Source Connector

Connector type

Source

Tags

Data Warehouse | Cloud | Source

Information it handles

datasets, tables, and analytical data

Details

The Snowflake Source Connector allows integrating information from Snowflake into GlobalSuite related to datasets, tables, and analytical data.

It is designed to keep management processes, evidence, and indicators updated without relying on manual uploads, especially in scenarios of executive reporting, risk dashboards, data consolidation, and historical analytics.

Features

  • Configurable integration of datasets, tables, and analytical data from Snowflake into GlobalSuite processes.

  • Preparation of datasets for reporting, dashboards, historical analysis, or business intelligence.

  • Mapping of tables, schemas, fields, or partitions according to the agreed analytical model.

  • Support for incremental or periodic loads to keep exploitation data up to date.

  • Separation between operational information and analytical layer to facilitate governance and performance.

Key benefits

  • Allows exploiting data from GlobalSuite and related systems in BI and analytics tools.

  • Accelerates the creation of executive dashboards on risks, compliance, auditing, or operations.

  • Reduces dependency on manual extractions for recurring reporting.

  • Facilitates historical analysis, comparisons, and trend tracking.

  • Helps separate daily operational management from the analytical layer used by management and reporting.

Installation

Configuration note: Before activating the integration, validate credentials, permissions, functional scope, and a data test with the responsible area.

  1. Access the GlobalSuite® Marketplace and select Snowflake Source Connector.

  2. Configure the connection with Snowflake: URL or endpoint, credentials, permissions, and environment.

  3. Define the functional scope of synchronization: datasets, tables, and analytical data, filters, and frequency.

  4. Map the received fields with the corresponding entities, evidence, or processes in GlobalSuite.

  5. Run a test, review the synchronized records, and activate the integration.

More information

https://docs.confluent.io/cloud/current/connectors/cc-snowflake-source/cc-snowflake-source.html

Use this connector when you need to integrate information from Snowflake into GlobalSuite processes, for example, for executive reporting, risk dashboards, data consolidation, and historical analytics. Before publishing it, agree with the owning area on what data is needed, how often it should be updated, and who will review the results.