Content Comparison

...

1. Unity Catalog must be enabled on your Databricks cluster.

2. To create a storage credential for connecting to AWS S3, refer to Databricks documentation.

3. Fetch the S3 path till the parent directory of your respective storage account.

4. On the Unity Catalog page, go to external locations and create a new external location by providing an external location name, newly created Storage credential, and fetched s3 URL.
   The URL format must be in  s3://bucket name/<path> For example s3://kyvos-output-56555/user/engine_work

5. Test the newly created external location by clicking the 'Test connection' button. This will validate the connection with the external location path. Through the permissions tab, assign your user the CREATE EXTERNAL TABLE and WRITE FILES role.

6. Go to semantic model Advanced Properties, and add the following properties:

   1. kyvos.sqlwarehouse.catalog: Enter the temp catalog name to create a parquet table.

   2. kyvos.sqlwarehouse.tempdb: Enter the temp database name to create a parquet table.

7. You must have 'create table and Use schema' permissions on the temp catalog.

...