3 Steps for Fixing Slow Looker Dashboards with Amazon Redshift December 06, 2021 by Mark Smallcombe 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...
SQL commands Best Practices – Amazon Redshift December 06, 2021 by Mark Smallcombe Amazon Redshift is a fully managed, cost-effective petabyte-scale cloud-based data warehouse service – allowing businesses to store and analyze large scale data sets and perform massive database migrations. Redshift was...
Come See Us At Amazon AWS re:Invent December 04, 2021 by Donal Tobin Are you going to Amazon AWS re:Invent? One of the hottest cutting-edge user conferences held each year.
Generate Temporary Amazon Redshift With AWS IAM December 04, 2021 by Mark Smallcombe At intermix.io, we run a fleet of over ten Amazon Redshift clusters. In this post, I’ll describe how we use AWS IAM authentication for our database users. AWS access is...
Redshift Data Types | Guide to AWS Redshift Data Types December 04, 2021 by Abe Dearmer Many of our customers have a variety of data sets with different data types coming from different sources. Here at Integrate.io, we replicate your data from Amazon RDS to Amazon...
Redshift Create Table | How to Create a Redshift Table December 03, 2021 by Donal Tobin First up, we break down how to use the Redshift Create Table command as quickly and succinctly as possible, leaving out all the extra stuff you probably don’t need to...
Redshift Table Size: How to find the size of a table in Redshift December 03, 2021 by Abe Dearmer SVV_TABLE_INFO is a Redshift systems table that shows information about user-defined tables (not other system tables) in a Redshift database. The table is only visible to superusers.
Redshift Show Tables | How to List Redshift Tables December 03, 2021 by Donal Tobin In order to list or show all of the tables in a Redshift database, you'll need to query the PG_TABLE_DEF systems table. An interesting thing to note is the PG_...
Redshift Unload: Amazon Redshift’s Unload Command December 03, 2021 by Abe Dearmer Redshift’s UNLOAD command is a great little tool that complements Redshift’s COPY command, by doing the exact reverse function. While COPY grabs data from an Amazon s3 bucket and puts...