# Viewing crawler results and details
<a name="console-crawlers-details"></a>

 After the crawler runs successfully, it creates table definitions in the Data Catalog. Choose **Tables** in the navigation pane to see the tables that were created by your crawler in the database that you specified. 

 You can view information related to the crawler itself as follows:
+ The **Crawlers** page on the AWS Glue console displays the following properties for a crawler:    
[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/glue/latest/dg/console-crawlers-details.html)
+  To view the history of a crawler, choose **Crawlers** in the navigation pane to see the crawlers you created. Choose a crawler from the list of available crawlers. You can view the crawler properties and view the crawler history in the **Crawler runs** tab. 

   The Crawler runs tab displays information about each time the crawler ran, including ** Start time (UTC),** **End time (UTC)**, **Duration**, **Status**, **DPU hours**, and **Table changes**. 

  The Crawler runs tab displays only the crawls that have occurred since the launch date of the crawler history feature, and only retains up to 12 months of crawls. Older crawls will not be returned.
+ To see additional information, choose a tab in the crawler details page. Each tab will display information related to the crawler. 
  +  **Schedule**: Any schedules created for the crawler will be visible here. 
  +  **Data sources**: All data sources scanned by the crawler will be visible here. 
  +  **Classifiers**: All classifiers assigned to the crawler will be visible here. 
  +  **Tags**: Any tags created and assigned to an AWS resource will be visible here. 

# Parameters set on Data Catalog tables by crawler
<a name="table-properties-crawler"></a>

 These table properties are set by AWS Glue crawlers. We expect users to consume the `classification` and `compressionType` properties. Other properties, including table size estimates, are used for internal calculations, and we do not guarantee their accuracy or applicability to customer use cases. Changing these parameters may alter the behavior of the crawler, we do not support this workflow. 


| Property key | Property value | 
| --- | --- | 
| UPDATED\$1BY\$1CRAWLER | Name of crawler performing update. | 
| connectionName | The name of the connection in the Data Catalog for the crawler used to connect the to the data store. | 
| recordCount | Estimate count of records in table, based on file sizes and headers. | 
| skip.header.line.count | Rows skipped to skip header. Set on tables classified as CSV. | 
| CrawlerSchemaSerializerVersion | For internal use | 
| classification | Format of data, inferred by crawler. For more information about data formats supported by AWS Glue crawlers see [Built-in classifiers](add-classifier.md#classifier-built-in). | 
| CrawlerSchemaDeserializerVersion | For internal use | 
| sizeKey | Combined size of files in table crawled. | 
| averageRecordSize | Average size of row in table, in bytes. | 
| compressionType | Type of compression used on data in the table. For more information about compression types supported by AWS Glue crawlers see [Built-in classifiers](add-classifier.md#classifier-built-in). | 
| typeOfData | `file`, `table` or `view`. | 
| objectCount | Number of objects under Amazon S3 path for table. | 

 These additional table properties are set by AWS Glue crawlers for Snowflake data stores. 


| Property key | Property value | 
| --- | --- | 
| aws:RawTableLastAltered | Records the last altered timestamp of the Snowflake table. | 
| ViewOriginalText | View SQL statement. | 
| ViewExpandedText | View SQL statement encoded in Base64 format. | 
| ExternalTable:S3Location | Amazon S3 location of the Snowflake external table. | 
| ExternalTable:FileFormat | Amazon S3 file format of the Snowflake external table. | 

 These additional table properties are set by AWS Glue crawlers for JDBC-type data stores such as Amazon Redshift, Microsoft SQL Server, MySQL, PostgreSQL, and Oracle. 


| Property key | Property value | 
| --- | --- | 
| aws:RawType | When a crawler store the data in the Data Catalog it translates the datatypes to Hive-compatible types, which many times causes the information on the native datatype to be lost. The crawler outputs the `aws:RawType` parameter to provide the native-level datatype. | 
| aws:RawColumnComment | If a comment is associated with a column in the database, the crawler outputs the corresponding comment in the catalog table. The comment string is truncated to 255 bytes. Comments are not supported for Microsoft SQL Server.  | 
| aws:RawTableComment | If a comment is associated with a table in the database, the crawler outputs corresponding comment in the catalog table. The comment string is truncated to 255 bytes. Comments are not supported for Microsoft SQL Server. |