Since 2018, Census Reverse ETL has enabled data and operations teams to use SQL to easily sync data from Snowflake to downstream business tools. Today, we're excited to extend the power of Data Activation further and announce compatibility with Snowflake's Snowpark API for Python!
With Census + Snowpark, data scientists can deliver the outputs of their Python models directly to business teams for usage in 200+ SaaS applications. For example, data teams can use Python to run predictive models to quickly identify top sales leads in Salesforce, or at-risk customers in Zendesk.
![](https://www.getcensus.com/hubfs/Imported_Blog_Media/649a94d87c6a60b2c3abcebb_ir4gwe32hz.png)
"Using Snowpark and Census is a more streamlined way to leverage Python in our data stack instead of just SQL. The ability to run machine learning workloads directly in Snowflake and operationalize them with Census in one place greatly simplifies our ML pipeline."
— Marc Stone, Head of Analytics and Data at ClickUp
Go Beyond SQL and Operationalize Data Science Models for Business Decisions
While SQL is the long-standing database language for querying and transforming data, Python has emerged as the preferred programming language for data science and ML. Python's rich ecosystem of extensive libraries and modules (NumPy, pandas, etc.) allows teams to perform more complex data operations to align with nuanced business requirements.
With Census and Snowpark, data scientists and developers no longer need to stitch multiple tools together to analyze data in multiple languages. They can work together on a single platform to move from raw data to insight, resulting in more agile data engineering and ML projects. With 92% of enterprise companies seeing ROI in their AI/ML investments, it's clear that making ML insights actionable is a top priority.
"Machine learning's true value lies in leveraging its outputs to make better business decisions. With Census and Snowpark for Python, modern data teams can easily operationalize their models through reverse ETL and data activation. They can generate insights, work natively with Snowflake, and extend their learnings across the entire organization, all within a single seamless workflow."
— Tarik Dwiek, Head of Technology Alliances at Snowflake
Embrace Efficiency with Census and Snowpark for Python
Snowpark (announced initially at Snowflake Summit 2021) is a developer experience that streamlines extensibility and native integration for languages beyond SQL. As mentioned earlier, SQL is the lingua franca for data warehousing, but can be limited for complex use cases. Snowpark is designed to make building complex data pipelines a breeze and to allow developers to interact with Snowflake directly without moving data.
As enterprises tackle nuanced data science needs, Census and Snowpark are gamechangers to easily make data science insights accessible to non-technical users. By activating Python models like intent models, churn propensity, and RFM scoring, businesses can get the most value from their data, improve customer understanding, and boost personalization and targeting.
Getting Started with Python Models in Census
Via a simple workflow, teams can write, store, and sync Python directly via Census's built-in Python repository for Snowflake connections.
Creating Python Models in Census is a straightforward process. From the Census dashboard, navigate to the "Models" page and select "+ New Model," then choose "Python" as your language. Now, you're ready to code your model.
Consider the following example:
![](https://www.getcensus.com/hubfs/Imported_Blog_Media/649a94d87c6a60b2c3abced6_x4c9ucu9su.png)
After creating the model, you can click "Run Query" to execute it, preview the data, and make any necessary modifications. When happy with the results, click "Save & Exit." Your saved models will be accessible from the "Models" section of Census, ready for you to choose and sync output data to your destination apps.
To read more about Python Models in Census, see our technical docs here for more information.
Activate the Snowflake Data Cloud with Census
Our deep partnership with Snowflake helps mutual customers realize maximum value from the first-party customer data they have collected and stored. Census transforms Snowflake into a Composable Customer Data Platform, enabling enterprises to drive business growth and revenue with their data analytics platforms.
Uniquely, Census provides data activation workflows in both code and no-code to bridge the gap between data and business teams.
- Data and IT teams can version control Census with a bi-directional Git integration to maintain security and governance.
- Marketers can use Audience Hub, a visual segment builder, to create customer audiences, power personalized omnichannel campaigns, and unify messaging across every marketing platform.
Try Census for free today, or get a personalized onboarding session from our team.