k2v-academy / K2View-Academy

Other
0 stars 0 forks source link

Cloud JDBC Interface - Schema filter #1062

Closed vD8s9lgLln0ANhxPXPl6e2EZOikxgEf4Ef9vSGO closed 6 months ago

vD8s9lgLln0ANhxPXPl6e2EZOikxgEf4Ef9vSGO commented 6 months ago

Hi,

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

157aq9Ud3GJlkIVikTS1SzhhiP3x1Vrj0jAjZ3X commented 6 months ago

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.

vD8s9lgLln0ANhxPXPl6e2EZOikxgEf4Ef9vSGO commented 6 months ago

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: @.**@.>>

157aq9Ud3GJlkIVikTS1SzhhiP3x1Vrj0jAjZ3X commented 6 months ago

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

vD8s9lgLln0ANhxPXPl6e2EZOikxgEf4Ef9vSGO commented 6 months ago

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: @.**@.>>

157aq9Ud3GJlkIVikTS1SzhhiP3x1Vrj0jAjZ3X commented 6 months ago

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: @.***>