IBM Netezza was an advanced on-prem appliance data warehouse. It has been described as being like a toaster — you wheel it in, plug it in, and it just works. It focused on highly performant SQL processing at scale. Netezza has been the SQL data warehouse engine for many enterprises…

Two households, both alike in dignity, combine to create the hybrid cloud CI/CD pipeline of your dreams We’re huge fans of automation at Hashmap. We believe that your code should be committed often and deployed automatically. For that reason, we take advantage of Azure DevOps Pipelines whenever we can. For…

One of the most basic tasks available in Snowflake is the ability to create and manage users. This is a core pillar of creating a secure and auditable instance that requires minimal maintenance work. User creation is also one of the areas that I see people struggle with early on. …

One of the trickiest parts of data engineering is working with timestamps, timezones, and Daylight Saving Time. Too often I’ve seen IoT projects, in particular, stumble on this core challenge. While UTC time can help keep things clean, it is not enough on its own. If you’re considering storing timestamp…

Hashmap has been focusing on delivering the simplest, most cost-efficient data solutions for the better part of a decade. Because of that focus on outcomes, we have lately found ourselves doing more and more work on the Snowflake Cloud Data Warehouse. It is tempting to think that Snowflake is simply…

Ingestion is the lifeblood of your Snowflake Cloud Data Warehouse. Make sure that you’re spending less and doing more with these practical tips for using external stages with Snowflake. During this talk I covered file considerations, continuous loading, egress (!), and workflow design. Also, this was the first video produced from Hashmap’s new office in OKC. Get the slides from this video here! This video was recorded during the 4th OKC Snowflake Meetup on September 13, 2019.

One of the best parts of using an Identity Provider (IdP) like Azure Active Directory is the ability to centralize your user management and access control. For applications that are Microsoft-native, this management is seamless. For non-Microsoft services, the management can be a pain. …

At Hashmap, we’re constantly looking for ways to provide our clients with a simpler and quicker path to business value and meaningful outcomes. To that end, we routinely recommend Snowflake because it just works! Organizations across industries rely on Snowflake for their cloud data warehousing needs — net new data…

Hashmap kicked off the OKC Snowflake User Group Meetup a couple of months ago in order to assist a rapidly growing group of OKC Snowflake users in coming up to speed quicker on Snowflake while accelerating an ability to deliver meaningful business outcomes. One of the questions that we get…