Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wednesday
Hi @Lu_Wang_ENB_DBX - Apologies I forgot to mentioned that I have managed to solve this.
Issue:
I was creating service (MCP Service) under schema. This also creating MCP connection where "
is_mcp_connection=true". This connection was not visible in the Genie One even though the is MCP connection true. On the other hand if you create the connection using UI, there is no such explicit filed which allow you to set is_mcp_connection=true. This is where i was struggling.
Solution:
I realised that the connection need to sit in the metastore level. So I have created a connection using the SQL syntax filling all the required attributes along with "is_mcp_connection=true". This resolved the issue and can now see the connection in Genie One.
Also during this exercise i have also seen that genie code has limited feature in uksouth region. So I have moved to westeurope region and is working fine.
Many thanks for your help.
Solution:
I realised that the connection need to sit in the metastore level. So I have created a connection using the SQL syntax filling all the required attributes along with "is_mcp_connection=true". This resolved the issue and can now see the connection in Genie One.
Also during this exercise i have also seen that genie code has limited feature in uksouth region. So I have moved to westeurope region and is working fine.
Many thanks for your help.
