FAQ about using Information Schema-MaxCompute(MaxCompute)-阿里云帮助中心

This topic answers common questions about using Information Schema.

Question category	FAQ
Using Information Schema	After an incremental synchronization from a data source, how can I check the specific time a piece of data was synced to MaxCompute? How do I view the Information Schema of a table? What should I do if not all tables in a MaxCompute project are found in information_schema.tables? What are the practical uses of Information Schema?

After an incremental synchronization from a data source, how can I check the specific time a piece of data was synced to MaxCompute?

You cannot check the specific time when a piece of data was synchronized to MaxCompute. Instead, you can view the LastModifiedTime of the table's metadata. For more information, see Information Schema.

How do I view the Information Schema of a table?

For more information, see Information Schema.

What should I do if not all tables in a MaxCompute project are found in information_schema.tables?

Updates to MaxCompute metadata are delayed by at least 3 hours. Confirm the table creation time and wait for 3 hours before checking again.

What are the practical uses of Information Schema?

The tenant-level Information Schema in MaxCompute provides project metadata and historical usage data. It lets you pull a specific type of metadata for all projects under the same Metadata Center at once to perform various statistical analyses: