Servicenow ingest data to our data lake

[MoeBacht]

Hello, 

We want to ingest servicenow data to our data lake to do further analytics and advanced dashboards

What's the best way to do this integration ? 

How can I have access and visualize Servicenow data model ?

Thanks

[Dr Atul G- LNG]

Hi @MoeBacht 

Might be helpful

https://www.perspectium.com/blog/replicating-servicenow-data-in-a-data-lake-a-guide/

[MoeBacht]

Hello, 

Is there a way to find the list of all servicenow tables, their structure and relationship ? Physical model

Thanks

[Dr Atul G- LNG]

Hi @MoeBacht 

No mate, it's not easy to get all table relationships in one place. You can open the required tables and then use the Schema Map to view their relationships.

Here’s how you can do it:

1. Go to the sys_db_object table.

2. Open the table you need.

3. Scroll down to the Related Links section.

4. Click on Table Schema Map—you’ll find the relationships there.