This topic provides answers to some frequently asked questions about Information Schema.

Category FAQ
Usage of Information Schema

How do I view the time when a data record is synchronized to MaxCompute after data is incrementally synchronized from a data source to MaxCompute?

You cannot view the time when a specific data record is synchronized to MaxCompute. You can view LastModifiedTime of the table metadata to learn the time at which the table was last modified. For more information, see Information Schema.

How do I use Information Schema to query the metadata of tables?

For more information, see Information Schema.

When I use information_schema.tables in a command to query the metadata of all tables in a project, the metadata of some tables is not returned. What do I do?

Table metadata is updated in Information Schema with a delay of at least three hours. Check the time when the table whose metadata you want to query is created and run the command again at least three hours after the table is created.