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 Sanitytable table must exist when you are creating a database. 
  NOTE: If AWS Glue is enabled, the Sanitytable tableis 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' );

...

...

Snowflake Warehouse

...

Azure SQL Warehouse

...

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

...

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

To create Snowflake Azure SQL Warehouse connection for sanity suite, see the Working with Azure SQL warehouse connection section.

...