Cloud JDBC Interface - Schema filter

[Talbarkan]

Hi,

How do I setup schema filter in jdbc (Oracle) cloud interface?

[eyalk2]

What is the purpose of the filter? I remind you that the filter at .Net is just optimization for the Studio, and not related to Fabric actions.

[Talbarkan]

I need the same optimization... I have DBs with many schemas that i don’t need and it takes a very long time to load/run queries etc.

Regards,

@.***

Tal Barkan (+972) 050-2146510

From: eyalk2 @.> Sent: Tuesday, 7 May 2024 16:52 To: k2view-academy/K2View-Academy @.> Cc: tal barkan @.>; Author @.> Subject: Re: [k2view-academy/K2View-Academy] Cloud JDBC Interface - Schema filter (Issue #1062)

What is the purpose of the filter? I remind you that the filter at .Net is just optimization for the Studio, and not related to Fabric actions.

— Reply to this email directly, view it on GitHubhttps://github.com/k2view-academy/K2View-Academy/issues/1062#issuecomment-2098461707, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BIKRDC3K6HOU3PWXK34MEGDZBDL77AVCNFSM6AAAAABHKYNEKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJYGQ3DCNZQG4. You are receiving this because you authored the thread.Message ID: @.**@.>>

[eyalk2]

Showing only specific schema at Studio does not affect on queries, which is done by Fabric. Works differently than in .Net, and for this there is no point to filter schemas

[Talbarkan]

So you are saying that i need to include the schema name in every query there might be the same table name in multiple schemas...

Regards,

@.***

Tal Barkan (+972) 050-2146510

From: eyalk2 @.> Sent: Tuesday, 7 May 2024 17:43 To: k2view-academy/K2View-Academy @.> Cc: tal barkan @.>; Author @.> Subject: Re: [k2view-academy/K2View-Academy] Cloud JDBC Interface - Schema filter (Issue #1062)

Showing only specific schema at Studio does not affect on queries, which is done by Fabric. Works differently than in .Net, and for this there is no point to filter schemas

— Reply to this email directly, view it on GitHubhttps://github.com/k2view-academy/K2View-Academy/issues/1062#issuecomment-2098573214, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BIKRDC55MSUCN5KFEXPLRVDZBDR53AVCNFSM6AAAAABHKYNEKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJYGU3TGMRRGQ. You are receiving this because you authored the thread.Message ID: @.**@.>>

[eyalk2]

yes. like you need to do anyway. meaning for runtime

---

From: Talbarkan @.> Sent: Tuesday, May 7, 2024 6:04:54 PM To: k2view-academy/K2View-Academy @.> Cc: Eyal Orbach @.>; Assign @.> Subject: Re: [k2view-academy/K2View-Academy] Cloud JDBC Interface - Schema filter (Issue #1062)

So you are saying that i need to include the schema name in every query there might be the same table name in multiple schemas...

Regards,

@.***

Tal Barkan (+972) 050-2146510

From: eyalk2 @.> Sent: Tuesday, 7 May 2024 17:43 To: k2view-academy/K2View-Academy @.> Cc: tal barkan @.>; Author @.> Subject: Re: [k2view-academy/K2View-Academy] Cloud JDBC Interface - Schema filter (Issue #1062)

Showing only specific schema at Studio does not affect on queries, which is done by Fabric. Works differently than in .Net, and for this there is no point to filter schemas

— Reply to this email directly, view it on GitHubhttps://github.com/k2view-academy/K2View-Academy/issues/1062#issuecomment-2098573214, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BIKRDC55MSUCN5KFEXPLRVDZBDR53AVCNFSM6AAAAABHKYNEKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJYGU3TGMRRGQ. You are receiving this because you authored the thread.Message ID: @.**@.>>

— Reply to this email directly, view it on GitHubhttps://github.com/k2view-academy/K2View-Academy/issues/1062#issuecomment-2098637489, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARWMWJA7ZGEDJMMABASODPDZBDURNAVCNFSM6AAAAABHKYNEKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJYGYZTONBYHE. You are receiving this because you were assigned.Message ID: @.***>

• CAUTION: This email originated from outside of K2view *