What is the Data Access module

The Data Access module, arcpy.da, is a Python module for working with data. It allows control of the edit session, edit operation, improved cursor support (including faster performance), functions for converting tables and feature classes to and from NumPy arrays, and support for versioning, replicas, domains, and subtypes workflows.

Data Access classes


Class	Description
`ContingentFieldValue`	The `ContingentFieldValue` object contains properties that describe the properties of the field used for a contingent value.
`ContingentValue`	The `ContingentValue` object contains properties that describe a contingent value.
`DatabaseSequence`	The `DatabaseSequence` object contains properties that describe a database sequence.
`Domain`	The `Domain` object contains properties that describe an attribute domain.
`Editor`	The `Editor` object allows the use of edit sessions and operations to manage database transactions.
`InsertCursor`	The `InsertCursor` object establishes a write cursor on a feature class or table. `InsertCursor` can be used to add new rows.
`Replica`	The `Replica` object contains properties that describe a replica.
`SearchCursor`	The `SearchCursor` object establishes read-only access to the records of a feature class or table.
`SearchRelatedRecords`	The `SearchRelatedRecords` object retrieves related records based on the relationship between the origin and destination feature class or table defined in a relationship class.
`SyncReplica`	The `SyncReplica` object contains properties that describe a replica created through a sync-enabled feature service. Replicas created from nonversioned data with archiving or from branch versioned data are included.
`UpdateCursor`	The `UpdateCursor` object establishes read-write access to records returned from a feature class or table.
`Version`	The `Version` object contains properties that describe a version.

Data Access functions


Function	Description
`CreateParquetCache`	The `CreateParquetCache` function creates a persistent local cache for an Apache Parquet file.
`CreateTable`	The `CreateTable` function creates a table or feature class with a defined set of fields in a specified location.
`Describe`	The `Describe` function returns a dictionary with multiple data properties, such as data type, fields, indexes, and many others. The dictionary's keys are dynamic, meaning that depending on what data type is described, different properties will be available for use.
`ExtendTable`	The `ExtendTable` function joins the contents of a NumPy structured array to a table based on a common attribute field. The input table is updated to contain the fields from the join table.
`FeatureClassToNumPyArray`	The `FeatureClassToNumPyArray` function converts a feature class to NumPy structured array.
`ListContingentValues`	The `ListContingentValues` function lists the contingent values on a table. Search conditions can be specified for the field group name and subtype to limit the list that is returned.
`ListDatabaseSequences`	The `ListDatabaseSequences` function lists the database sequences in a database.
`ListDomains`	The `ListDomains` function lists the attribute domains belonging to a geodatabase.
`ListFieldConflictFilters`	The `ListFieldConflictFilters` function lists the fields in a versioned feature class, table, or feature service layer that have field conflict filters applied.
`ListReplicas`	The `ListReplicas` function lists the replicas in the workspace.
`ListSubtypes`	The `ListSubtypes` returns a dictionary of the subtypes for a table or feature class.
`ListVersions`	The `ListVersions` function lists the versions in the workspace.
`NumPyArrayToFeatureClass`	The `NumPyArrayToFeatureClass` function converts a NumPy structured array to a point feature class.
`NumPyArrayToTable`	The `NumPyArrayToTable` function converts a NumPy structured array to a table.
`TableToArrowTable`	The `TableToArrowTable` function converts a table or feature class to an Apache Arrow table.
`TableToNumPyArray`	The `TableToNumPyArray` function converts a table to a NumPy structured array.
`Walk`	The `Walk` function returns data names in directory and database structures by moving through the tree from the top down or the bottom up. Each directory or workspace yields a tuple of three: directory path, directory names, and file names.