title: How to partition based on the month and year in Azure SQL Data Warehouse
body: <p>I am going to use ADF to copy 5 billion rows to Azure SQL data warehouse. Azure SQL DWH will distribute the table into 60 distributions by default, But I want to add another 50 partitions based on the month and year as follow:</p>
  
  <pre><code>PARTITION ( DateP  RANGE RIGHT FOR VALUES   
        (  
          '2015-01-01', 2015-02-01', ......2018-01-01','2018-02-01','2018-03-01','2018-04-01','2018-5-01',.......
          ))
  </code></pre>
  
  <p>But, the column that I am using to partition the table includes date and time together : </p>
  
  <p><code>2015-01-01 00:30:00</code>
  Do you think my partitioning approach is correct?</p>