For your examples you could craft a routine to tell you this information
anything ending in a gdb will be file geodatabase
do a describe on a sde connection and look at the instance will tell you that database it is based on the connection string e.g.
desc = arcpy.Describe(Database Connections\Localhost SQL.sde)
cp = desc.connectionProperties
print cp.instance
> sde:sqlserver:svr-gis-01
The only issue I see are the old style SDE connection where the instance will be a port number.
We're working on this! This status does not guarantee that the functionality will be in the next release, but development work has begun. Release cycles vary by product so make sure to check the product life cycle information to get an idea of when to expect the next release.
This is implemented in ArcGIS Pro 3.3. See Your Ideas in ArcGIS Pro 3.3 for a full list of all user ideas you can look forward to! And be sure to check out the release blog and what’s new help topic and video to learn more about all the new features and functionality in the release.
@HannesZiegler or @KoryKramer - could you elaborate on how this was implemented? I am not seeing this in the describe object still at 3.4 and don't see any mention of it in the linked release blog or help topic. Thanks!
@philnagel Apologies, we didn't cover this properly when we closed the idea, the underlying database can be identified using the dbClient property of connectionProperties when describing SDE workspaces: Workspace properties—ArcGIS Pro | Documentation
desc = arcpy.Describe("C:\\...\\mydb.sde")
print(desc.connectionProperties.dbClient)
Would return the one of the following for SDE workspaces:
FileGDB
Sqlite
sqlserver
oracle
postgresql
@HannesZiegler Thank you - I do see those entries now in the docs. What threw me for a loop was that it does not get included when using arcpy.da.Describe.
Any ideas on that? Is that a bug?
Yea that is an issue, there is an idea for it here: arcpy.da.Describe should return the same data as a... - Esri Community
You can upvote (kudo) it, we keep tabs on ideas (this one is already under consideration)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.