Redshift roles were a recent (2022) addition to Redshift. Prior to adding this feature Redshift groups where used for the same purpose. Redshift groups are not hierarchial in nature, a group cannot be granted to a group. But a role can be granted to a role making Redshift roles much more valuable (and inheritable) than …
Redshift Built-In Roles – and general usage of roles Read More »
There are several types of system tables and views here are there prefixes which categorize purpose: SVV_ prefixedviews contain information about database objects with references to transient STV tables. SYS_ prefixed views are used to monitor query and workload usage for provisioned clusters and serverless workgroups. STL_ prefixed views are generated from logs that have …
Reach out to AWS Support to increase this #. They will gladly. If you try to create a 21st your manual snapshot will fail unless this limit is increased https://n2ws.com/blog/aws-automation/3-reasons-to-automate-your-manual-redshift-snapshots#:~:text=Additionally%2C%20manual%20snapshots%20can%20be,to%2020%20snapshots%20per%20account.
The blog outlines one method for handling Slowly Changing Dimensions – probably the most popular method referred to as type 2. Could be applied to any data base product – but – this applies to Redshift and Snowflake and more… A type 2 slowly changing dimension enables you to track the history of updates to …
Data Warehouse design – Type 2 Slowly Changing Dimensions Read More »
To find blocking locks: select a.txn_owner, a.txn_db, a.xid, a.pid, a.txn_start, a.lock_mode, a.relation as table_id,nvl(trim(c.”name”),d.relname) as tablename, a.granted,b.pid as blocking_pid ,datediff(s,a.txn_start,getdate())/86400||’ days ‘||datediff(s,a.txn_start,getdate())%86400/3600||’ hrs ‘||datediff(s,a.txn_start,getdate())%3600/60||’ mins ‘||datediff(s,a.txn_start,getdate())%60||’ secs’ as txn_duration from svv_transactions a left join (select pid,relation,granted from pg_locks group by 1,2,3) b on a.relation=b.relation and a.granted=’f’ and b.granted=’t’ left join (select * from stv_tbl_perm where …
Basically it comes down to this syntactical example: GRANT USAGE ON DATASHARE salesshare TO NAMESPACE ’13b8833d-17c6-4f16-8fe4-1a018f5ed00d’; To determine the namespace of the cluster you want to grant the share to you or someone with access to the cluster should issue this command to identify the namespace that should be grant access to the share: SELECT …
Redshift – The basics of granting a shared database or subset of a database Read More »
I haven’t tested everyone of these but here is the link to the long list of them. If they all work I would be shocked, as it looks more like a generic list of parameters for JDBC database connections in general https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuration-options.html
set session authorization ‘username’; SET SESSION AUTHORIZATION – Amazon Redshift BTW – you can do this with Oracle too I believe with:
Redshift TCP/IP keep alive settings for Linux / EC2 and Windows URL https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html
You may want to use something like this to guide you in implementing cross account s3 access when using Redshift copy or unload: https://aws.amazon.com/premiumsupport/knowledge-center/redshift-s3-cross-account/ It is a somewhat long and drawn out process, which is why I suggest you simply setup a bucket in the same account and region but, if it must be done, …