Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Getting started with Snowflake

    Stambia Data Integration allows to work with Snowflake Databases, offering the possibility to produce fully customized Integration Processes.

    In this article, you'll learn to reverse your first Metadata, optionally configure it to use external storages such as Microsoft Azure Storage or Amazon S3 and to produce Mappings or Processes.

    The idea in our examples will be to load data from the demo HSQL Database, and from delimited files, to a Snowflake Database.

    Refer to the presentation article for the download section and the list of supported features.

    Read more: Getting started with Snowflake

    Stambia DI for Snowflake

      Stambia Data Integration allows to work with Snowflake, offering the possibility to produce fully customized Integration Processes.

      The database structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.

      The connector supports loading data through Snowflake's internal stages or external storages such as Microsoft Azure Storage and Amazon S3.

       

      Note:

      Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.

      If you have any question, any feature request or any issue, do not hesitate to contact us.

      This component may require a dedicated license.

      Please contact the Stambia support team if you have any doubt and if you need to use it in a production environment.

       

      Download

      You can find below the necessary resources to work with this Component in Stambia DI

      Name Description Download
      Component resources You can find in download section the Component resources. Component resources download

       

      To learn how to install and use Snowflake in Stambia DI, have a look at the following getting started article.

       

      Supported features

      You can find below an overview of what Stambia DI can do with Snowflake.

      Standard features

      Name Description
      Reverse

      The database structure can be reversed in a dedicated Metadata

      DDL /DML Operations

       

      DML/DDL operations can be performed on the database, such as: Insert, Update, Select, Delete, Create or Drop

      Integration methods
      • Append
      • Incremental Update
      Staging

      The databases can be used as a staging area to make data transformation, mutualization, ...

      The following modes are supported:

      • staging as subquery
      • staging as view
      • staging as table
      Reject

      Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations.

      • Three type of rules can be created: Fatal, Warning, Reject
      • Depending on the specified type, the rejected data will not be handle the same way
      • Rejects of previous executions can also be recycled
      Replication

      Replication of databases is supported.

      The replication source can be any rdbms, Flat files or XML files.

       

      Advanced features

      Name Description
      Slowly Changing Dimension Integrations Integrations can be performed using Slowly Changing Dimension (SCD)
      Load methods
      • Generic load
      • Snowflake COPY loader
      Supported Storages

      Storages supported to store temporary files for performances optimizations:

      • Snowflake internal stage
      • Microsoft Azure Storage
      • Amazon S3

       

       

      Subcategories

      Articles

      Suggest a new Article!