Access archived table via arcpy

MKF62 — Tue, 08 Oct 2019 12:52:11 GMT

What is the way to do this? I want to be able to read the gdb_from_date and gdb_to_date fields of the archive table using arcpy. How do you instantiate the archived table?

Re: Access archived table via arcpy

MKF62 — Sat, 11 Dec 2021 20:52:34 GMT

I figured out that you need to make a query layer in order to access this information from arcpy. Script looks like this:

import arcpy, os

collector_db_con = r"Database Connections\CollectorSpatialData_CollectorWriter.sde"
output = arcpy.MakeQueryLayer_management(collector_db_con, "Out", "select * from COVEYCOUNT where GDB_TO_DATE = '2019-09-30 13:56:44.4300000'")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

topic Re: Access archived table via arcpy in Python Questions

Access archived table via arcpy

Re: Access archived table via arcpy