BigQuery provides fine-grained access to sensitive columns using policy tags, or type-based classification, of data. Using BigQuery column-level access control, you can create policies that check whether a user has proper access at query time. For example, a policy can enforce…

LOVs (List Of Values) is a great feature of Oracle forms and is widely used. Sometimes you might run into an issue with missing screen fields for drop down boxes for the LOVs (List Of Values) , i.e. when you…

In our previous discussion we explored the application of data governance programs to legacy technology platforms. We explored methods to ensure high levels of integrity with data managed on these legacy platforms and what organizational investments allow us to reduce risk and…

Patroni Patroni is a High Availability solution for PostgreSQL using asynchronous streaming replication, Etcd, and HAProxy. For more details, you can read the Patroni documentation which is really good and covers many details. In this post, I will explain: Patroni architecture Ansible for patroni cluster…

What is Apache Airflow? Airflow is a platform to programmatically author (designing pipelines, creating workflows), schedule, and monitor workflows. These functions are achieved with Directed Acyclic Graphs (DAG) of the tasks. It is open-source and still in the incubator stage….

Google wants to ensure that its customers are successful in the cloud. To do that, partners play a vital role, particularly in areas that require skilled expertise such as data analytics, artificial intelligence, Kubernetes and other emerging tech. That’s why…

Oracle has a documented process for using Oracle logical standby transient Database (TLS) to minimize downtime during database upgrades. I would like to share my experience in the real world using this process to get an Oracle database migrated. I…

Running a business in a technological era is exciting, however tough to keep up with. It seems like everyone and their neighbor has the latest and greatest when it comes to maintaining a technological edge. Landscape shifting services and products…

Summary In this blog I will explain pg_rewind use case to solve split brain after a database failover happens. Split Brain Syndrome Split Brain is often used to describe the scenario when two or more nodes in a cluster, lose…

In our previous post we discussed the governance requirements for creating, managing and deploying analytical models. Analytical models do not stand on their own in today’s complex data landscapes. They have unique needs that must be captured in policy, automated…