René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"QAPage","mainEntity":{"@type":"Question","name":"# Rows inserted in 'Insert into Table Select * from Table' Stmt","text":"\u003cp dir=\"auto\"\u003e\u003ca class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/jeffreyaven/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/jeffreyaven\"\u003e@jeffreyaven\u003c/a\u003e Is there a way to figure out the # Rows inserted in 'Insert into Table Select * from Table' Stmt in Pystackql\u003c/p\u003e","upvoteCount":1,"answerCount":3,"acceptedAnswer":{"@type":"Answer","text":"\u003cp dir=\"auto\"\u003eactually we can add this to \u003ccode class=\"notranslate\"\u003epystackql\u003c/code\u003e \u003ca class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/vwake7/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/vwake7\"\u003e@vwake7\u003c/a\u003e by counting the stderr lines back from the \u003ccode class=\"notranslate\"\u003eexecuteStmt\u003c/code\u003e method, e.g.\u003c/p\u003e\n\u003cdiv class=\"snippet-clipboard-content notranslate position-relative overflow-auto\" data-snippet-clipboard-copy-content=\"stackql  \u0026gt;\u0026gt;INSERT INTO google.compute.instances(   project,   zone,   data__name,   data__machineType,   data__disks,   data__networkInterfaces ) \nstackql  \u0026gt;\u0026gt;SELECT   \nstackql  \u0026gt;\u0026gt;'stackql-demo-2' as project,   \nstackql  \u0026gt;\u0026gt;'australia-southeast1-a' as zone, \nstackql  \u0026gt;\u0026gt;instanceId as name, \nstackql  \u0026gt;\u0026gt;CASE instanceType \nstackql  \u0026gt;\u0026gt;WHEN 't2.micro' \nstackql  \u0026gt;\u0026gt;THEN 'https://www.googleapis.com/compute/v1/projects/stackql-demo-2/zones/australia-southeast1-a/machineTypes/e2-micro' \nstackql  \u0026gt;\u0026gt;END as machineType,\nstackql  \u0026gt;\u0026gt;'[{\u0026quot;autoDelete\u0026quot;:true,\u0026quot;boot\u0026quot;:true,\u0026quot;initializeParams\u0026quot;:{\u0026quot;diskSizeGb\u0026quot;:\u0026quot;10\u0026quot;,\u0026quot;sourceImage\u0026quot;:\u0026quot;https://compute.googleapis.com/compute/v1/projects/ubuntu-os-cloud/global/images/family/ubuntu-2004-lts\u0026quot;},\u0026quot;mode\u0026quot;:\u0026quot;READ_WRITE\u0026quot;,\u0026quot;type\u0026quot;:\u0026quot;PERSISTENT\u0026quot;}]'\nstackql  \u0026gt;\u0026gt;as disks,   \nstackql  \u0026gt;\u0026gt;'[{\u0026quot;subnetwork\u0026quot;:\u0026quot;https://www.googleapis.com/compute/v1/projects/stackql-demo-2/regions/australia-southeast1/subnetworks/default\u0026quot;}]' as networkInterfaces \nstackql  \u0026gt;\u0026gt;FROM aws.ec2_api.instances WHERE region = 'ap-southeast-2' AND instanceType = 't2.micro';\nThe operation was despatched successfully\nThe operation was despatched successfully\"\u003e\u003cpre class=\"notranslate\"\u003e\u003ccode class=\"notranslate\"\u003estackql  \u0026gt;\u0026gt;INSERT INTO google.compute.instances(   project,   zone,   data__name,   data__machineType,   data__disks,   data__networkInterfaces ) \nstackql  \u0026gt;\u0026gt;SELECT   \nstackql  \u0026gt;\u0026gt;'stackql-demo-2' as project,   \nstackql  \u0026gt;\u0026gt;'australia-southeast1-a' as zone, \nstackql  \u0026gt;\u0026gt;instanceId as name, \nstackql  \u0026gt;\u0026gt;CASE instanceType \nstackql  \u0026gt;\u0026gt;WHEN 't2.micro' \nstackql  \u0026gt;\u0026gt;THEN 'https://www.googleapis.com/compute/v1/projects/stackql-demo-2/zones/australia-southeast1-a/machineTypes/e2-micro' \nstackql  \u0026gt;\u0026gt;END as machineType,\nstackql  \u0026gt;\u0026gt;'[{\"autoDelete\":true,\"boot\":true,\"initializeParams\":{\"diskSizeGb\":\"10\",\"sourceImage\":\"https://compute.googleapis.com/compute/v1/projects/ubuntu-os-cloud/global/images/family/ubuntu-2004-lts\"},\"mode\":\"READ_WRITE\",\"type\":\"PERSISTENT\"}]'\nstackql  \u0026gt;\u0026gt;as disks,   \nstackql  \u0026gt;\u0026gt;'[{\"subnetwork\":\"https://www.googleapis.com/compute/v1/projects/stackql-demo-2/regions/australia-southeast1/subnetworks/default\"}]' as networkInterfaces \nstackql  \u0026gt;\u0026gt;FROM aws.ec2_api.instances WHERE region = 'ap-southeast-2' AND instanceType = 't2.micro';\nThe operation was despatched successfully\nThe operation was despatched successfully\n\u003c/code\u003e\u003c/pre\u003e\u003c/div\u003e\n\u003cp dir=\"auto\"\u003ecan you raise a feature request in \u003ccode class=\"notranslate\"\u003epystackql\u003c/code\u003e and we will work on this\u003c/p\u003e","upvoteCount":1,"url":"https://github.com/stackql/stackql/discussions/406#discussioncomment-9316545"}}}