Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Qlik Sense Analytics: Synonym Objects are not visible when previewing in the Data Load Editor section

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Caterina_Fruci
Support
Support

Qlik Sense Analytics: Synonym Objects are not visible when previewing in the Data Load Editor section

Last Update:

Jan 5, 2024 11:24:37 AM

Updated By:

Frank_S

Created date:

Aug 24, 2023 4:02:40 AM

Synonym Objects available in the database are not accessible when previewing in Qlik Sense Analytics.

Synonym_Name  : PERSONS_K from an Oracle DatabaseSynonym_Name  : PERSONS_K from an Oracle Database

In Qlik Sense, Synonym objects are not visible when previewing them in the Data Load Editor. 

Object preview in Qlik ( Tables  & Views )Object preview in Qlik ( Tables  & Views )
 

Resolution

Synonym objects cannot be previewed, but they can be queried and accessed by Qlik Sense in the data load editor script as illustrated in the following screenshot. 

Querying Synonym objects from the Data Load Editor ScriptQuerying Synonym objects from the Data Load Editor Script

 

Environment:

Qlik Cloud 
Qlik Sense Enterprise on Windows 

 

Related Information:

https://community.snowflake.com/s/article/Dynamic-Table-is-not-viewable-while-using-Snowflake-ODBC-D...

https://docs.snowflake.com/en/user-guide/dynamic-tables-about#an-example

Labels (1)
Version history
Last update:
‎2024-01-05 11:24 AM
Updated by: