Load ST_GEOMETRY .dll extension into SQLite/mobile geodatabase — Error: "not authorized"

Bud

I want to use ST_GEOMETRY functions in SQL queries in a ArcGIS Pro 3.1 mobile geodatabase (Windows).

The Load ST_Geometry to a mobile geodatabase for SQL access docs say:

Load the ST_Geometry library.

This example loads the ST_Geometry library to an SQLite database on a Microsoft Windows computer:

SELECT load_extension('stgeometry_sqlite.dll','SDE_SQL_funcs_init');

Here's what I've tried:

I downloaded the .DLL from MyEsri:

Using Beekeeper Studio SQL client, I connected to the mobile geodatabase and tried to run this SQL statement:

SELECT load_extension('stgeometry_sqlite.dll','SDE_SQL_funcs_init');

But I get an error:

not authorized

Anyone know how I can get around that error?

 

 

Bud

It worked with DBeaver! Thanks.

For what it's worth, DBeaver popped up this message, "SQLite driver files are missing." 
So I downloaded the drivers using DBeaver.

 

Like you said, I used the full path to the location where I downloaded the .DLL (64-bit): 

SELECT load_extension('C:\SQLite\Windows64\stgeometry_sqlite.dll','SDE_SQL_funcs_init');

Then, as the docs suggest: "Call the CreateOGCTables function to add ST_Geometry tables to the database."

SELECT CreateOGCTables();

Now, I'm able to run SQL queries that use ST_GEOMETRY functions on the mobile geodatabase:

   SELECT objectid
    FROM (SELECT ply.objectid,
                 row_number() over(partition by ply.objectid order by null) rn
            FROM ply
      CROSS JOIN pnt
           WHERE st_intersects(ply.shape, pnt.shape) = 1
         )
   WHERE rn = 1

Query source: Spatial Query Benchmarking

Ideas:

• Clarify the docs: Load ST_Geometry extension to mobile GDB — Use full path of .DLL
• Enable ST_GEOMETRY in mobile geodatabase using GP Tool