At Silectis, we deploy Magpie clusters across AWS, Google Cloud, and Azure. But because some of our internal infrastructure resides only on AWS, we need to establish private connections between these environments so that clusters on Google Cloud and Azure can access those private AWS resources. In this post, we’ll walk through the details of how we … [Read more...] about Tutorial: Creating a Multi-Cloud VPN with Terraform between AWS, GCP, and Azure
Data Engineering
Improve Your SQL Skills: Master the Gaps and Islands Problem
The "gaps and islands" problem is a scenario in which you need to identify groups of continuous data (“islands”) and groups where the data is missing (“gaps”) across a particular sequence. The problem may sound arcane at first glance but knowing how to solve this type of problem is critical for advanced SQL practitioners. These starting and … [Read more...] about Improve Your SQL Skills: Master the Gaps and Islands Problem
Magpie Supports Google Cloud Platform
MAGPIE IS THE EASIEST WAY TO SETUP YOUR DATA LAKE ON GOOGLE CLOUD PLATFORM Today, Silectis is excited to announce our data engineering platform, Magpie, supports Google Cloud. Silectis Magpie brings together Google Cloud’s Big Data components so that organizations can get value from their data engineering operations right away, providing a … [Read more...] about Magpie Supports Google Cloud Platform
How to Implement a Data Lake with Apache Airflow and Silectis Magpie
Let’s face it, operating in a data-driven environment is hard. Teams, even small ones, can generate a painfully large number of batch processes that need to run on schedules. Drag-and-drop ETL tools become a maze of dependencies as business logic expands. Cron jobs lack transparency, failing silently and sucking away developer time. It’s in … [Read more...] about How to Implement a Data Lake with Apache Airflow and Silectis Magpie
Magpie and Looker Partner to Supercharge Your Data Analytics & Visualizations
Today’s advanced analytics space is filled with tools to help users become more data driven. However, every use case is different, and there is not a single tool that is ready for each unique situation. The best solutions for a given organization usually lie in a combinations of software platforms. This blog post outlines why Silectis Magpie and … [Read more...] about Magpie and Looker Partner to Supercharge Your Data Analytics & Visualizations
Magpie in Action: Analyzing the Future of Solar Power in Washington, DC
This blog post was written in conjunction with UrbanTurf, the authority on real estate in the Nation’s Capital, and can be found here. SOLAR POWER IS COMING TO DC… BUT NOT WHERE YOU WOULD THINK Silectis used public building permit data from DC’s open data portal to determine which neighborhoods in Washington DC really care about the future of … [Read more...] about Magpie in Action: Analyzing the Future of Solar Power in Washington, DC