Top Data Consultants to Look Out For in 2022 December 15, 2021 by Mark Smallcombe With data and analytics being a core function of businesses today, it's essential to have the right data consultants on your team. See this overview to learn more.
What is Heroku December 14, 2021 by Donal Tobin Looking to build a data warehouse? This guide shows you what is Heroku, its key features, and how your company can benefit from it.
Top 5 Reasons to Centralize Data & Become a Data-Driven Business December 14, 2021 by Mark Smallcombe Digital Transformation has ushered in a new era in business, where companies need to centralize data, and become data driven to remain competitive.
Maintain Accurate Table Statistics December 07, 2021 by Donal Tobin Amazon Redshift builds a custom query execution plan for every query. For a given query plan, an amount of memory is allocated. The memory allocation is determined by estimating the...
Avoid Row Skew December 07, 2021 by Abe Dearmer Row Skew results when a table uses KEY based distribution and the values in the DISTKEY column are not evenly distributed. The row skew metrics is a positive integer ranging...
How Teads Built Their Data Pipeline with Amazon Redshift December 07, 2021 by Donal Tobin Teads Teads is a video advertising marketplace, often ranked as the number 1 video platform in the world. Working with data-heavy videos must be supported by a powerful data infrastructure,...
Compress Data in S3 December 07, 2021 by Donal Tobin The Amazon Redshift COPY command is the recommended way of moving data into Amazon Redshift. The COPY command takes advantage of the parallel architecture in Amazon Redshift to move data....
The Data Sources & Uses within United Airlines December 07, 2021 by Abe Dearmer The 5 Type of Data Sources that Every Enterprise Should Think About In broad terms, we see five major categories of data sources: Production data : Data coming from core...
Create Custom Workload Manager (WLM) Queues December 07, 2021 by Donal Tobin The Amazon Redshift Workload Manager (WLM) is critical to managing query performance. Amazon Redshift run queries in a queueing model. The default WLM configuration has a single queue with five...