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.4.0 (June 10th, 2024)

Behavior changes

Not applicable.

New features

  • Change endpoint for fetching schema of the table. From version 5.4.0 and later, the ADMIN role in ServiceNow® is no longer required to use CREATE_VIEW_WITH_DISPLAY_VALUES, SHOW_REFERENCES_OF_TABLE and ENABLE_TABLE (when using column filtering) procedures.

Bug fixes

  • From version 5.4.0 and later, new event log table DELETE events include the RAW column, which is set to a value from the newest update event instead of the first insert event. Previously existing event log table events remain unchanged.

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.