Snowflake Connector for ServiceNow® V2 release notes

This topic provides release notes for the Snowflake Connector for ServiceNow® V2. For additional information, see Snowflake Connector for ServiceNow.

Version 5.3.0 (May 17th, 2024)

Behavior changes

Not applicable.

New features

Not applicable.

Bug fixes

  • Fix handling the null value of the journal_table property in the object passed to the FINALIZE_CONNECTOR_CONFIGURATION procedure. The journal_table parameter can now also be skipped.

Version 5.2.0 (May 10th, 2024)

Behavior changes

Not applicable.

New features

  • Add optional table_name and sys_id arguments to FINALIZE_CONNECTOR_CONFIGURATION to help in journal table validation.

Bug fixes

  • Improve URL validation in SET_CONNECTION_CONFIGURATION to support custom ServiceNow® domains.

Version 5.1.0 (April 29th, 2024)

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.

Version 5.0.0 (April 23rd, 2024)

Initial release with version 5.0.0.

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.