Skip to content

AzureTableAPI Source: QueryFilter with Timestamp is not working #239

@eliasmartinez93

Description

@eliasmartinez93

Version: 3.2.0
Source: AzureTableAPI (Cosmos)
Sink: SqlServer

When using the cosmos.azure.com explorer the filter works:

Image

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!

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions