Welcome back to another episode of the Synapse Espresso!
In this video, Stijn and Filip will help us understand partitioning and show us how to reduce costs and improve performance from partitioning the data.
Query folders and multiple files: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files
Use file metadata in serverless SQL pool queries: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files
Best practices / use filename and filepath functions to target specific partitions: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool#use-filename-and-filepath-functions-to-target-specific-partitions
Best practices / prepare files for querying: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool#prepare-files-for-querying
Filip Popovic - Senior Program Manager
https://www.linkedin.com/in/popovicfilip/
Stijn Wynants - Fasttrack Engineer
https://www.linkedin.com/in/stijn-wynants-ba528660/
https://sql-stijn.com/
https://twitter.com/SQLStijn
#azuresynapse #serverless #sql #analytics #partitioning