ArcGIS Pro 3.1 requirements for SQLite

Visit Esri Technical Support for information on the Esri Supported Environment Policy.

ArcGIS Pro can access SQLite databases and OGC GeoPackage files and supports connections to mobile geodatabases.

Minimum supported database versions

SQLite 3.40.1 is the latest version certified with ArcGIS. ArcGIS supports all minor and patch versions of SQLite 3.x that are still supported by SQLite.

Supported add-ons

The following versions are supported with ArcGIS:

OGC GeoPackage 1.1 through and including 1.3

SpatiaLite 4.0.0

OGC GeoPackage registered extension support

The following GeoPackage registered extensions are partially or fully supported:

GeoPackage extensionArcGIS support

Metadata

ArcGIS creates the gpkg_metadata and gpkg_metadata_reference tables when you use the Create SQLite Database tool to create the GeoPackage, but you cannot use the ArcGIS Pro metadata editor to populate these tables, and ArcGIS does not read the entries present in these tables.

If you publish a hosted feature layer from a GeoPackage that has metadata in these tables, the metadata is not preserved in the published layer.

Non-Linear Geometry Types

ArcGIS Pro can read and display approximated shapes but cannot create them.

If you publish a GeoPackage that contains approximated shapes, the resultant hosted feature layer contains equivalent linear approximations of the shapes present in the source file.

RTree Spatial Indexes

Fully supported.

Schema

ArcGIS creates the gpkg_data_columns table when you use the Create SQLite Database tool to create the GeoPackage; however, you define enumerations, ranges, GLOBs, or MIME types using ArcGIS. If you define these using SQL, ArcGIS does not recognize them.

If you publish a hosted feature layer from a GeoPackage that has these defined, they are not preserved in the published data.

WKT for Coordinate Reference Systems

Fully supported.

Database requirements and limitations

The following database requirements and limitations apply:

  • SQLite database files must have a .sqlite extension to be recognized by ArcGIS.
  • GeoPackage files must have a .gpkg extension to be recognized by ArcGIS.
  • You cannot create a geodatabase in an existing SQLite database. However, you can create a mobile geodatabase, which will create both the geodatabase and the SQLite database in which it is stored.
  • You cannot publish web services that reference registered data from an SQLite database, GeoPackage file, or mobile geodatabase.

Platform support

The following platforms are supported:

  • All platforms supported by ArcGIS Desktop and ArcGIS Pro
  • All platforms supported by ArcGIS Runtime SDK
  • All platforms supported by ArcGIS Enterprise

Cloud support

See Requirements for using ArcGIS with databases in the cloud for information on support for database services and databases deployed in the cloud.