getTableProperties

Prev Next

Available in VPC

Get table property details.

Request

This section describes the request format. The method and URI are as follows:

Method URI
GET /api/v1/catalogs/{catalogId}/databases/{databaseName}/tables/{tableName}/properties

Request headers

For information about the headers common to all Data Catalog APIs, see Data Catalog request headers.

Request path parameters

You can use the following path parameters with your request:

Field Type Required Description
catalogId Integer Required Catalog ID
databaseName String Required Database name
tableName String Required Table name

Request example

The request example is as follows:

curl --location --request GET 'https://datacatalog.apigw.ntruss.com/api/v1/catalogs/4**/databases/default/tables/atmosphere_data/properties'  \
--header 'x-ncp-apigw-timestamp: {Timestamp}' \
--header 'x-ncp-iam-access-key: {Access Key}' \
--header 'x-ncp-apigw-signature-v2: {API Gateway Signature}'

Response

This section describes the response format.

Response body

The response body includes the following data:

Field Type Required Description
EXTERNAL String - External storage status of the table
  • TRUE | FALSE
    • TRUE: externally stored
    • FALSE: internally stored
compressionType String - Compressed file extension
  • Displayed if the scan target is a compressed file
clusterNo String - DB service number
  • Displayed if the scan target is database
connectionId String - Connection ID
  • Displayed if a connection exists
connectionName String - Connection name
  • Displayed if a connection exists
created_time String - Table creation date and time
  • Unix timestamp format
dataFormat String - Data format
dataType String - Data type
delimiter String - Delimiter
  • Displayed if data is a CSV file
inputFormat String - Data read format
isDirectory String - Whether the scan target is a directory
  • TRUE | FALSE
    • TRUE: directory
    • FALSE: non-directory
last_modified_time String - Update date and time
  • Unix timestamp format
metadata_location String - Metadata file path
  • Displayed for a Iceberg table
numFiles String - Total number of scanned files
  • Displayed if the scan target is a directory
objectstorageContentLength String - Object length (byte)
objectstorageContentType String - Object data type
objectstorageLastModified String - Object update date and time
  • Unix timestamp format
outputFormat String - Data output format
partitioningScheme String - Partitioning schema
  • Displayed if a partition is recognized in the scan target
scannerId String - Scanner ID
scannerName String - Scanner name
serializationLib String - Serialization and deserialization library
skip.header.line.count String - Number of excluded header lines
totalSize String - Total capacity of scanned data (byte)
  • Displayed if the scan target is a directory
transient_lastDdlTime String - Table DDL update date and time
  • Unix timestamp format
serde.escapeChar String - Data recognition removal character
  • Displayed if data is a CSV file
serde.quoteChar String - Data recognition symbol
  • Displayed if data is a CSV file
serde.separatorChar String - Schema determination delimiter
  • Displayed if data is a CSV file
Note

The property information displayed may vary depending on the table type.

For RDB data

The following describes the additional properties displayed for RDB (MySQL, MSSQL, PostgreSQL) data.

Field Type Required Description
{dbType}Collation String - Set string sorting.
{dbType}DataSize String - Data size
{dbType}IndexSize String - Index size
{dbType}Indexes String - Index structure
{dbType}Rows String - Number of rows (records)
{dbType}TableSize String - Total table size

For MongoDB data

The following describes the additional properties displayed for MongoDB data.

Field Type Required Description
mongodbAvgObjSize String - Collection average object size
mongodbFreeStorageSize String - Collection free storage capacity
mongodbIndexSize String - Collection index size
mongodbIndexes String - Collection index information
mongodbRowCount String - Number of collection rows (records)
mongodbSize String - Collection size
  • Uncompressed size
  • Excluding index size
mongodbStorageSize String - Storage size allocated to the collection
mongodbTotalSize String - Total disk capacity of the collection

Response status codes

For response status codes common to all Data Catalog APIs, see Data Catalog response status codes.

Response example

The response example is as follows:

{
  "EXTERNAL": "TRUE",
  "compressionType": "",
  "created_time": "1743125379",
  "dataFormat": "csv",
  "dataType": "file",
  "inputFormat": "org.apache.hadoop.mapred.TextInputFormat",
  "isDirectory": "TRUE",
  "objectstorageContentLength": "2783",
  "objectstorageContentType": "text/csv",
  "objectstorageLastModified": "1743125017",
  "outputFormat": "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
  "partitioningScheme": "hive",
  "scannerId": "9**",
  "scannerName": "scan_airQuality",
  "serializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde",
  "skip.header.line.count": "1",
  "transient_lastDdlTime": "1743125379",
  "serde.quoteChar": "\"",
  "serde.escapeChar": "\\",
  "serde.separatorChar": ","
}