issue to load data to snowflake from source Azure Cosmos DB API SQL ( jdbc driver)

User2223536929692142 — Mon, 10 Aug 2020 09:42:46 GMT

Hi everyone , i have this problem when i try to load data with snowflake component. The source is Azure Cosmos DB with driver jdbc. See the screenshot bellow and details.

Exception in thread "main" java.lang.NoSuchMethodError: org.talend.components.common.config.jdbc.DbmsType.<init>(Ljava/lang/String;)V at org.talend.components.snowflake.SnowflakeTypes.<clinit>(SnowflakeTypes.java:26) at org.talend.components.snowflake.runtime.tableaction.SnowflakeTableActionConfig.<init>(SnowflakeTableActionConfig.java:38) at org.talend.components.snowflake.runtime.SnowflakeWriter.execTableAction(SnowflakeWriter.java:211) at org.talend.components.snowflake.runtime.SnowflakeWriter.tableActionManagement(SnowflakeWriter.java:236) at org.talend.components.snowflake.runtime.SnowflakeWriter.write(SnowflakeWriter.java:266) at pai.test_cosmosdb2_0_1.test_cosmosDB2.tDBInput_1Process(test_cosmosDB2.java:5601) at pai.test_cosmosdb2_0_1.test_cosmosDB2.tDBConnection_2Process(test_cosmosDB2.java:1498) at pai.test_cosmosdb2_0_1.test_cosmosDB2.runJobInTOS(test_cosmosDB2.java:6921) at pai.test_cosmosdb2_0_1.test_cosmosDB2.main(test_cosmosDB2.java:6747)

Re: issue to load data to snowflake from source Azure Cosmos DB API SQL ( jdbc driver)

Anonymous — Tue, 11 Aug 2020 07:00:41 GMT

Hello,

Are you able to set up Azure Cosmos DB connection and retrieve data from it in talend?

Best regards

Sabrina

Re: issue to load data to snowflake from source Azure Cosmos DB API SQL ( jdbc driver)

User2223536929692142 — Tue, 11 Aug 2020 12:40:15 GMT

Hello,

This is possible with an external Cosmos DB jdbc driver.

Best regards.

topic Re: issue to load data to snowflake from source Azure Cosmos DB API SQL ( jdbc driver) in Talend Studio

issue to load data to snowflake from source Azure Cosmos DB API SQL ( jdbc driver)

Re: issue to load data to snowflake from source Azure Cosmos DB API SQL ( jdbc driver)

Re: issue to load data to snowflake from source Azure Cosmos DB API SQL ( jdbc driver)