Select to view content in your preferred language

MakeQueryLayer_management doesnt return all entries in ArcGIS Pro

276
0
07-13-2023 07:34 AM
ACS
by
New Contributor

i am trying to get all entries from a table with 2.000.000 entries. when using arcgis desktop and python 2.7 everything works ok but when using ArcGIS Pro and python 3 it only returns 200 entries. is this a timeout issue?

 

Below is a snippet of the code that i am using.

 

        env.workspace = localworkingPath
        arcpy.MakeQueryLayer_management(GisData_sde,
                                'selection',
                                'select * from [GIS_DATA].[dbo].[atable]')
        
        # Write the selected features to a new featureclass
        arcpy.CopyFeatures_management("selection", afeatureclass)  

 

 

0 Replies