This FAQ covers common issues when using Information Schema to query MaxCompute project metadata.
Information Schema updates table metadata with a delay of at least three hours. If your query returns incomplete results, wait at least three hours after the relevant table operation, then retry.
How do I check when a data record was synchronized to MaxCompute?
You cannot retrieve the synchronization timestamp for a specific record after incremental synchronization. The closest available alternative is to query LastModifiedTime from the table metadata, which reflects the last time the table was modified.
For more information about available metadata fields, see Information Schema.
How do I use Information Schema to query table metadata?
For more information, see Information Schema.
Some tables are missing from information_schema.tables query results. What should I do?
Information Schema updates table metadata with a delay of at least three hours. If you query metadata shortly after creating a table, the table may not appear yet.
Wait at least three hours after the table is created, then run the query again.