Creates or replaces a DATALAKE object and grants the creator the following privileges on the object:
- SELECT privilege WITH GRANT OPTION
- SHOW privilege WITH GRANT OPTION
To use CREATE DATALAKE:
- You must have the CREATE SERVER privilege on the TD_SERVER_DB database.
- Authorization objects for the catalog and storage to associate with the DATALAKE object must exist.
Create authorization objects with the CREATE AUTHORIZATION statement (see CREATE AUTHORIZATION and REPLACE AUTHORIZATION).
- CREATE DATALAKE and REPLACE DATALAKE Syntax
- CREATE DATALAKE and REPLACE DATALAKE Syntax Elements
- Example: Create Authorizations and DATALAKE Object
- Example: Replace DATALAKE Object
- Example: Create DATALAKE Object with HIVE Catalog
- Example: Create DATALAKE Object with GLUE Catalog
- Example: Create DATALAKE Object with UNITY Catalog
- Example: Create DATALAKE Object in Delta Lake Format
- Example: Create DATALAKE object for Glue Catalog with catalog_endpoint and storage_endpoint
- Example: Create DATALAKE object for Hive Catalog with storage_endpoint clause