# Reading delta table data with supported 'DirectoryDeltaAsset' or 'DeltaAsset'

**URL:** <https://discourse.greatexpectations.io/t/reading-delta-table-data-with-supported-directorydeltaasset-or-deltaasset/1897>\
**Category:** GX Core Support\
**Tags:** how-to\
**Created:** [September 11, 2024, 11:59am UTC](https://discourse.greatexpectations.io/t/reading-delta-table-data-with-supported-directorydeltaasset-or-deltaasset/1897 "2024-09-11T11:59:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![iven](https://avatars.discourse-cdn.com/v4/letter/i/eb9ed0/32.png) [@iven](https://discourse.greatexpectations.io/u/iven)\
**Post date:** [September 11, 2024, 11:59am UTC](https://discourse.greatexpectations.io/t/reading-delta-table-data-with-supported-directorydeltaasset-or-deltaasset/1897/1 "2024-09-11T11:59:35Z")

</div>

I am woking with a spark\_abs data source and am finding it hard to connect to my data stored in the delta format.

# setup

- context: FileDataContext
- data-source: SparkAzureBlobStorageDatasource
- data-asset: add\_directory\_delta\_asset

# problem

When reading from an unpartitioned delta table i find that the reader attempts to read file by file which causes a partition fragment AnalysisException. Note that for this attempt the delta-table is written without any partitions.

`pth=<SOME PATH FROM ROOT OF CONTAINER>`

- `abs_name_starts_with=pth`
- `data_directory=pth`

I have yet been able to find any good documentation on the delta\_asset (or it’s directory counterpart) thus I am left questioning the impact of some of the additional requirements such as the recursive file discoverry (does the delta asset not understand the partitioning set when writing?) `version_as_of`, is that used for versioning the asset in case of changes to the data\_directory?

Thank you kindly in advance for the help on this matter

---

<div class="post-metadata">

**Author:** ![SheikHarris](https://avatars.discourse-cdn.com/v4/letter/s/e56c9b/32.png) [@SheikHarris](https://discourse.greatexpectations.io/u/SheikHarris)\
**Post date:** [January 7, 2025, 7:48am UTC](https://discourse.greatexpectations.io/t/reading-delta-table-data-with-supported-directorydeltaasset-or-deltaasset/1897/2 "2025-01-07T07:48:38Z")

</div>

am encountering an issue when trying to read from an unpartitioned Delta table. The following error is thrown:

`great_expectations.exceptions.exceptions.ExecutionEngineError: Unable to read in batch from the following path: s3a://bucket/process-zone/xyz/abc/part-00000-0047ff6c-b97b-40b9-b503-033156acb61b-c000.snappy.parquet. Please check your configuration`