sabir-akhadov-localstack opened a new pull request, #2388:
URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2388

   Snowflake supports `CREATE WAREHOUSE` to provision a virtual warehouse, and 
`DROP WAREHOUSE` to remove one. Neither parsed before this change.
   
   ```sql
   CREATE OR REPLACE WAREHOUSE my_wh WITH WAREHOUSE_SIZE = 'XSMALL' 
AUTO_SUSPEND = 60;
   DROP WAREHOUSE my_wh;
   ```
   
   This adds `Statement::CreateWarehouse` and `ObjectType::Warehouse`. The 
warehouse properties and parameters are captured as `KeyValueOptions` (the same 
representation used for `CREATE FILE FORMAT` and friends), so the statement 
round-trips losslessly rather than discarding everything after the name. The 
optional leading `WITH` and the spaces around `=` are normalized away on 
display.
   
   See the [Snowflake `CREATE WAREHOUSE` 
docs](https://docs.snowflake.com/en/sql-reference/sql/create-warehouse).
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to