Version: 3.2.0
Source: AzureTableAPI (Cosmos)
Sink: SqlServer
When using the cosmos.azure.com explorer the filter works:
But using the QueryFilter in the DMT doesn't:
"QueryFilter": "Timestamp ge datetime\u00272025-04-22T14:52:23.714Z\u0027"
or
"QueryFilter": "Timestamp ge datetime'2025-04-22T14:52:23.714Z'"
This is the output (Rows affected: 0 but in the Cosmos explorer there are 7 rows returned):
Using AzureTableAPI Source
Using SqlServer Sink
info: AzureTableAPIDataSourceExtension[0]
Connecting to Storage account https://blablabla.table.cosmos.azure.com:443/ using UseRbacAuth with EnableInteractiveCredentials'
info: SqlServerDataSinkExtension[0]
Executing MERGE statement for upsert operation
info: SqlServerDataSinkExtension[0]
MERGE completed. Rows affected: 0
info: Cosmos.DataTransfer.Core.RunCommand.CommandHandler[0]
Data transfer complete
It seems this PR done by Copilot didn't fix the issue: #231. I think this is enough data needed to investigate this issue, let me know if something else is needed. Thanks!
Version: 3.2.0
Source: AzureTableAPI (Cosmos)
Sink: SqlServer
When using the cosmos.azure.com explorer the filter works:
But using the QueryFilter in the DMT doesn't:
"QueryFilter": "Timestamp ge datetime\u00272025-04-22T14:52:23.714Z\u0027"or
"QueryFilter": "Timestamp ge datetime'2025-04-22T14:52:23.714Z'"This is the output (Rows affected: 0 but in the Cosmos explorer there are 7 rows returned):
It seems this PR done by Copilot didn't fix the issue: #231. I think this is enough data needed to investigate this issue, let me know if something else is needed. Thanks!