Data Analytics Studio Operations
Also available as:
PDF

Managing tables

Using the Database Explorer UI, you can view information about table columns, partitions, storage, and metadata, as well as preview a few rows from the table. This enables you to ensure that your table contains exactly the information that you intend it to.

For each table, you can view details from the following tabs:

  • Columns

    You can view the details of each column of the table. You can also search for columns using the Search box.

  • Partitions

    You can view the details of columns that are partitions in the table. You can also search from the list of columns.

  • Storage Information

    You can view the storage information such as input format, output format, if the table is compressed, number of buckets, buck columns, and so on.

  • Detailed Information

    You can view details such as the name of the database, the owner of the table, the created time, the last accessed time, table type, and so on.

  • Statistics

    You can view the table statistics and column statistics.

  • Data Preview

    You can preview a few rows from the table.