idea Import .CSV to enterprise geodatabase — Import schema only in ArcGIS Pro Ideas

Import .CSV to enterprise geodatabase — Import schema only

Bud — Thu, 23 Jan 2025 01:22:38 GMT

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:

When importing a .CSV into an enterprise geodatabase as a standalone table:

It would be great if we could import the schema only, not the data.

Use case: Modify the field data types in the new table via the Fields View before importing the data, since field types can only be changed when the table is empty. I'm aware that I can import the rows and then delete them. But that seems unnecessarily cumbersome.

Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool

Re: Import .CSV to enterprise geodatabase — Import schema only

Bud — Thu, 24 Oct 2024 20:38:56 GMT

Yes, the field data types can be defined when importing. https://community.esri.com/t5/arcgis-pro-ideas/define-field-data-types-as-part-of-import-process/idc-p/1552053#M32535

But I still want the option of importing an empty table and then fiddling with the fields before importing the data.

Re: Import .CSV to enterprise geodatabase — Import schema only

Bud — Thu, 24 Oct 2024 21:44:57 GMT

@AlfredBaldenweck might like this workaround:

Use the SQL expression WHERE 1=2 to exclude all rows from the import, importing the schema only.

Re: Import .CSV to enterprise geodatabase — Import schema only

AlfredBaldenweck — Fri, 25 Oct 2024 16:27:12 GMT

That is extremely sneaky. I love it.

Re: Import .CSV to enterprise geodatabase — Import schema only

Bud — Mon, 28 Oct 2024 17:20:21 GMT

For my notes, Table to Table (ArcGIS Pro 2.9.5) has been replaced with the Export Table geoprocessing tool in newer versions of Pro.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/table-to-table.htm

Re: Import .CSV to enterprise geodatabase — Import schema only

Bud — Thu, 31 Oct 2024 10:24:39 GMT

An alternative option:

Create a table from scratch using Catalog and import the fields/schema from the CSV, instead of importing the CSV as a new table. Creating a table from scratch would allow me to easily adjust the imported field types and lengths while creating the table.