Can we write custom sql in virtual connection. Once virtual connection is created and we access it from desktop , I dont see any place to write custom sql
Unfortunately there is no option to write custom SQL with data source connecting to virtual connections. You might need to create a seperate object in virtual connection or create a view in database.
Hi Gurpreet, thanks for sharing this. It was really helpful. I have a follow up question: Let' say I have a 1. Actual sales data (how much sales did a seller achieve) 2. Sales Target data (how much sales was the seller targeting to achieve) 3. Seller attributes (seller name, region etc.). With these data sets I need to combine seller name, seller target sales and seller actual sales and ensure that seller can only see their own data. How can I do achieve this tableau virtual connection on Tableau Server Version: 2024.2.0? I'm basically trying to understand how can I join two tables (Actual sales data, Sales Target data) and apply rls (using Seller attributes data) simultaneously. Thanks again!
Thats a great question. Once you have applied row level security on the primary fact table and then join it with secondary table, it will only retrieve related rows from secondary table. Example: Table one is sales with row level security applied on Region (Central) Table two is returned orders and is joined with Table one on Order ID field.. Once the join is created in the workbook then it will only show all the sales made in Central region and corresponding returned items. Hope that helps.. Please feel free to reach out if you need more info.
That's a great question. Virtual connections are only available if you have Data management Add on. Please check with your tableau Admin in your company if they can get Data management add on.
Can we write custom sql in virtual connection. Once virtual connection is created and we access it from desktop , I dont see any place to write custom sql
Unfortunately there is no option to write custom SQL with data source connecting to virtual connections. You might need to create a seperate object in virtual connection or create a view in database.
Hi Gurpreet, thanks for sharing this. It was really helpful.
I have a follow up question: Let' say I have a
1. Actual sales data (how much sales did a seller achieve)
2. Sales Target data (how much sales was the seller targeting to achieve)
3. Seller attributes (seller name, region etc.).
With these data sets I need to combine seller name, seller target sales and seller actual sales and ensure that seller can only see their own data. How can I do achieve this tableau virtual connection on Tableau Server Version: 2024.2.0?
I'm basically trying to understand how can I join two tables (Actual sales data, Sales Target data) and apply rls (using Seller attributes data) simultaneously.
Thanks again!
Thats a great question. Once you have applied row level security on the primary fact table and then join it with secondary table, it will only retrieve related rows from secondary table.
Example: Table one is sales with row level security applied on Region (Central)
Table two is returned orders and is joined with Table one on Order ID field..
Once the join is created in the workbook then it will only show all the sales made in Central region and corresponding returned items.
Hope that helps..
Please feel free to reach out if you need more info.
I dont see option to create virtual connection in my companys cloud server
That's a great question. Virtual connections are only available if you have Data management Add on. Please check with your tableau Admin in your company if they can get Data management add on.
@@DataVizCanvas okay.Thanks for the reply.