Build data pipelines
Y42's asset-based orchestrator provides a unified architecture to ingest, transform, test and automate your data flows, so you can tackle new business requirements without the maintenance overhead.
Ingest data
Whether its Airbyte connectors, Fivetran syncs or Python scripts, Y42's ingestion asset lets you move data into your warehouse without the hassle of managing infrastructure. All you need to do is declare a source to get started.
Connect to 350+ data sources using plug-and-play connectors or create your own connector.
Explore documentationTrigger syncs with 300+ data sources, monitor status updates and use the data anywhere in your Y42 project.
Explore documentationWrite your own Python scripts to extract and load data — no infrastructure setup or boilerplate code required.
Explore documentationSafeguard credentials with secure encryption. Edit, delete or reuse credentials for source connections, all from one central location.
Explore documentationTransform data
Say goodbye to code sprawl. Y42's analytics workflow lets you quickly preview metadata, queries and tables/views without leaving the code editor — so you can refactor or extend existing models on the fly.
Y42 natively integrates dbt core, so you can write modular SQL transformations supplemented with macros, packages, tests, snapshots and embedded documentation.
Explore documentationMouse-over any asset to preview its schema, query and latest build, so you always have contextual information right at your fingertips.
Explore documentationGet a real-time preview of your query results or compiled query to refine transformation logic as you go.
Explore documentationTrack model dependencies with unparalleled granularity, making it effortless to organize references between sources, models, Python scripts and more.
Explore documentationorchestration
Y42's context-aware orchestrator lets you call upon Airbyte, Fivetran, dbt models and Python scripts from anywhere in your project, so you can rapidly iterate on your data pipelines without skipping a beat.
Explore documentationAutomate workflows (BETA)
Bridge the gap between your data pipelines and third-party applications. Y42 lets you write and execute Python scripts directly in your data pipelines — so won't have undocumented glue code running in the shadows.
Call external APIs using Y42's Python actions. Sync your data pipelines with workflows in Asana, JIRA, Make or any tool you prefer.
Explore documentationSkip the boilerplate code. Write Python scripts, then trigger a build — we'll execute them with serverless functions for you.
Explore documentation