ServiceNow connection options - AWS Glue

ServiceNow connection options

The following are connection options for ServiceNow:

  • ENTITY_NAME(String) - (Required) Used for Read. The name of your object in ServiceNow.

  • API_VERSION(String) - (Required) Used for Read. ServiceNow Rest API version you want to use. For example: v1,v2,v3,v4.

  • SELECTED_FIELDS(List<String>) - Default: empty(SELECT *). Used for Read. Columns you want to select for the object.

  • FILTER_PREDICATE(String) - Default: empty. Used for Read. It should be in the Spark SQL format.

  • QUERY(String) - Default: empty. Used for Read. Full Spark SQL query.

  • PARTITION_FIELD(String) - Used for Read. Field to be used to partition query.

  • LOWER_BOUND(String)- Used for Read. An inclusive lower bound value of the chosen partition field. For example: 2024-01-30T06:47:51.000Z.

  • UPPER_BOUND(String) - Used for Read. An exclusive upper bound value of the chosen partition field. For example: 2024-06-30T06:47:51.000Z.

  • NUM_PARTITIONS(Integer) - Default: 1. Used for Read. Number of partitions for read. For example: 10.

  • INSTANCE_URL(String) - (Required) A valid ServiceNow instance URL with format https://<instance-name>.service-now.com.