SudhenduP

• #739
• https://github.com/octo-org/octo-repo/issues/740
• Add delight to the experience when all tasks are complete 🎉

SudhenduP

fig = px.line_3d(
        filtered_df1,
        x="X_VALUE",
        y="Y_VALUE",
        z="TVD",
        template="plotly_dark",
    )
    fig.update_layout(width=800, 
              height=800,
              autosize=False,

SudhenduP

session = get_active_session()
get_well_direction_df = session.table("WELL_ST.SUMMARY.WELL_DIRECTION").to_pandas()

SudhenduP

import pandas as pd
import streamlit as st
from snowflake.snowpark.context import get_active_session
import plotly.express as px

SudhenduP

#,Checklist,Detail,More Information
1,Have you done the initial analysis of where Snowflake fits?,"It is essential to understand where Snowflake fits for your requirement. True that Snowflake is a cloud data warehouse, but that is just one offering of Snowflake.",Why Snowflake Data Cloud | Snowflake Data Cloud
2,Have you listed down all the possible use-cases (current and future),Use-cases are your industry/department specific goals. Snowflake support a plethora of use-cases and it is worth checking if there is already a solution created for your use-cases,Industry Solutions | Snowflake
3,What different workloads do you plan to use Snowflake for?,Have you gone through different workload Snowflake can support? Do you foresee a opportunity there?,https://www.snowflake.com/guides/
4,Do you foresee using Snowflake for you own team/department or for the entire organisation?,"This is important to consider early on as it helps you make decision on long-term strategy. Snowflake, just like any cloud native tool has hu

SudhenduP

SudhenduP

-- Start with using the AccountAdmin Role to create the required roles, datawarehouse, database and grant sufficient privileges.
-- Note, in actual client implementation, you should avoid using ACCOUNTADMIN role and instead use SYSADMIN.

USE ROLE ACCOUNTADMIN;

-- Role creation and premission grants. 
DROP ROLE IF EXISTS IDENTIFIER('"POC_DATACLASSIFICATION"');
CREATE ROLE IDENTIFIER('"POC_DATACLASSIFICATION"') COMMENT = 'Role for Data Classification';

-- Please add your username below instead of USERNAME. 

SudhenduP

-- change the role 
USE ROLE ACCOUNTADMIN;

-- create necessary database objects

CREATE DATABASE KAFKA_CONNECT_DB;
CREATE ROLE KAFKA_CONNECT_ROLE;
CREATE SCHEMA KAFKA_CONNECT_DB.KAFKA_CONNECT_SCHEMA;
CREATE TABLE KAFKA_TABLE_IN (RECORD_METADATA VARIANT, RECORD_CONTENT VARIANT);
CREATE WAREHOUSE KAFKA_WAREHOUSE WITH WAREHOUSE_SIZE = 'XSMALL' WAREHOUSE_TYPE = 'STANDARD' AUTO_SUSPEND = 300 AUTO_RESUME = TRUE;

SudhenduP

name=mykafkaconnectsnowflake
connector.class=com.snowflake.kafka.connector.SnowflakeSinkConnector
tasks.max=8
topics=snowflake_in_topic
snowflake.topic2table.map= snowflake_in_topic:KAFKA_TABLE_IN
buffer.count.records=1
buffer.flush.time=10
buffer.size.bytes=5
snowflake.url.name=abc1234.snowflakecomputing.com:443
snowflake.user.name=thisismyusername

SudhenduP

╔══════╦══════╦════════╗
║ Database Object ║ Privileges ║
╠══════╬══════╬════════╣
║ Database ║ USAGE ║
║ Schema ║ USAGE CREATE TABLE CREATE STAGE CREATE PIPE ║
║ Table ║ OWNERSHIP ║
║ Stage ║ READ WRITE ║
╚══════╩══════╩════════╝