AVT100 SSIS Data Flow Components for Snowflake ID 37069903
Software Development :: Components & Libraries
Devart SSIS Data Flow Components for Snowflake allow you to integrate Snowflake data with cloud applications and databases via SQL Server Integration Services (SSIS). Devart SSIS Data Flow Components for Snowflake include highly optimized Source, Destination, and Lookup components along with Devart Snowflake Connection Manager. Devart Snowflake SourceDevart Snowflake Source component offers a convenient editor, which displays all the connection tables and their columns and allows you to quickly build a query to Snowflake via drag-n-drop. It also displays the list of available system and user variables of the package, allowing you to quickly add them to your select statements. If necessary, you can also quickly preview data, returned by the source, and check whether you query returns what you need. Devart Snowflake Lookup Devart Snowflake Lookup component offers very high performance because of the advanced optimization techniques used. It uses select statements that check several rows at once, and caches the returned results to reduce the number of round-trips to the server. Devart Snowflake Destination To speed up loading data to Snowflake, Devart Snowflake Destination splits data to multiple CSV files, uploads them to Azure Blob Storage or Amazon S3 and then uses Snowflake COPY command to import them. It performs these jobs in parallel to provide the highest performance possible.
