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.

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’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...

In this article, I want to share some of the lessons learned in the hope that they are useful to you in your own engineering journey.

BigQuery and Redshift are world-class data warehouses, but they are very different. We’ll look at the most important criteria for choosing your data warehouse, including Cloud platform support, Scalability, Performance,...

Create better campaigns for events like Black Friday by integrating data and analyzing the effectiveness of your paid channels.

This blog is to help guide some early teams with tight engineering resources. If you have growing data, you need to view it in one place, analyze it effortlessly and...