Best practices and lessons learned for modern cloud ETL to data warehouse.
8 min read • 14 Dec 2017
It’s critical for health and financial organizations to protect patient and client data. But with so much data coming in, how do you safeguard it at scale? We’ll show you how you can use the Alooma Code Engine to encrypt all your data in real-time in just two steps.
Daniel Ben Yosef
Optimize Data Throughput with the New Snowflake Snowpipe
5 min read • 28 Nov 2017
Snowpipe uses the COPY command to load the data via a lightweight REST API and can be called asynchronously. For Snowflake users, improves throughput and reliability.
ETL Testing: The Future is Here
15 min read • 21 Nov 2017
The traditional way of building an ETL process was very long with many steps. In this blog, we explain why and how we designed a modern ETL built for the cloud era to handle the explosion of different data sources and streaming in real-time.
The Best Decisions Come From Real-Time Data
7 min read • 13 Nov 2017
The next evolution of data-driven decisions is real-time data driven decisions. This is how winning businesses of today and the future will compete. For real-time data analysis and decisions to work at scale, they need to be cloud-based, use real-time stream processing and utilize business intelligence tools.
Periscope Data Warehouse Now Supported
5 min read • 7 Nov 2017
Alooma supports the new Periscope Data Warehouse as an output.
Three Ways to Ingest Data Without a Native Connector
5 min read • 30 Oct 2017
Three ways to ingest data through Alooma into a cloud data warehouse without a native integration
Best Practices for Migrating from On-Prem to Cloud
14 min read • 7 Sep 2017
The advantages of migrating to the cloud are very clear and the industry is showing it. According to the IDC Worldwide Quarterly Cloud IT Infrastructure Tracker, deployment in cloud environments will increase by 18.2% in 2017 to $44.2 billion.
How Redash is Helping Alooma Sustain a Data Driven Culture
8 min read • 19 Jul 2017
Alooma and Redash share the same mission: to liberate data and unleash its full potential.
Alooma’s Roundup of Snowflake’s Cloud Analytics City Tour
5 min read • 11 Jul 2017
Alooma data pipeline service company recaps the 2017 Snowflake Cloud Analytics City Tour
Harness the power of Salesforce data
12 min read • 5 Jul 2017
Extract, transform and load your Salesforce data to BigQuery, Redshift or Snowflake
The easiest way to load a CSV into Google BigQuery
10 min read • 25 Jun 2017
BigQuery, Google’s data warehouse as a service, is growing in popularity as an alternative to Amazon Redshift. If you’re considering working with BigQuery, you’ll find that accessing the data is quite straightforward.
Solving the challenges of mapping your data
8 min read • 21 Jun 2017
When mapping is done correctly, the pipeline process works smoothly with fewer loading errors. That’s why we at Alooma allow you to automate the mapping process, so you won’t have to deal with the dirty work of deciding which column should be mapped to which data type.
Redshift Vacuum and Analyze Tool: Doing your Maintenance Work for you
9 min read • 12 Jun 2017
Explaining why VACUUM and ANALYZE are required. We’re providing you with a free tool to manage your maintenance tasks.
Redshift: How to alter column in 3 clicks
9 min read • 3 Jun 2017
There’s no simple, native way to alter a column’s name or data type in Redshift, BigQuery, or Snowflake. So, we built one which enables you to alter a column in 3 clicks within the Alooma Platform. Read on to learn about how we, as a product team, got there.
Infographic: Why Streaming Data Pipelines Matter
5 min read • 24 Apr 2017
Streaming data pipelines today are enabling organizations to transform and become data-driven.
Recruiting a Top Notch ETL Developer
5 min read • 29 Mar 2017
In order to build a great data team, you need great data engineers. Here's how to hire them.
Six pitfalls when connecting Elasticsearch to Redshift
5 min read • 14 Mar 2017
Redshift and Elasticsearch have a very different structure, as they are two very different solutions for data storage. While Elasticsearch is a full-text search engine based around schema-free JSON documents, Redshift is an SQL-based, columnar, schema’d data warehouse based on PostgreSQL.
Real-Time Anomaly Detection on the Stream
4 min read • 1 Feb 2017
How to monitor and detect anomalies in KPIs in real time using Alooma’s Code Engine.
Enriching Streaming Data With External Sources
4 min read • 25 Jan 2017
How to use Alooma’s Code Engine to enrich streaming events with data from external sources
Sessionization Using Python and Alooma’s Code Engine
9 min read • 19 Jan 2017
An introduction to stateful processing, and how we at Alooma, are using stateful processing internally to get the most out of our events data.
ETL Tools: A Modern List
4 min read • 16 Jan 2017
Extract, Transform and Load (ETL) tools enable organizations to make their data accessible, meaningful, and usable across disparate data systems. When it comes to choosing the right ETL tool, there are many options to chose from.
Harnessing real-time data to improve customer experience
7 min read • 20 Dec 2016
An example of how we at Alooma use real-time data collected from multiple sources to gain insight into our customer's actions, and to improve customer hapiness.
Amazon Athena - Initial Analysis
3 min read • 30 Nov 2016
Everything you need to know about Amazon's latest announcement: Amazon Athena - an interactive query service for Amazon S3.
Alooma Live - Kafka Real-Time Visualization
12 Sep 2016
Introducing Alooma Live - our new tool for real-time, big-data stream visualization
Itamar Weiss & Stav Mizrahi
Forbes names Alooma the rising star of data infrastructure
2 min read • 7 Sep 2016
Alooma is proud to be named the rising star of data infrastructure in the Forbes 2016 World’s Best Cloud Companies list.
4 Valuable Resources on Stream processing
3 min read • 4 Jul 2016
Beginner guide to stream processing. Statefull, Stateless and in between.
Use webhooks to integrate data sources with Alooma
6 min read • 6 Jun 2016
Use webhooks to integrate any SaaS product to your data warehouse
Making big data analysis accessible throughout your company
5 min read • 23 May 2016
How to make everyone at your company data driven, regardless of their SQL knowledge.
Welcoming BigQuery, MySQL and MemSQL
1 min read • 19 May 2016
Today we announce new data warehouse integrations to BigQuery, MySQL and MemSQL
5 Valuable Resource on Custom Analytics
2 min read • 6 Apr 2016
A mini-list of 5 brilliant blog posts on Custom Analytics
MySQL to Amazon Redshift replication
20 min read • 19 Jan 2016
How to replicate your MySQL to Amazon Redshift: A comparison of 3 common approaches with detailed real-world examples.
Amazon Redshift for Custom Analytics - Full Guide
25 min read • 23 Nov 2015
Learn how to build a custom analytics pipeline over Amazon Redshift with real-world examples of engagement, funnels, retention and customer value analyses.
Export Application Insights to Amazon Redshift with Alooma
14 min read • 16 Nov 2015
Learn how to export Application Insights data to Amazon Redshift with Alooma
Building a Professional Grade Data Pipeline
5 min read • 24 Aug 2015
Flexible, reliable data pipelines are hard to build. We do this for a living, and wanted to share our knowledge and experience in understanding the difficulties.
Building Dockers with Maven for Continuous Integration
12 min read • 3 Aug 2015
How we at Alooma are building dockers using docker-maven-plugin and Jenkins.
Exactly-Once Processing with Trident - The Fake Truth
10 min read • 10 Jun 2015
Dissecting the Trident Guarantee of Exactly-Once Semantics
TLV Data Plumbers First Meetup
5 min read • 31 May 2015
Data Plumbing Blues - The first data plumbers meetup with 3 Real-Life Examples