sijieg
06/19/2024, 8:53 PMRunLLM
06/19/2024, 8:53 PMCREATE DATABASE io_database;
CREATE TABLE `io_database`.`io-test` (
`id` INT AUTO_INCREMENT,
`first_name` TEXT,
`last_name` TEXT,
`age` INT,
PRIMARY KEY (`id`)
);
- Create the connector using `pulsarctl`:
pulsarctl sources create \
--source-type debezium-mysql \
--name debezium-mysql-source \
--tenant public \
--namespace default \
--parallelism 1 \
--source-config '{
"database.hostname": "Your hostname of MySQL",
"database.port": "Your port of MySQL",
"database.user": "Your user of MySQL",
"database.password": "Your password of MySQL",
"database.dbname": "Your dbname of MySQL",
"table.whitelist": "public.io-test",
"database.server.name": "mydbserver"
}'
2. Setup Snowflake Sink Connector:
- Create the connector using `pulsarctl`:
pulsarctl sinks create \
--sink-type snowflake \
--name snowflake-sink \
--tenant public \
--namespace default \
--inputs "public/default/mydbserver.public.io-test" \
--parallelism 1 \
--sink-config '{
"user": "SNSERVICE",
"host": "https://account_identifier.snowflakecomputing.com",
"schema": "demo",
"database": "st_tuts",
"privateKey": "...",
"warehouse": "compute_wh"
}'
Would you like more details on any specific step?
Sources:
- Debezium MySQL Source v2.10 👍 0 button 👎 0 button 💡 Hint: Mention @runllm in the thread for followups.