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 material to work with Snowflake in Stambia DI
| Name |
Description |
Download |
| Snowflake Connector |
Stambia DI Snowflake connector.
|
download
previous releases
|
| Generic Templates |
Package containing the generic Templates. |
download
previous releases
|
| Snowflake Templates |
Package containing the Snowflake Templates.
Snowflake specificities are handled in dedicated templates that can be found in this package.
|
download
previous releases
|
| Demonstration Project |
A project that demonstrates Snowflake features through examples of Mappings and Processes. |
download
previous releases
|
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
|
