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));

...

1. 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' );

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

...

1. In the Stages tab upload, the sanity data from the file.

2. Download the sanity data file.

3. Click the Load Data button to upload the data file.

4. From the File format list, select CSV.

5. On header, select skip first line.

6. Select Field delimiter as Vertical Bar.

7. Load the data by clicking the Load Button.

   

Step 3: To create Snowflake Warehouse connection for sanity suite, see the Working with Snowflake warehouse connection section.

Azure SQL Warehouse

Anchor
AzureSQL AzureSQL

Step 1: Create the following Database and table.

...

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

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

...