This text based blog borrows from and somewhat enhances the example shown in: https://www.youtube.com/watch?v=OvSzLjkMmQo The enhancement is showing you how to create these replications in custom schemas – not just public – and some gotch’yas tips when creating multiple instances on Mac OS. Regardless many thanks to the folks that created the YouTube above, it …
PostgreSQL Logical Replication (on a MacBook) example POC Read More »
https://repost.aws/knowledge-center/glue-crawler-detect-schema important: https://docs.aws.amazon.com/glue/latest/dg/crawler-configuration.html#crawler-grouping-policy (copied from the transient link above) When you run your AWS Glue crawler, the crawler does the following: Classifies the data Groups the data into tables or partitions Writes metadata to the AWS Glue Data Catalog Review the following to learn what happens when you run the crawler and how the crawler …
This will colocate data often queried together into the same or adjacent micro-partitions. This will expedite retrieval and reduce warehouse credit consumption by being more effecient at retrieving data.
When define a Hudi table you must define one of two supported data storage types. Supported Hudi dataset storage types: Copy on write Merge on read When you create a Hudi dataset, you specify that the dataset is either copy on write or merge on read. Copy on Write (CoW) – Data is stored in a …
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
https://oracle-patches.com/en/databases/oracle/oracle-rac-networking-concepts-and-components
Just a json formatter: https://jsonformatter.curiousconcept.com/
RBAC provides access to resources or information based on user roles. ABAC provides access rights based on user, environment, or resource attributes. Generally, RBAC controls broad access across an organization, ABAC takes a fine-grain approach.
AWS IAM roles define two types of policies Permissions Policy – Defines what permissions the role is granted Trust Policies – Who can assume the role AWS IAM roles are ALWAYS assumed (you cannot log into an AWS role). When a role is assumed you can specify how long you want the role to be …
need to audit connections, DDL, DML, permissions/grant changes and a lot more? set the following parameter in your custom parameter group file: Parameter Name: server_audit_events For more info: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html