Snowflake

Created : 10th May 2022

sub-pages : API Access

• bring in data

  • create target table

  • create stage

  • create storage integration

    • allow access to account in cloud.

  • copy into table from stage

• send out data

• Manage Accounts

  • manage privileges

  • manage login ways for accounts

  • 
    

just groww things

create or replace table a(a variant);

insert into a select parse_json($${

    "orderList": [

        {

            "growwAction": null,

            "displayName": "BANKNIFTY 30 Jan 54800 Call",

            "companyShortName": "BANKNIFTY 30 Jan 54800 Call",

            "orderStatus": "EXECUTED",

            "qty": 15,

            "price": 1795,

            "buySell": "B",

            "exchangeTime": "2025-01-16T09:17:51",

            "tradeDate": "2025-01-16T00:00:00",

            "underlyingId": null

        },

        {

            "growwAction": null,...

        }

]

}$$);

create or replace table a as select row_number()over(order by 1 asc) as a, a as b  from a; 

select value:displayName::string, value:orderStatus::string, value:qty::int, value:price::double, value:exchangeTime::datetime, value:buySell::string from a, lateral flatten (input => b:orderList ) where A = 2;