Page Comparison

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

...

• Create database kyvosrepo_$clustername if the KYVOS_QUERY_ANALYZER_DATABASE is not present in the olapengine.properties file.

• Create database $value of KYVOS_QUERY_ANALYZER_DATABASE if KYVOS_QUERY_ANALYZER_DATABASE is present in the olapengine.properties file.

• Ensure that the Sanity_table Sanitytable table must exist when you are creating a database. 
  NOTE: If AWS Glue is enabled, the Sanity_Sanitytable tabletableis not created for AWS cluster deployment. Similarly, if Dataproc Metastore is enabled, this table is not created for GCP cluster deployment. 

Prerequisites for no-Spark deployments

Anchor
prereqforno-spark prereqforno-spark

Before executing sanity suite, you must perform the following steps.

• MSSQL

• Snowflake Warehouse

• Azure SQL Warehouse

For MSSQL

Anchor
MYSQL MYSQL

1. Create a database “SANITYSUITE”;

2. Create a schema “DBO”.

3. Create the table using the following syntax:

   Code Block

   CREATE DATABASE sanitysuite; CREATE TABLE dbo.sanity_table ( product_id INT, product_category VARCHAR(255), manufacturer VARCHAR(255), product_type VARCHAR(255), product_name VARCHAR(255), order_priority VARCHAR(255), sale_amount FLOAT, order_quantity INT, discount FLOAT, continent VARCHAR(255), country VARCHAR(255), region VARCHAR(255), state VARCHAR(255), city VARCHAR(255), profit FLOAT, customer_name VARCHAR(255), customer_segment VARCHAR(255), shipping_cost FLOAT, date_1 VARCHAR(255), quarter VARCHAR(255), month VARCHAR(255), week VARCHAR(255), day VARCHAR(255));

4. Insert the following data in the sanity table you have created in Step 1.

   Code Block
   BULK INSERT databaseName.tableName FROM 'pathOfCsvFile' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' );

• MSSQL

• Snowflake Warehouse

• Azure SQL Warehouse

...

To create MSSQL Warehouse connection for sanity suite, see the Working with MSSQL warehouse connection section.

...