Unlock the Power of Behavioral Data with Ease

In the ever-evolving world of data analytics, agility and ease of access to data are not just conveniences; they are necessities. At Lassoo.io, we understand this imperative. That’s why we’re excited to guide you through integrating Lassoo’s headless analytics — powered by a robust PostgreSQL database — with Snowflake using Fivetran. This integration exemplifies simplicity, efficiency, and power, aligning perfectly with our ethos of making data easily operational.

Wait, what is headless analytics?

Headless Analytics is an architectural approach that decouples data collection from reporting. It focuses on the efficient ingestion, curation, reconciliation, and enrichment of data. Data teams can then use their preferred tools for reporting, BI and activation, directly on the collected data, or after loading/streaming it to their data warehouse.

Why Lassoo and Fivetran?

Lassoo.io offers a groundbreaking approach to behavioral analytics. Our headless analytics solution auto-tracks all customer behavior, providing granular first-party data directly via SQL. This data is not just comprehensive; it’s ready for immediate use, thanks to built-in features, classification, and rollups. This means that Lassoo can power a wide variety of advanced use cases, allowing organizations like yours to drive significant business value with behavioral data.

Fivetran, on the other hand, excels in automated data integration. It simplifies the process of data consolidation, ensuring that your Lassoo data seamlessly flows into Snowflake, a leading data warehouse solution. This integration means you can start gleaning insights from your data almost immediately.

Step-by-Step Guide to Integration

Step 1: Setting Up Your Lassoo Account

First, ensure your Lassoo account is active and you have access to the PostgreSQL database where your data is stored. Lassoo’s intuitive dashboard allows you to manage and monitor your data effortlessly.

Step 2: Configuring Fivetran

Next, log into your Fivetran account. If you don’t have one, signing up is straightforward. Once logged in, you’ll add a new connector for PostgreSQL:

1. Select ‘PostgreSQL’ as the Source Type: Since Lassoo uses PostgreSQL to store data, this will be your source.

2. Enter Your Lassoo PostgreSQL Credentials: Input the necessary details such as host, port, database name, user, and password. These credentials are securely handled by Fivetran, ensuring data safety and compliance.

You will also need to white lists the FiveTran IP addresses in Lassoo. Thankfully FiveTran provides the IPs in a copy-to-clipboard list making it error proof.

The CDC support in FiveTran for posgres is great. They support logical replication via pgoutput which means that they simply read from the Postgres transaction log (WAL) and apply the same changes to the data at the destination (in our case Snowflake). This is most efficient method which means it saves you $ in the long run as you’re not paying for bandwidth and processing for simply re-syncing data you already have.

One thing I did find strange is that Fivetran complained about my wal_buffers which end users will be powerless to change.

1. Choose the Data to Sync: Select the entire schema or specific tables you wish to integrate into Snowflake.

Step 3: Connecting to Snowflake

After setting up the PostgreSQL source, you’ll need to configure Snowflake as your destination:

1. Select Snowflake as the Destination: In Fivetran, choose Snowflake from the list of available destinations.

2. Provide Snowflake Credentials: Input your Snowflake account details, including account name, username, password, and warehouse details.

In Snowflake I needed to create a network policy (under Admin/Security) and input the FiveTran IPs to whitelist them.

1. Map Your Data: Define how your Lassoo data should be organized within Snowflake. Fivetran offers flexibility in data mapping to suit your analytical needs.

Step 4: Initiating the Data Sync

With both source and destination configured, initiate the sync. Fivetran will begin transferring your Lassoo data to Snowflake. This process is automated and can be scheduled at your convenience.

The Benefits Unleashed

With Lassoo’s data now flowing into Snowflake via Fivetran, you’re set to explore new dimensions of customer behavior analytics. This integration allows you to:

• Access Real-Time Insights: Analyze customer behavior as it happens.
• Scale Effortlessly: As your data grows, this integration scales with you.
• Ensure Data Governance: Lassoo’s commitment to data quality and compliance is complemented by Fivetran’s secure data handling.
• Drive Data-Driven Decisions: Leverage the combined power of Lassoo and Snowflake to make informed business decisions.
• Power your Composable CDP: Leverage your data for marketing automation.

Conclusion

Integrating Lassoo with Snowflake through Fivetran is more than just a technical setup; it’s a strategic move towards a more data-driven, customer-centric business model. We at Lassoo.io are excited to see how our clients leverage this powerful combination to transform their analytics capabilities. Fivetran setup was smooth and painless and one of our favorite ETL tools we often recommend to clients.

Stay tuned for more insights and guides on integrating Lassoo with other leading tools in the data ecosystem.