Can database connections in Favorites be referenced in ArcPy

Question

Instead of having egdb connection files in the project folder I'll rather refence them from Favorites.  Is there a ArcPy variable?

DavidSolari · Answer

Nothing formal in arcpy for most -- if not all -- application properties, but assuming your Pro installation uses the standard paths:

import ujson
from os import path
with open(path.expandvars(r"%APPDATA%\Esri\ArcGISPro\Favorites\Favorites.json")) as f:
    fav_data = ujson.load(f)

and then you can scan through the dictionary to get the paths you need.

Brian_McLeer · Answer

Hello @RandyKreuziger1, you can and it would the file path "C:\Users\your user name\AppData\Roaming\Esri\ArcGISPro\Favorites\connection name.sde"