CODEWITHSUNDEEP
azureazure-data-factory
Radim Pluskal
Radim Pluskal

Reputation: 111

Table Storage query CopyPipeline

I need configure Azure Data Factory CopyPipeline source query for copying data from Storage Table by PartitionKey, and I can not find how I can do it ...

Which language is used for querying here? I found something about FetchXML, but it is totally unknown to me. Is there some other variant?

For example (in T-SQL) - I need simply something like this:

SELECT * FROM [StorageTableName] WHERE PartitionKey = [MyPartKey]

Thanks for the help...

Edit: I found this article (https://learn.microsoft.com/cs-cz/azure/data-factory/v1/data-factory-azure-table-connector#azure-table-copy-activity-type-properties) and try query example:

"azureTableSourceQuery": "$$Text.Format('PartitionKey ge \'{0:yyyyMMddHH00_0000}\' and PartitionKey le \'{0:yyyyMMddHH00_9999}\'', SliceStart)"

, but I got just error:

A storage operation failed with the following error 'The remote server returned an error: (400) Bad Request.'.. Activity ID: ...

Upvotes: 0

Views: 153

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

The table storage query code is like this:

1. (PartitionKey eq 'Sales') and (RowKey eq 'Smith')
2. PartitionKey eq '1' and RowKey ge '2' 
3. PartitionKey eq 'Sales' and LastName eq 'Smith'

Replace the '0' and '1' with your PartitionKey and RowKey value.

enter image description here

You can reference this document How your choice of PartitionKey and RowKey impacts query performance.

Hope this helps.

Upvotes: 1

Related Questions