Snowflake Connector for ServiceNow® V2 release notes¶

Behavior changes¶

Not applicable.

New features¶

• max_sys_created_on argument in CHECK_ROW_COUNT procedure now defaults to NULL.

Bug fixes¶

• Don’t start healthcheck reporting if the configuration hasn’t successfully completed.

• Fix SHOW_REFERENCES_OF_TABLE to include self-references of a given table in returned value.

• Fix CREATE_VIEW_WITH_DISPLAY_VALUES to handle situation when table references itself.

Behavior changes¶

• External function making API calls to ServiceNow® are replaced with external access.

• Signatures and behavior of many procedures changed. Division of responsibility can be checked in the below table:

Prior procedure	New procedure
CONFIGURE_CONNECTOR	Several specialized procedures CONFIGURE_*.
CONFIGURE_WAREHOUSE	UPDATE_WAREHOUSE
STOP_CONNECTOR	PAUSE_CONNECTOR
START_CONNECTOR	Several procedures to install the app when using worksheets.
PREFILL_CONFIG_TABLE	GET_AVAILABLE_TABLES
ENABLE_TABLE_WITH_COLUMNS	ENABLE_TABLE
ENABLE_TABLES(VARCHAR, BOOLEAN)	ENABLE_TABLES(ARRAY), DISABLE_TABLES(ARRAY)
TEST_SN_CONNECTION	TEST_CONNECTION
CHECK_SN_ROW_COUNT	CHECK_ROW_COUNT
GET_STATUS
GET_CONNECTION_STATUS
GET_VERSION
RUN_UPGRADE

• Procedures return an object with response_code property. The procedure result with an optional error reason is displayed directly in the response.

• Signatures and behavior of several views changed. Division of responsibility can be checked in the below table:

  Prior view	New view
  ENABLED_TABLES	CONFIGURED_TABLES, TABLES_STATE
  CONNECTOR_RUNS_STATE	Included in GET_TROUBLESHOOTING_DATA procedure.
  CONNECTOR_STATS	AGGREGATED_CONNECTOR_STATS
  	SYNC_STATUS

New features¶

Not applicable.

Bug fixes¶

Not applicable.