How to perform CDC from PostgreSQL to Big Query by using DataStream in Google Cloud Platform

Опубликовано: 09 Январь 2025
на канале: TechBrothersIT

4,223

How to perform CDC from PostgreSQL to Big Query by using DataStream in Google Cloud Platform | Google Cloud Platform Tutorial 2023, in this video we are going to learn How to perform CDC from PostgreSQL to Big Query by using DataStream in Google Cloud Platform| Google Cloud Platform SQL Tutorial 2023, Google Cloud Platform Step by Step - GCP Tutorial 2023 - GCP Tutorial 2023 Step by Step - Google Cloud Platform Tutorial 2023.

Script:
CREATE PUBLICATION aamirpublication FOR ALL TABLES;

alter user repl with replication;

SELECT PG_CREATE_LOGICAL_REPLICATION_SLOT
('aamirreplicationslot', 'pgoutput');

CREATE USER repl WITH REPLICATION IN ROLE
cloudsqlsuperuser LOGIN PASSWORD 'test123$';

GRANT SELECT ON ALL TABLES IN SCHEMA public TO repl;
GRANT USAGE ON SCHEMA public TO repl;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO repl;

Create table customer (id int, name varchar(100), salary numeric(5,1))

insert into customer values (2,'Aamir2',1040.5)

insert into customer values (3,'lisa',200.5)

Select * From customer

#googlecloud #googlecloudplatform