Snowflake integration was taken very seriously in Lyftrondata, in order to overcome the limitations of traditional ETL/ELT tools that stage flat files on a local disk before pushing it to Snowflake. Such solution requires extra disk space for data loading and adds additional delays to the data pipeline.
Lyftrondata takes a unique approach to data loading into the Snowflake Data Warehouse by utilizing the new data streaming API available in Snowflake. Data is loaded from the data source, data transformations are applied on the fly as SQL expressions and the transformed data is streamed directly to Snowflake. The data is loaded without any delays and without the need to manage any space for temporary files. Additionally, Lyftrondata may push down selected SQL transformation directly to data sources to reduce the amount of data that must be transferred.
Snowflake customers can dramatically simplify and shorten their time to insight by utilizing Lyftrondata’s native Snowflake migration and modernization solutions . Just log into Lyftrondata, select any data to transfer to Snowflake and just schedule the pipeline. Setup should only take a few minutes and you can use Lyftrondata no obligation 1 month free trial.
What is Operational Data Store
Read the blog to learn about the A-Z of Operational Data Store (ODS) for operational reporting and transaction