What's up with the different JOINS in Azure SQL and Azure Synapse?
HTML-код
- Опубликовано: 5 фев 2025
- Not sure what the different JOINs mean in Azure Synapse Analytics and Azure SQL Database? Patrick walks you through the different types to get you on the right path!
Joins (SQL Server)
docs.microsoft...
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#AzureSynapse #AzureSQL #GuyInACube
OVER clause, CROSS JOIN, other aggregations. Thanks for the steady, high quality content!
Great basic video introducing these. So yes to more. In the series, it would be good to conclude with how this related to the ETL in Power Query for best practices in getting that initial data. For example, when to get whole DB tables and use in built relationships vs constructing the data with queries performing joins.
This Is awesome! I would like to know more about this kind of stuff since it is inherently part of Data engineer / analyst stack
Would love to see some queries that show a combination of these, Where you may inner join one table and then left join another table based off that inner joined table. It's cool seeing the basics but what I have seen is sometimes you need to use a combination to get the data you need.
Awesome....please post some videos about aggregations
Thank you for T-SQL and Synapse videos. Could you make one Synapse pricing and licencing please?
I love this channel. I’m trying to find a bi course where you just don’t end up copying a RUclips channel but a place where you are set a project and then we all come back with our ideas. A community course and was wondering if there was anything like that? Thank you.
i like the validation with the outer join. thx!
Yes mate. Need some more stuff on join.
Nice animations Patrick, slick!
Thanks, this was helpful. I've never found a reason yet though to use RIGHT OUTER JOIN. I think you can just use a LEFT JOIN and re-order the tables in the query to replicate the RIGHT JOIN functionality, no?
i have connected the MySQL to Powerbi and try to apply the change that I have made in powerbi but it is giving me an error "The given key was not present in the dictionary". How to resolve this , please help
hi patrick, how do i filter based on the following time period: yesterday morning at 07:00am til today 06:59am?
More videos on aggregations and how to keep folding queries
I would love to see the semantic layer difference. Does Azure Synapse has a great semantic layer as Azure Analysis Services?
Semantic layers are still in AAS and Power BI, where the latter is integrated into synapse.
Hi any one guide how to create power bi data flow using snowflake data source without configuring gate way
Multi-Nested Queries!
Subqueries?
@@DanielWillen Yes agree, but not best practice if it's used as native query in power bi.
How are you running a Jupyter notebook for SQL queries?
He's using Azure Data Studio.
Hi Patrick, Great fan of knowledge on Power Bi....
I need ur help in one of my project....pls help..
I have a table with 1000 places and corresponding data, user wants to go on details page from this table in single click...
I have suggested, right click and drill through or select value and click drill through button....
Can we have a single click solution to drill through by just clicking on place name in table..... thanks in advance...
Aggregations yes.
Great