July 2022 Summaries

With Census, companies can connect their data sources and tools, such as Jira, Apollo, and Zoho, to gain a unified view of customer and sales data in HubSpot, Salesforce, and other platforms. By leveraging Reverse ETL use cases, organizations can supercharge their data-driven decision-making processes. Companies like Prolific, Leaflink, Weights & Biases, and Hugo have seen significant improvements in sales performance, product analytics, and marketing efforts through the integration of Census with their existing tools and platforms.

We are excited to announce that Census has been selected as part of the Automation Apps Collection in HubSpot's App Marketplace, joining companies like Airtable and NetSuite, and will deepen our relationship with HubSpot. This addition enables users to combine all their data for a single view of customers, build granular segments without SQL or custom integrations, and trigger personalized campaigns based on calculated metrics. Census has already helped hundreds of HubSpot users wield their customer data to reach new heights, and we are eager to provide more companies with the ability to democratize their data. With this update, users can start connecting their warehouse to HubSpot in 5 minutes, doing more with their customer data, and joining us at Hubspot's Inbound Conference in October for even more announcements.

The Census Summer Community Days event is a two-day practitioner-first community event that focuses on giving data professionals the mic to learn from each other and share their expertise without sales pitches or product demos. The conference features virtual keynotes, expert sessions, and workshops, as well as live happy hours in major US city hubs. Keynote speakers include Emily Hawkins, Julia King, and others who will discuss topics such as career navigation, diversity in data, and building account scoring models. Expert sessions cover a range of topics from technical deep dives to learning to expand the reach of data in companies. Workshops are also available to help attendees build new data skills they can implement after the conference. The event is designed to provide a space for data professionals to network in person at happy hours in major US city hubs.

Snowflake is a popular data warehouse solution that offers a range of features, including SQL language support, versatility, and cloud-agnostic benefits. However, it lacks some features available in Google Sheets, such as variety of tasks for less technical users, templates, and shareability. To transfer data from Snowflake to Google Sheets, there are three methods: using Census as the bridge, running a Python script, or manually exporting and importing CSV files. The first method is quick and easy, while the second method requires more steps and potential missteps. The third method involves manual export and import, which can be time-consuming but provides flexibility. Ultimately, the choice of method depends on the user's needs and frequency of data transfer.

There are multiple ways to sync data from Snowflake to Slack, each with its own advantages and disadvantages. The Census method is the most straightforward, using Census to automate the process of syncing data between Snowflake and Slack. This method is ideal for frequent syncing needs and automates the job without requiring extensive setup. In contrast, manually syncing data by exporting it from Snowflake and importing it into Slack can be tedious but suitable for occasional syncing requirements. The API method provides more flexibility but requires accessing APIs, creating an app, and implementing additional functionality such as scheduling and error handling. Overall, Census offers a seamless automation experience regardless of the environment, making it a viable option for production environments as well.