topic Re: How to Make a Query Layer for Sqlite? in ArcGIS Pro SDK Questions

How to Make a Query Layer for Sqlite?

KirkKuykendall1 — Mon, 11 Jan 2021 16:13:35 GMT

Hi -

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

Thanks, Kirk

Re: How to Make a Query Layer for Sqlite?

Anonymous User — Mon, 11 Jan 2021 17:16:50 GMT

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

Re: How to Make a Query Layer for Sqlite?

KirkKuykendall1 — Mon, 11 Jan 2021 17:52:13 GMT

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

Re: How to Make a Query Layer for Sqlite?

DwayneKuykendall — Mon, 01 Mar 2021 17:23:38 GMT

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.