05-29-2022 10:18 PM
Hi - We have 100 + schemas in our tenant, I need to find out which are all the schemas are using local files. Is there a way to find it? If its there, please tell me how do we do it?
05-30-2022 07:16 AM
To My Knowledge we can get that by using Inspector tool, where we can see the metadata of schemas.
we can see the source of a table.
Will check if we can get some info from Incorta_MetaData or Audit schema, haven't tried it.
06-01-2022 03:06 PM
One way to know this is from the xml definition for the schema ( If you exported the schema it will be an archive file of 2 files <schemaid>_loader.xml and <schemaid>_schema.xml.
The loader file will have the schema definition, A table with localfile will have a line like the below.
<dataset callbackOn="false" displaySource="LocalFiles / PK.csv" incremental="false" source="LocalFiles" subType="local" table="Amr.PK" type="fs" version="1">
Similarly a tenant export will be an archive , Folder schemas is having all the exported schemas. You can then apply a command like below in schema folder, The files that will appear is the schema that have localfiles
$ grep -l "source=\"LocalFiles\"" *_loader.xml