Paul BrabbanTime travelling with change data captureIn the last article of the series, I ran into difficulties as I tried to “time-travel” back to earlier points in time. That’s an important…Aug 18Aug 18
Paul BrabbanMap over an array in BigQueryThis walkthrough shows how I can use the functional programming techniques map and filter that I already know and love in SQL engines like…Jul 31Jul 31
Paul BrabbanPreventing data theft with GCP service controlsI recently discovered and responsibly disclosed a vulnerability in the dbt analytics engineering solution. Google Cloud services are my…Jul 6Jul 6
Paul BrabbanAre you at risk from this critical dbt vulnerability?A newly discovered critical security vulnerability in the dbt ecosystem (originally published on equalexperts.com)Jul 2Jul 2
Paul BrabbanLatest and historical state from change data captureIn previous posts, I disambiguated transactions by filtering out any transient statements and noted that changes in primary key values…Jun 28Jun 28
Paul BrabbanBreaking Change Data Capture with primary keysMy work on dealing with multiple tables was interrupted when I discovered a subtle scenario that leads to DMS CDC output that cannot be…Jun 12Jun 12
Paul BrabbanDisambiguating Transactions in Change Data CaptureIn the CDC output, I get a row for each statement executing in the transaction. Each row reflects the state of the database when that…Jun 41Jun 41
Paul BrabbaninDev GeniusHandling CVE-2019–8341 for dbt and mkdocsYesterday, Safety told me about CVE-2019–8341, a security issue affecting Jinja2. I’ll walk through how I investigated and assessed the…Jun 2Jun 2
Paul BrabbanExploring Transactions in Change Data CaptureLast time, I set up a CDC system using AWS RDS and DMS services. Now, I’ll run some operations through the source database and show what…May 28May 28
Paul BrabbanChange Data Capture with AWS DMSSetting up Change Data Capture from Aurora Serverless PostgreSQL to S3 via the AWS DMS service. I’ll walk through the demo setup, using the…May 21May 21