cnukaus

create or preplace procedure `proc_name`
BEGIN
declare k_array ARRAY<struct><banner string, intiative_type string>;
set k_array =
( 
select array_agg(meta) from
(SELECT struct(banner,initiative_type) as meta
from storing_table
) t
);

cnukaus

- name: create dag to cloud composer
  host: all
  connection: local
  
  tasks:
    - debug:
      msg:
       = "cloud":"{{var declared in another yaml file}}"
       
     - name: create temp file

cnukaus

/**
 *Submitted for verification at FtmScan.com on 2021-04-25
*/

/**
 *Submitted for verification at FtmScan.com on 2020-09-19
*/

pragma solidity =0.6.6;

cnukaus

CREATE OR REPLACE PROCEDURE 'proj.dataset.sp_name' ()
BEGIN
  DECLARE min_value INT64;
  CREATE OR REPLACE TEMPORARY TABLE table_1 as
  (select 1 as A);
  
  -- INIT table build
  CREATE TABLE IF NOT EXISTS ds.table_target
  (id_1, STRING
  , date_1, DATE

cnukaus

steps:
- name: 'gcr.io/cloud-builders/docker'
  args:['build', '-t', '${_IMAGE_NAME}:latest'...'Dockerfile']
- name: 'gcr.io/cloud-builers/docker'
  args:['push','${_IMAGE_NAME}:latest']
- name: 'gcr.io/google.com/cloudsdktool/cloud-sdk'
  entry-point: gcloud
  args: ['run', 'deploy','${_SERVIE_NAME}','--image','${_IMAGE_NAME}:latest','--memory','1G'
  #'--service-account','${_SERVICE_ACCOUNT}'
  '--allow-unauthenticated']

cnukaus

### Keybase proof

I hereby claim:

  * I am cnukaus on github.
  * I am key1to1 (https://keybase.io/key1to1) on keybase.
  * I have a public key ASCkqEPAanJDRNtSa17QNTNBHThZK1y99pLWbzfpemYc6wo

To claim this, I am signing this object:

cnukaus

Keybase proof

I hereby claim:

• I am cnukaus on github.
• I am key1to1 (https://keybase.io/key1to1) on keybase.
• I have a public key ASCkqEPAanJDRNtSa17QNTNBHThZK1y99pLWbzfpemYc6wo

To claim this, I am signing this object: