I have created an Object Schema in ION Desk and ingested some data into Data Fabric (Through Data Loader) which was successfully transferred.
However, there were some issues with the data model, so I:
1. purged the data,
2. I removed the entries in Atlas
3. I've been running these queries in Compass:
EXEC INFOR.CLEAR_TABLE('RADATA_AMORTERINGAR', 'True')
EXEC INFOR.CLEAR_TABLE('RADATA_AMORTERINGAR', 'False')
EXEC INFOR.CLEAR_DATA('RADATA_AMORTERINGAR', '2024-01-12')
4. I've deleted the Object Schema in ION Desk
The table 'RADATA_AMORTERINGAR' is nowhere to be found, I cannot see it in Atlas or Compass, nor the Object Schemas. I also cannot seem to find anything regards to that specific table when running Data Lake queries.
However, when testing a query in Compass with "SELECT * FROM RADATA_AMORTERINGAR" I do get the column names without any data, looking at the networking in dev-tools it shows that the columns are still cached.
This gives me an issue in the ETL Tool as it seems to be fetching the old cached data types, even though I create a new Object Schema with changed data types, and run the Data Loader, it still shows the old column data types.
Does anyone know how to completely delete everything around a table in Data Lake? Currently, something seems to be cached.
Image showing that there's no "RADATA_AMORTERINGAR" table anywhere to be found.
