Does anyone know of a method to use the table from SQL Server table using OS Authentication, instead of a File Geodatabase Table in ArcPy?
I have been using the below to reference the table
tableTemplate = r"C:\Data_table.gdb\DataTable"
where DataTable consists of a set of rows and columns. I have created a similar table in sql server and want to use the same instead of the above File Geodatabase Table.
I have tried the below so far with no luck:
arcpy.CreateDatabaseConnection_management(out_folder_path="Database Connections",
out_name="DataTable.sde",
database_platform="SQL_SERVER",
instance="gis-server",
account_authentication="OPERATING_SYSTEM_AUTH",
database="TemporaryDatabase",
version_type="TRANSACTIONAL",
version="dbo.DEFAULT")
tableTemplate = r"Database Connections\TemporaryDatabase.sde"