Snowflake optimization – use Cluster Keys when a dominate access path is known
This will colocate data often queried together into the same or adjacent micro-partitions. This will expedite retrieval and reduce warehouse […]
Snowflake
April 2023
Hudi
Apache Hudi
When define a Hudi table you must define one of two supported data storage types. Supported Hudi dataset storage types:
Amazon AWS
Securing AWS API Gateway
A good place to get started on this important subject: https://docs.aws.amazon.com/apigateway/latest/developerguide/apigateway-control-access-to-api.html https://docs.aws.amazon.com/apigateway/latest/developerguide/security.html
Oracle, RAC
One of the Best Oracle RAC Architecture Documents I’ve Ever Read
https://oracle-patches.com/en/databases/oracle/oracle-rac-networking-concepts-and-components
JSON
JSON Beautifier ( Make Pretty )
Just a json formatter: https://jsonformatter.curiousconcept.com/
Databases
Role Based Access Control (RBAC) vs Attribute Based Access Control (ABAC)
RBAC provides access to resources or information based on user roles. ABAC provides access rights based on user, environment, or
Amazon AWS, IAM
AWS lAM Roles the Basics
AWS IAM roles define two types of policies Permissions Policy – Defines what permissions the role is granted Trust Policies
RDS, Uncategorized
Enable MySQL Aurora Advanced Logging / Audit
need to audit connections, DDL, DML, permissions/grant changes and a lot more? set the following parameter in your custom parameter
DMS
When adding a AWS DMS replication instance, what is best practice for the location of the instance?
Put the DMS instance in the same VPC, and availability zone as the TARGET database.
Amazon AWS, Redshift
Default maximum number of manual snapshots retained at any one time is 20
Reach out to AWS Support to increase this #. They will gladly. If you try to create a 21st your