how to get a select of tables in lookupactivity in pipeline in msfabric datafactory from postgresql

[shiva_fabric]

Hi Team,

Im trying to get a select  list of tables from postgresql from lookupactivity in pipeline from datafactory option . what process should i follow to get the tables.

below are the list of tables.

select * from information_schema.tables where table_schema = 'public' and table_type ='BASE TABLE' and table_name in('workorder',
'modedefinition',
'aaauser',
'departmentdefinition',
'workorderstates',
'categorydefinition',
'sduser',
'workorder_queue',
'queuedefinition',
'statusdefinition',
'leveldefinition',
'prioritydefinition',
'ci',
'requestresolver')

[Anonymous]

Hi @shiva_fabric ,

Thanks for using Fabric Community.
In Fabric Data Factory we have look up activity to connect to Postgressql.

Hope this is helpful. Please let me know incase of further queries.

[Anonymous]

Hello @shiva_fabric ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[Anonymous]

Hi @shiva_fabric ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help.

Thank you