13 posts tagged with "redshift"

restoring redshift spectrum to hot table storage

Creating Redshift Spectrum tables is a great way to…

redshift COPY commands can have identity columns

06/07/2023 10:40 | Category: databases

Tags: redshiftetldba

Recently I learned that COPY commandsd can have a…

redshift useful query metrics and logging internal tables

06/07/2023 10:02 | Category: databases

Tags: redshifttuningqueriesdba

Redshift has quite a few internal tables…

aws redshift conditionally pausing clusters using Terraform with redshift one time scheduled actions

12/27/2022 14:20 | Category: databases

Tags: terraformiacawsredshift

aws redshift conditionally pausing clusters using Terraform with redshift one time scheduled actions…

aws redshift dynamic sort keys

11/23/2022 15:09 | Category: databases

Tags: redshiftmaintenance

Previously when working on Redshift clusters tables needed to be…

aws redshift lock query types

11/23/2022 15:04 | Category: databases

Tags: redshiftlock_waits

Detecting and releasing locks in Redshift is an important thing to…

aws redshift unloading aws console queries

06/28/2022 10:14 | Category: databases

Tags: awsredshifts3unload

When running queries in the AWS Redshift console often…

retrieve table size stats and other info from redshift

04/12/2022 12:35 | Category: redshift

Tags: redshiftawsdbadatabases

Often times when looking at table performance…

inspect users in a user group in redshift or postgres

04/12/2022 12:30 | Category: redshift

Tags: dbadatabasesredshiftawsuserspostgres

To inspect information about our database/the…

listing stored procedures from redshift

04/12/2022 12:27 | Category: redshift

Tags: dbadatabasesredshiftawsstored_procedure

Finding if a stored procedure is in the proper schema is…

adding iam access roles to redshift

03/14/2022 11:56 | Category: redshift

Tags: awsredshiftiamaws_cliterraformdba

RedShift requires IAM roles to be associated with it for…

All tags