How to Make a Query Layer for Sqlite?

227
3
Jump to solution
01-11-2021 08:12 AM
KirkKuykendall1
Occasional Contributor II

Hi -

Why can't I use a .geodatabase file as a database connection?

image.png

Thanks, Kirk

 

 

Tags (2)
Reply
0 Kudos
1 Solution

Accepted Solutions
CalvinLietz
Esri Contributor

Hi Kirk,

The .geodatabase file type is a SQLite geodatabase used for runtime applications, such as Collector for ArcGIS. The Make Query Layer geoprocessing tool is looking for a .sde database connection file, such as the one generated from the Create Database Connection geoprocessing tool.

-Calvin

View solution in original post

3 Replies
CalvinLietz
Esri Contributor

Hi Kirk,

The .geodatabase file type is a SQLite geodatabase used for runtime applications, such as Collector for ArcGIS. The Make Query Layer geoprocessing tool is looking for a .sde database connection file, such as the one generated from the Create Database Connection geoprocessing tool.

-Calvin

View solution in original post

KirkKuykendall1
Occasional Contributor II
DwayneKuykendall
New Contributor II

Kirk,

I found that to make ArcMap/ArcGIS Pro recognize a .geodatabase file as SQLite, make a copy and rename the extension to .sqlite.  Also, you will need to remove/rename the the "GDB_Items" and "GDB_Version" tables. 

Of course, this works for "read-only" workflows and probably not recommended for inserting/updating features within the views.