• Data Warehouse Service

  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Tutorial: Tuning Table Design
  5. Appendix: Table Creation Syntax
  6. Usage


This section provides SQL test statements used in this tutorial. You are advised to copy the SQL statements in each section and save them as an .sql file. For example, create a file named create_table_fir.sql and paste the SQL statements in section Creating an Initial Table to the file. Executing the file on an SQL client tool is efficient, and the total elapsed time of test cases is easy to calculate. Execute the .sql file using gsql as follows:

gsql -d database_name -h dws_ip -U username -p port_number -W password -f XXX.sql

Replace the italic parts in the example with actual values in DWS. For example:

gsql -d postgres -h -U dbadmin -p 8000 -W Bigdata@123 -f create_table_fir.sql