Lyft, shift and load any data into Snowflake instantly

Lyftrondata Pipeline manages connections to data sources and loads data to Snowflake. All transformations are defined in standard SQL and pushed down to data sources and Snowflake. Lyftrondata eliminates traditional ETL/ELT bottlenecks with automatic data pipeline and make data instantly accessible to BI users with the modern cloud compute of Spark & Snowflake.

Lyftrondata connectors automatically convert any source into normalized, ready-to-query relational format and provide search capability on your enterprise data catalog. Lyftrondata shortens data preparation activities by letting data teams create logical data sets first, evaluate the data and delay the data loading until the data sets are verified or data loading is required.

Automatically Manage Tables

Lyftrondata creates target tables in Snowflake and picks the right data types.

Transform with SQL

Transform or filter the data using SQL that is pushed down to Snowflake. Enable a true extract-load-transform to avoid extra data copies.

Prototype Data Sets

Avoid needless delay in data preparation. Define virtual data sets on source data. Verify and load to Snowflake when required.

Columnar Data Pipeline

Lyftrondata extends the columnar processing to the data pipeline, which speeds up data loading and transformation.

SQL Interface

Fully simulated transact-SQL interface (wire compatible with SQL Server) enables bridged queries to any data source or target Data Warehouse. No drivers or new skills are needed to run queries on any data.

Global Data Catalog

Categorize all data sets stored in the cloud, essential data sources and valuable data sets defined by data analysts and data scientists.

Experience the power of the cloud with our modern data ecosystem

Supported data sources

Related Snowflake Solution Briefs

Expand Analytical Capabilities

Migrate step-by-step

Migrate a legacy Data Warehouse either as a single Lift-Shift-Modernize operation or as a staged approach. Run dashboards both from the old Data Warehouse and the Cloud DW, switch the target when migration is finished.

Load data to the cloud

Connect 130+ on-premise and cloud data sources and set up continuous data synchronization of selected data to Amazon Redshift, Snowflake, Azure SQL DW or any other database.

Support any BI tool

Connect any BI tool using build-in SQL Server drivers through a fully simulated SQL Server protocol. Bridge a connection from SaaS BI tools to on-premise data and the on-premise Enterprise Data Warehouse.

Secure data in the cloud

Apply row-access security for data stored in the Cloud, apply dynamic data masking or use pseudonymization of PII data stored in the Cloud.

Empower data teams

Let data analysts and data scientists find and manage their data sets. Foster collaboration by creating a global Data Catalog of all valuable data sources.

One data portal

Lyftrondata is a single place to find and query all possible data. Use standard SQL to query legacy Data Warehouses, data sources in real-time and all Cloud Data Warehouses.