Using Load data in database views

MattCoscos
Tera Contributor

Hi,

 

Have anyone use load data in database views. Is the record inserted only on database views? or is it also inserted on tables that are used for the database view?

 

Thanks

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@MattCoscos 

ideally load data won't work as it only works for tables which are extending Import Set Row table i.e. staging tables

You should not be able to select database view tables there

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@MattCoscos 

ideally load data won't work as it only works for tables which are extending Import Set Row table i.e. staging tables

You should not be able to select database view tables there

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader