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.14 (November 18, 2024)

Behavior changes

  • Event sharing is now mandatory for new installations.

New features

  • You can now set a specified table page size with the RESET_PAGE_SIZE procedure instead of using the default connector’s value.

  • If the connector’s default page size was set to an invalid value, the connector will use the recommended value of 10,000.

Bug fixes

  • Ingestion fails when a worker task reaches API timeout when discovering the initial table page size.

Version 5.13 (October 29, 2024)

Behavior changes

Not applicable

New features

  • Add timeout on establishing the http connection.

Bug fixes

Not applicable

Version 5.12 (October 16, 2024)

Behavior changes

Not applicable

New features

Not applicable

Bug fixes

  • Incremental updates no longer fail if Snowflake doesn’t receive the timestamp of the newest record on the ingested table.

Version 5.11.1 (October 8, 2024)

Behavior changes

Not applicable

New features

Not applicable

Bug fixes

  • Incremental updates no longer fail when the event log table is empty.

  • Incremental ingestion no longer fails when a fetched batch is empty due to having out-of-date rows during record updates from the source.

Version 5.11.0 (October 7, 2024)

Behavior changes

Modified the ServiceNow API request sorting rules applied during incremental updates to eliminate data loss while reading data from multiple read replicas.

New features

Not applicable

Bug fixes

Page size is no longer reduced when the ServiceNow instance is not reachable.

Version 5.10.1 (September 6, 2024)

Behavior changes

Not applicable

New features

Not applicable

Bug fixes

  • Fixed configuration validation in the UPDATE_CONNECTION_CONFIGURATION procedure.

Version 5.10.0 (August 30, 2024)

Behavior changes

  • A request for the most recent timestamp is added at the beginning of updates and deletes.

New features

  • The UPDATE_CONNECTION_CONFIGURATION procedure is added. This procedure allows to change External Access Integration and Secret objects used by the connector.

  • User Agent header in connector HTTP requests is now set to snowflake-connector-for-service-now.

Bug fixes

  • Handle HTTP Client timeout errors gracefully.

    Reduce page size on such an error.

  • ServiceNow® and Snowflake time differences no longer cause data to be lost.

Version 5.9.1 (August 14, 2024)

Behavior changes

Not applicable.

New features

Not applicable.

Bug fixes

  • Migration script fix for certain users.

Version 5.9.0 (August 8, 2024)

Behavior changes

Not applicable.

New features

Not applicable.

Bug fixes

  • Fix RELOAD_TABLE procedure when both row_filter and data_range_start_time are set. Previously row filtering sync states were not cleaned up correctly.

  • Improve error handling in the data ingestion process when the connector is not able to overcome errors related to authentication. In such cases, the connector should now be able to detect the error earlier and stop the ingestion process.

Version 5.8.0 (July 23rd 2024)

Behavior changes

Not applicable.

New features

  • The row_filter field in ENABLE_TABLE procedure now accepts arbitrary number of whitespace characters in filtering expression rather than allowing only single space between expression elements.

    For more information see Enabling a single table using custom configuration.

Bug fixes

  • During table reload row filter and column filtering now taken into account.

  • Row filter now works as expected for tables without a sys_updated_on column

Version 5.7.0 (July 11, 2024)

Behavior changes

Not applicable.

New features

Procedures CHECK_ROW_COUNT, ENABLE_TABLE (without custom configuration parameters) and SHOW_REFERENCES_OF_TABLE can now be called in a user-owned task.

Bug fixes

Not applicable.

Version 5.6.0 (July 5th, 2024)

Behavior changes

Not applicable.

New features

Row filtering is now available. Row filtering supports the filtering of ingested table rows based on conditions evaluated against table columns. The row filtering condition is set using the ENABLE_TABLE procedure.

For more information see Enabling a single table using custom configuration in Setting Up data ingestion for your ServiceNow® data.

Bug fixes

Improve performance of the migration script from prior version.

Version 5.5.1 (June 28th, 2024)

Behavior changes

Not applicable.

New features

Not applicable

Bug fixes

Improve performance of the migration script from prior version.

Version 5.5.0 (June 24th, 2024)

Behavior changes

Not applicable.

New features

Add a default way to obtain the schema of a table when starting its ingestion. This should help in a scenario where the connector couldn’t start to ingest a table because of ACLs met on the first ingested row.

Bug fixes

  • Fix RUN_HEALTHCHECK as it sometimes could fail to send the connector’s status in a specific scenario.

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.