BIG DATA

Earlier this year we launched an update showing query recommendations on how to improve SQL queries to enhance performance. In most cases, improving query performance requires re-writing the SQL and...

Here at Integrate.io, we’re constantly building products and innovating for Amazon Redshift users, and we’d like to think we have our finger on the pulse of what Redshift customers are...

Table of Contents The Problem: Slow Looker Dashboards Amazon Redshift Workload Management and Query Queues Slow Looker Dashboards: Understanding LookML and Persistent Derived Tables Slow Looker Dashboards: The Impact of...

Table of Contents What is Serial Isolation? Database “Snapshots” Serializable Isolation Violation Example Fixing Serialization Violation Errors Getting the Most Out of Amazon Redshift As an Amazon Redshift administrator, you...

Amazon Redshift offers an attractive feature that can help organizations manage their hosting bill. It’s called concurrency scaling, and according to Amazon , it “automatically and elastically scales query processing...

Table of Contents Setting up Redshift Clusters: Don't Use the Masteruser Setting Up Redshift Clusters: Don't use a Single Schema Setting up Redshift Clusters: Don’t use the default WLM queue...

At Integrate.io, our greatest asset is our customers. We love our customers and they love us, so we are launching a new blog series called, Customer Spotlight where each month...

Amazon Redshift is a data warehouse that makes it fast, simple and cost-effective to analyze petabytes of data across your data warehouse and data lake. Amazon Redshift can deliver 10x...

Summary Arvind Ramesh is the manager of the data team at Envoy. In this post, we’re sharing how Arvind’s team has built a data platform at Envoy, with a deep...