Make query layer returns 0 records, both from toolbox and arcpy.

ScottBridwell

Is this a known issue? The same exact code works in ArcMap 10.7.1 toolbox and arcpy.

ScottBridwell

Looks like in the ArcPro version, there is an additional parameter called spatial_properties, that wasn't in the ArcMap version.

Setting this property seems to resolve my issue, e.g:

arcpy.MakeQueryLayer_management(
    my_db_conn,
    'layer',
    'select * from my_table',

    oid_fields='objectid',
    spatial_properties='DO_NOT_DEFINE_SPATIAL_PROPERTIES'
)

I guess in ArcMap the default behavior was to not provide spatial properties whereas in ArcPro the default behavior assumes you will provide them.