Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Loading data without using the sys_id in Service now connector

Answered
Meghana Bale User

Can you please support loading the data without using the sys_id in the ServiceNow connector

Please sign in to leave a comment.

Comments

9 comments

Date Votes
  • Official comment
    Frank Fivetranner
    • Edited

    Hi Matthew, 

    Thanks for sharing that screenshot I'm adding this request to our backlog for our engineering team to investigate. I will follow up further on this request. 

    Frank

  • Shivaprasad Mogili Fivetranner

    Hi Meghana,

    Could you share more details about your request to load data without using the sys_id in the ServiceNow connector? Understanding the specific problem you're facing will help us evaluate the potential changes and assess whether alternative approaches might be available.

    Thanks,
    Shiva

  • Matthew Layman User

    There are some tables in performance analytics such as I reported in the original case on this that have a primary key called ID rather than sys_id. We need to ingest these tables. Example table: pa_scores_l1

  • Frank Fivetranner

    Hi Mathew, 

    Is the issue that you are not receiving the correct ID in the table at all or that the ID is there, but it's not being assigned as a primary key? 

    Thanks, 

    Frank

  • Matthew Layman User

    Please see screen shot:

  • Matthew Layman User

    Hi Frank - could I get an update on the investigation?

  • Frank Fivetranner

    Hi Matthew, 

    We are still looking into this. Are there other tables that have this issue? If there is no sys_id then will the primary key always be "ID"? If you have more information on why this specific table does not have sys_id that would be helpful too. 

    Frank

  • Matthew Layman User

    Hi Shiva,  The ServiceNow Performance Analytics tables are required to be ingested into our warehouse.  We can't ingest them at the moment because ServiceNow sets ID as the Primary Key rather than sys_id.  There is no sys_id column on the table here.

  • Matthew Layman User

    Hi Frank, Yes the ID is a Primary Key.  I think all pa_ tables are like this.  My guess is that they acquired the data model and didn't re-engineer it - but no idea.  Its all vanilla ServiceNow.