title: Dynamic Partition Value SQL Server Azure Synapse
body: <p>How can I set the Table with dynamic partition ? is it possible to do it on Azure Synapse?</p>
  <p>This is my script</p>
  <pre><code>CREATE TABLE dashboard_table WITH (
      DISTRIBUTION = HASH(product_id), 
      PARTITION (partition_key RANGE RIGHT FOR 
          VALUES (20200101,20200102,20200103,20200104,20200105,20200106) AS (
              SELECT *
              FROM table_x
          )
  </code></pre>
  <p>Because when I try to create a partition by this example script it doesnt work on synapse</p>
  <pre><code>CREATE PARTITION FUNCTION myRangePF1 (int) AS RANGE LEFT FOR VALUES (1, 100, 1000);
  </code></pre>