How to Make a Query Layer for Sqlite?

[KirkKuykendall1]

Hi -

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

Thanks, Kirk

[Anonymous User · Accepted solution]

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

[KirkKuykendall1]

Thanks, I've submitted idea for .geodatabase support in Make Query Layer.

[DwayneKuykendall]

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.