Am trying to sync a SQL server table data to icebe...
# troubleshooting
s
Am trying to sync a SQL server table data to iceberg table (filesysystem) on an Ubuntu machine using Flink JDBC connector. However when I try to create the table using with properties, am able to execute the code without any exceptions but then there is no data flowing to iceberg table. Below is the code, can some help to check what am I doing wrong? from pyflink.table import EnvironmentSettings, TableEnvironment # Set batch mode env_settings = EnvironmentSettings.in_batch_mode() table_env = TableEnvironment.create(env_settings) table_env.execute_sql(""" CREATE CATALOG horizon_user_catalog WITH ( 'type' = 'iceberg', 'catalog-type' = 'hadoop', 'warehouse' = 'file:///data/icebergdwh/hrzn/', 'property-version' = '1' ) """) table_env.execute_sql("USE CATALOG horizon_user_catalog") table_env.execute_sql("CREATE DATABASE demo2") table_env.execute_sql("USE demo2") table_env.execute_sql(""" CREATE TABLE test_jdbc_read2 ( id BIGINT, uname STRING, PRIMARY KEY (id) NOT ENFORCED ) WITH ( 'connector' = 'jdbc', 'url' = 'jdbc:sqlserver://abc:1234;databaseName=iceberg', 'table-name' = 'dbo.usertable', 'username' = 'dwh', 'password' = 'xyzabc123789', 'driver' = 'com.microsoft.sqlserver.jdbc.SQLServerDriver' ) """) table_env.execute_sql("SHOW TABLES").print() table_env.execute_sql("SELECT * FROM horizon_user_catalog.demo2.test_jdbc_read2 limit 10").print() table_env.execute_sql("SELECT count(*) FROM test_jdbc_read2").print()