How to perform CDC from PostgreSQL to Big Query by using DataStream in Google Cloud Platform
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- 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
Hi folks, first off this is a GREAT video. I set up an entire datapipeline with this. 1 Problem. How do I change the "datastream_meta_data_is_deleted" to true?
Hello, I think is not possible to set it to write mode append only ?
I need support for replication on AG. could you please help me.