10 posts tagged with "dba"
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…
postgres table constraint definitions from pg_constraint
The constraints feature of Postgres table…
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…
postgres helpful permissions queries
03/02/2022 10:44 | Category: postgres
Tags: dbapermissionsqueries
When creating new users, schemas, and tables inside a…