synapse best practices
Familiarize yourself with your data before your write a single line of code by studying the metadata to make sure that a column does contain the data you expect.
You should check for distribution, data types, number of columns, index, statistics, and number of records in a table. This will give you an idea about how you want to query the table in a more optimized way.
