In ArcGIS Online, a hosted table published from a cloud drive is converted to a hosted layer after multiple overwriting attempts.

Workaround

1. Re-publish the data
   1. If you don't mind using the new URLs and Item IDs, use this new layer instead of the old one.
   2. If you need to use the old one, still republish because we need info from the republished layer to proceed.
2. In Python API (you can use Notebooks, Pro, etc. for this)

(NOTE :: Advanced and Advanced with GPU Support Notebooks consumes credits )

• Log into the ArcGIS online >> Notebook in ArcGIS Online:

from arcgis.gis import GIS

gis = GIS("home")

• In ArcGIS Pro:

from arcgis.gis import GIS

gis = GIS("https://shortURL.maps.arcgis.com/home", username, password)

• Get the ID from ArcGIS Online for both the broken table (appearing as a Feature Layer) and the working republished table.
• In Python API, assign those items to a variable:

workingTable = gis.content.get("itemID1")

brokenTable = gis.content.get("itemID2")

• In Python API, check the typeKeywords of both:

workingTable.typeKeywords

brokenTable.typeKeywords

• Compare the results from previous two steps to find out what keywords are missing in the broken table. Likely "Table" will be one of them, but we want to include all keywords from the working Table when fixing the broken Table.
• In Python API, update the typeKeywords by adding all keywords in the working Table. For example (don't use the keywords below - replace with your own keywords.). You should get back "True" if it worked.

brokenTable.update(item_properties={'typeKeywords':['ArcGIS Server','Cloud Drive','Data','Feature Access','Feature Service','Service','Singlelayer','Table','Hosted Service']})

• Check your previously-broken Table in ArcGIS Online to see if it's fixed now.

***SAMPLE ***

from arcgis.gis import GIS

gis = GIS("home")

#OR

gis = GIS("https://shortURL.maps.arcgis.com/home", username, password)

workingTable = gis.content.get("9cd7c277a0dd4bb393fc2e2b73d7319f")

brokenFL = gis.content.get("cf77c829569f40d0b87a4d303ff20803")

workingTable.typeKeywords

Results:

['ArcGIS Server',

 'Cloud Drive',

 'Data',

 'Feature Access',

 'Feature Service',

 'Service',

 'Singlelayer',

 'Table',

 'Hosted Service']

brokenFL.typeKeywords

Results:

['ArcGIS Server',

 'Data',

 'Feature Access',

 'Feature Service',

 'Service',

 'Hosted Service']

brokenFL.update(item_properties={'typeKeywords':['ArcGIS Server','Cloud Drive','Data','Feature Access','Feature Service','Service','Singlelayer','Table','Hosted Service']})

Results:

True

brokenFL.typeKeywords

Results:

['ArcGIS Server',

 'Cloud Drive',

 'Data',

 'Feature Access',

 'Feature Service',

 'Service',

 'Singlelayer',

 'Table',

 'Hosted Service']

Steps to Reproduce