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
Download
0 formats
No download links available.
How to perform CDC from PostgreSQL to Big Query by using DataStream in Google Cloud Platform | NatokHD
