ADDY5Ybp

1CREATE DATABASE IF NOT EXISTS @db_name;
2USE DATABASE @db_name;
3
4CREATE TABLE IF NOT EXISTS @db_name.@ref.@table_name
5(
6    [MS-DR] string,
7    [Final_Post] string,
8    [Final_Special] string,     
9    [Weights] float?,
10    [Geometric_Mean] float?,
11    [Arithmetic_Mean] float?,
12    [Year] string,
13    [Version] string,
14    [Inserted_Ts] DateTime,
15        INDEX CWIDX
16        CLUSTERED([MS-DRG] ASC)
17        DISTRIBUTED BY HASH([MS-DR])
18);
19	
20"parameters": {
21          "db_name": "db_ob_main",
22          "table_name": "cost_wght_tbl"
23      }