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
Recently I learned that COPY commandsd can have a…
redshift serverless is poorly documented and difficult to cost analyze
06/07/2023 10:08 | Category: databases
Tags: redshiftdbaserverlesscost_analysis
Cost analysis for determining…
redshift useful query metrics and logging internal tables
Redshift has quite a few internal tables…
aws redshift conditionally pausing clusters using Terraform with redshift one time scheduled actions
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
When running queries in the AWS Redshift console often…
retrieve table size stats and other info from redshift
Often times when looking at table performance…
inspect users in a user group in redshift or postgres
To inspect information about our database/the…
listing stored procedures from redshift
Finding if a stored procedure is in the proper schema is…
adding iam access roles to redshift
RedShift requires IAM roles to be associated with it for…